Interactive sorting In SSRS on Values - Matrix report

Wumar picture Wumar · Jul 3, 2014 · Viewed 9.3k times · Source

I want a interactive sorting in SSRS matrix report. From database we are getting 3 columns -PrimaryKey,Columns and Value.
We are grouping rows by Primary Key and grouping column by Columns and use Value as data.

My Matrix Report -

ID             [Columns]
[Primary Key]     Values

Output of the Matrix report -

ID  FirstName   MiddleName  Lastname
1   Rajiv         Jha        Sharma
2   Prem          Kumar      Bose
3   Usha          Shamila    Praveena

I am able to use the interactive sorting on ID because ID is group by rows but I want to use the interactive sorting on dynamic cloumns values like FirstName,MiddleName and LastName.

Expected result when we interactive sort on Lastname

ID  FirstName   MiddleName  Lastname
2   Prem         Kumar      Bose
3   Usha         Shamila    Praveena
1   Rajiv        Jha        Sharma

Thanks for any Help.

Answer

lethaljd picture lethaljd · Jul 10, 2014

Are you using the report wizard to build this? You should be able apply the interactive sort using the properties menu on the column groups.

By adding an interactive sort button to a column header you can allow a user to click the column header and sort the parent group rows in a table or matrix by the value displayed in that column. The order of child groups remains unchanged.

To add an interactive sort button to a column header to sort groups:

  1. In a table or matrix on the report design surface, right-click the text box in the column header for the group to which you want to add an interactive sort button.
  2. Click Text Box Properties.
  3. Click Interactive Sort.
  4. Select Enable interactive sort on this text box.
  5. In Sort, click Groups.
  6. From the drop-down list, select the name of the group that you are sorting. For groups based on simple group expressions, the Sort by value is populated with group expression.

For more info, see this article: http://technet.microsoft.com/en-us/library/cc627509(v=sql.100).aspx