Search This Blog

Interactive Sorting in SSRS Reports

Interactive Sorting  in SSRS Reports

Many times you have requirement like clicking on column names or legend name will sort the complete column in either ascending order or descending order or if its is a value field then sort them alphabetically
This is what we call as Interactive sorting in SSRS Report.

Steps to Perform Interactive sorting in Your Report
Assuming that i have a report with Column Name EmpName displaying all columns Name

Select your EmpName Column -Right click on text box
-Text Box properties
-Interactive Sorting tab
-Check box-Enable Interactive Sorting on this textbox
Checkbox-Detail Row
sort by-EmployeeName or clicking Fx-Field!EmployeeName.value
Apply this Sortingto-"YourdatasetName"

Below ScreenShot showing all Properties.
Click ok 
Preview the Report 
Clicking on EmployeeName column Header will Sort the report alphabatically.

No comments:

Post a Comment