The SSRS Interactive Sort is similar to the SQL ORDER BY Clause. Interactive Sorting is useful to provide sorting control to end-user, as we see in popular e-commerce websites like Amazon.
Interactive Sorting in SSRS provides Up & Down arrows to toggle between Ascending Order and Descending order. In this article, we will show you, How to enable Interactive Sort (Sorting data at the Text box level) with an example.
We use the below-shown report to explain SSRS Interactive Sort in Reports. Please refer to the Table Report, Shared Data Source, and Dataset articles. It’s a simple SSRS report with Product Name, Color, Sales Amount, and Tax Amount columns.
If you observe the above screenshot, it displays the data in an unsorted manner.
SSRS Interactive Sort example
First, Select the Header Textbox of the report, and Right-click on it will open the context menu. Please select the Text Box Properties.. option from it.
Once we click on the Text Box Properties.. option, a new Text box Properties window will be opened. Please select the Interactive Sorting tab.
Click on the SSRS Interactive Sort Tab will display the below properties
- Enable interactive sorting on this text box: If you want to enable on this selected text box, then please choose this option.
- Detail Row: If you want to enable the interactive sorting on Details Row, then please select this option.
- Groups: Use this to enable the interactive sorting on Grouping Column.
- Sort by: It allows you to select the available Column from the Dataset. Or we can create an Expression by clicking the fx button. For instance, If you want to sort the data by Product Name, select that column name.
NOTE: SSRS Interactive Sorting applies to individual Columns. If you select the wrong column as Sort By, you may end up with incorrect results. For instance, you enabled the Interactive Sorting on Product Name and assigned the Color column as Sort by. If this is the case, then when you click on Product name, data will be sorted by color instead of Product Name.
In this example, We are going to apply interactive Sorting on [English Product Name]. So, Please select the [English Product Name] as Sort By Expression.
Click the Ok button to finish enabling Interactive Sorting for the Product name. Let us Preview the SSRS Interactive Sorting Report
If you observe the above screenshot, data is sorted by the Product Name in Ascending Order.
Let us click the down arrow to sort the data in Descending order
Let us enable the Interactive Sorting for the remaining columns such as Color, Sales Amount, and Tax Amount using the steps mentioned above and see the preview.
It is how we provide the Dynamic sorting option to end-users.