How to enable and configure interactive (dynamic) sorting on your SSRS reports.

In reporting server you can build reports which are sorted in a specific way. However sometimes it depends on the usage of the report on which column a report should be sorted. User A want to sort it on column X and user B wants to sort it on column Y. To configure dynamic sorting on your SSRS reports you need to do the following:

1. Open your SSRS report.
2. Select the header of the column on which you want to enable interactive sorting.
3. Open the properties of the Text properties window.
4. Tick enable interactive sorting on this text box.
5. Select the columns of the dataset you want to sort on.
6. Repeat previous steps for all columns on which you want enable interactive sorting.See the red circles for which columns interactive sorting is enabled.

Enjoy building nice reports.