Enabling the Interactive Sorting Feature in SSRS Reports

As promised in yesterday’s blog post, today I will show you how to enable the interactive sorting feature in a SQL Server Reporting Services (SSRS) report.

EnableInteractiveSorting-NoButtons

The objective will be to enable the interactive sorting feature in all of the columns in the above report. Notice that at the moment there are no arrow buttons (gold arrows) to sort the columns.

Start by opening your SSRS report in SQL Server Business Intelligence Development Studio (BIDS), and then right-click the column header box where you want to enable the interactive sorting feature. In this example it is the Share Name column (gold arrow).

EnableInteractiveSorting-ShareNameColumn

Next, select the Properties option.

EnableInteractiveSorting-Properties

On the Interactive Sort tab, check the Add an interactive sort action to this textbox box. Then, select the appropriate column in the drop down box.

Enabling the Interactive Sorting Feature - Interactive Sort Tab

Finally, click the OK button and you are done. Repeat these steps for each column that you want the interactive sorting feature to be available.

Enabling the Interactive Sorting Feature - Buttons

Now notice that when I run the same report, each column has the interactive sorting option (gold arrows).

Tomorrow we will post a video on how to use the interactive sorting feature and the search feature in SSRS reports. If you have any questions about this feature, please feel free to leave a note below in the comment section or contact @Enhansoft.

Showing 2 comments
pingbacks / trackbacks

Leave a Comment

Businessman Working - Reporting Feature
Share via
Copy link