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?
Add sorting to the table column.
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:
And for the chart:
At the Category Group, go to Properties, and remove any Sorting from there.
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.