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

Posted on 2012-09-04
Last Modified: 2012-09-05
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.
Question by:J C
    LVL 37

    Accepted Solution

    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.

    Author Comment

    by:J C
    That is perfect. Thank you!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Suggested Solutions

    Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
    This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now