In a tablix data region, set the sort expression for the data region or for each group, including the details group.
2. In the properties panel, click on the
Set Sorts...
button. Now, the sort dialog will be opened like below.
3. Refer Sort Data section to and create required sort expression in the sort dialog and click on the
OK
button.
A sort expression is created to sort ProductCategory
fields in descending order (i.e Z-A ). On report preview, the ProductCategory
field values will be sorted in Z-A alphabetical order. Respective column is highlighted in the below snap.
Download the above report design from link.
2. Click on the required group tablix member in the
Row Groups
or Column Groups
pane, now the respective tablix member properties will be listed in the properties panel.
3. In the properties panel, click on the
Set Sorts...
button. Now, the sort dialog will be opened like below.
4. Refer Sort Data section to and create required sort expression in the sort dialog and click on the
OK
button.
Download the above report design from link.