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?
A:
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"
Jon
2009-06-17 19:23:04
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:15
Kinda sounds like your going to have to make them compromise :)
Jon
2009-06-17 19:58:46
Yeah I think 2 reports is the only answer. thanks again
Bob Cummings
2009-06-17 20:08:02