Interactive sort over multiple groups in ssrs - 【StackMirror】|reporting-services|reportingservices-2005

I have a report that is grouped by Region and then Office location. The users would like the ability to sort on a date value. I can get it to work for the innermost group (Office location). However they want it to sort the whole table. Any ideas?

2009-06-16 18:16
by Bob Cummings

Add sorting to the table column.

Right click on the table column -> Properties
Click on Interactive Sort
Click "Add interactive sort"
For the Sort Expression, put "=Fields!COLUMN_NAME.Value"

2009-06-17 19:23
by jgallant

Jon when I do that, it only sorts within the Office Location (inner most)group. The users would like it to ignore the grouping and just sort. Why they want the grouping and then the ability to over ride the grouping is beyond me. Thanks for trying - Bob Cummings 2009-06-17 19:40

Kinda sounds like your going to have to make them compromise : - jgallant 2009-06-17 19:58

Yeah I think 2 reports is the only answer. thanks agai - Bob Cummings 2009-06-17 20:08

I solved this by using a hidden Chart placed outside the Groups. Set as the following, for the column header that holds the interactive sort:

enter image description here

And for the chart:

enter image description here

At the Category Group, go to Properties, and remove any Sorting from there.

2015-06-21 04:32
by Irawan Soetomo

Another simple way to solve this is to add two tablixs. One with the grouping, the other without.

Then you can add a "Group on X" boolean param and show and hide each tablix dependent on the users selection.

The best of both worlds and no need for two separate reports. The user can easily sort and export the entire dataset if required.

2016-04-13 07:57
by will webster