SSRS interactive sorting is collapsing my data groups
Using SSRS 2005. I have a report that has a data grouping, and the report starts with the rows collapsed for the grouping. I also have interactive sorting on the column headers. If I expand the group, then click the sorting arrows, the data group collapses, presumably the report is being re-run with my specified sort order, and the initial collapsed state of the grouping is applied. Any quick workarounds?
I think you are seeing the report refresh with you choice applied so the original format is also re-applied. Nearly everything in SSRS is open to coding so you could write a procedure to alter the hidden/visibleness of the groups when you change the sort order. You could just hijack the sort click event too I expect. Do you have a document map on the report? If that is there do you 'have' to have the groups expanded?