Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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


Comments

Leave a comment on the original post [mikedavissql.com, opens in a new window]

Loading comments...