Search results
PDF

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

  1. Select tablix data region in the design area. Filter dialog
  2. In the properties panel, click on the Set Sorts... button. Now, the sort dialog will be opened like below. Sort dialog
  3. Refer Sort Data section to and create required sort expression in the sort dialog and click on the OK button. Filter dialog

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.

Filter dialog

Download the above report design from link.

Set sort expression on a tablix group

  1. Click on the surface of the tablix data region to open grouping panel. Filter dialog
  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. Filter dialog
  3. In the properties panel, click on the Set Sorts... button. Now, the sort dialog will be opened like below. Sort dialog
  4. Refer Sort Data section to and create required sort expression in the sort dialog and click on the OK button. Filter dialog

Download the above report design from link.