August 20, 2014 at 9:24 am
In a table with some grouped rows (sales grouped by country, region and city) I wish to add "interactive sorting" for the sales column.
The "interactive sorting" works fine but only within ONE group or details.
What I want is to sort within ALL groups and details:
Groups sales
--------------------------
Group 1 Germany 561
Group 2 Region West 159
Group 3City 3 64
Group 3City 8 54
Group 3City 5 41
Group 2Region Süd 150
Group 3City 4 99
Group 3City 9 51
Group 2Region Nord 133
Group 3City 7 50
Group 3City 98 48
Group 3City 2 20
Group 3City 10 15
Group 2Region Ost 119
Group 3City 90 74
Group 3City 15 45
I look forward to get some responses.
August 20, 2014 at 11:00 am
Unfortunately the built-in interactive sort in SSRS only allows you to sort on one column at a time. Another option is to have Sort By parameter (or parameters) on the report and then apply the sort on rendering using expressions.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply