How to add interactive sorting for tablix and matrix header in the report
Find the following steps for adding the interactive sorting for tablix or matrix report item header
- Open the report in the report designer and right-click the text box in the column header that you want to add an interactive sort button, and then click Text Box Properties.
- Click User sort as shown in the following image.
- Provide the expressions in sort expression as shown in the following image.
You can repeat this action for multiple textboxes of the tablix or matrix headers.