SSRS Interactive Sorting a Matrix

Sorting a matrix report can be done interactively. To perform interactive sorting, your report you will need a cell to click on to perform the action. In the image below you can see a basic matrix report with State as the row group, with year and quarter as the column groups. You want to be able to interactively sort the report on all of these groups.


There is an empty cell above the state and this can be the location for the sorting actions. First you need to create two more cells though, because you want to sort on all groups.

To do this right click on the black cell and select Split cells.


This gives you two cells now. You still need one more. Right click on the row at the top and select Insert Row, outside group above.


This will give you three cells as seen below.


In the blank text boxes you can now type in a descriptive text like “Sort by Year”.


To set up the sorting right click on the sort by year text box and select text box properties. Then select interactive sorting. Place a check next to Enable interactive sorting on this text box. Place the radio button next to Groups and select year in the drop down below then click ok.


Repeat these same steps for the other cells and your users will be able to sort the report using these cells.


This entry was posted in SSRS, Syndication and tagged . Bookmark the permalink.

1 Response to SSRS Interactive Sorting a Matrix

  1. Mohan says:

    Looks cool. Is there a possibility to sort based on the amount. Like if they click Q3 CY 2005, it should sort the entire row based on the Reseller amount in Q3 CY 2005.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s