Share via

How do I retain SSRS group expansion when an interactive sort is performed on a header?

Feuerborn, Thomas 0 Reputation points
2024-05-09T13:59:50.4866667+00:00

I have a very simple SSRS report.

Data is grouped, and upon initially running the report, the data is collapsed into two groups.

I show totals for the group, and have the + sign to expand either. ALL GOOD.

When I expand the first group, I see the detailed data. ALL GOOD.

One of the columns contains data from a DISTRICT. I enabled INTERACTIVE sorting on that column. ALL GOOD.

However, when I click on the DISTRICT column in order to sort that group's data, the entire group COLLAPSES, back to the original screen with just 2 summary lines. I have to RE-EXPAND the group to see the sorted data.

Is there a way to KEEP THE GROUP EXPANDED when an interactive SORT is done via the column header?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,835 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,941 Reputation points
    2024-05-10T02:18:11.7266667+00:00

    Hi @Feuerborn, Thomas,

    I think that the group will be collapsing because the interactive sort will re-run the report and then report will re-rendered.

    It is by design, temporarily we could not change it.

    You may share your idea here, the product team will consider to add the feature.

    For Suggestions/Other Ideas: Tell us how this impacts your business operations and how what you're asking for will enable/unblock your scenario.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments