Search code examples
matrixreporting-servicesreportingssrs-2008-r2ssrs-2014

Sort Column Group in SSRS Matrix

I created a report using matrix and I want to add interactive sort for it's column group. When I add interactive sort for Sales Amount it does not work.

This is my first look of my report:

enter image description here

and when I click on sort arrows it turn to this one:

enter image description here

nothing happened an the value of Australia changed!!!

But I do it with Table and it works good.

How I can sort such these columns in column groups in matrix?

thanks

Solution

  • I am trying to recreate your scenario in order to reproduce your issue. First I created a tablix with this columns and groups.

    enter image description here

    For interactive sorting I selected the Sales column header, right clicked went to Text box Properties... and set this settings in the Interactive Sorting tab.

    enter image description here

    This will sort Countries based on the sales sum while Sales Territories keep the same. If you want to order the Sales Territories just select that group name in the Groups option.

    enter image description here

    This is a test:

    enter image description here

    Use this step-by-step guide, if the Australia sales value keeps changing try deploying the report to a server, I've encountered cases when VS viwer doesn't handle applied JavaScript correctly. Also consider sharing your data in order to check if the issue is related to it.

    Let me know if this helps.