Sort data in a tablix data region
In a tablix data region, set the sort expression for the data region or for each group, including the details group.
Set sort expression for tablix data region
- Select tablix data region in the design area.
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.
Set sort expression on a tablix group
- Click on the surface of the tablix data region to open grouping panel.
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.