The SSRS Interactive Sort is similar to SQL ORDER BY Clause. Interactive Sorting is used to provide the 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 SSRS Interactive Sort (Sorting data at Text box level) with an example.
TIP: It is always better to apply Sorting at Textbox level (Interactive Sort) only because it will allow the user to dynamically sort the records.
We are going to use the below-shown report to explain, SSRS Interactive Sort in Reports. Please refer SSRS Table Report article to understand the Shared Data Source and Dataset we used for this report. If you observe the below screenshot, It was a normal report with Product Name, Color, Sales Amount and Tax Amount columns.
If you observe the above screenshot, it is displaying the data in an unsorted manner.
SSRS Interactive Sort example
First, Select the Header Textbox of the SSRS 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 as shown in below screenshot.
Click on the Add button will display the below properties
- Enable interactive sorting on this text box: If you want to enable the interactive sorting on this selected text box then please select this option as shown in below screenshot.
- Detail Row: If you want to enable the interactive sorting on Details Row then please select this option.
- Groups: If you want to enable the interactive sorting on Grouping Column then please select this option.
- Sort by: It will allow you to select the available Column from the Dataset or we can create our own Expression by clicking the fx button. For instance, If you want to sort the data by Product Name then select that column name.
NOTE: Interactive Sorting is applied to individual Columns. If you select the wrong column as Sort By then you may end up with wrong results. For instance, you enabled the Interactive Sorting on Product Name and assigned Color column as Sort by. If this is the case then, when you click on Product name data will be sorted by colour 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 Report
If you observe the above screenshot, data is sorted by the Product Name in the 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 above mentioned steps and see the preview
This is how we provide the Dynamic sorting option to end users.
Thank You for Visiting Our Blog