• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3810
  • Last Modified:

SSRS Matrix Report: How to sort column based on sequence number

One of my columns for the matrix report is taskcode. Right now it sorts the taskcode's alphabetically. I created a table and assigned a sequence to each of the taskcodes that I am reporting on and want to sort based on that sequence instead of having it sort them alphabetically. I tried adding the sequence table to the view and I can sort successfully inside of the query but on the report itself it seems to ignore that logic. Any feedback on how to accomplish this would be greatly appreciated.
1 Solution
ValentinoVBI ConsultantCommented:
You can specify the sorting order directly on the matrix.  With the tablix selected, locate the group on which you'd like to sort (using the Row/Column Groups panes below the design surface).  Open the Group Properties and switch to the Sorting page.  By default it will have added your group field but you can change this to your newly-added sequence field.
J CAuthor Commented:
That is perfect. Thank you!

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now