CODEWITHSUNDEEP
matrixreporting-servicesreportingssrs-2008-r2ssrs-2014
DooDoo
DooDoo

Reputation: 13437

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

Upvotes: 0

Views: 3957

Answers (3)

Mike Honey
Mike Honey

Reputation: 15017

I think you are wasting your time trying to get Interactive Sorting to do that. The feature is too primitive for your scenario.

Instead I would add a Report Parameter to control the sort, and use it to drive Sort By Expressions which you can control at each Group level.

The user experience is less interactive, but it actually works.

Upvotes: 0

alejandro zuleta
alejandro zuleta

Reputation: 14108

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.

Upvotes: 2

user1347948
user1347948

Reputation:

You will need to sort at the group Level. This would be the Row GroupName. Sort by would be the SUM(SalesAmount) And you would apply that sorting to all groups within the entire dataset.

Upvotes: 0

Related Questions