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.

image

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.

image

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.

image

This will give you three cells as seen below.

image

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

image

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.

image

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

image

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

One 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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s