Share via

SSRS - how to collapse all rows except first row

Theresa Niemet 21 Reputation points
2020-10-22T13:07:46.707+00:00

I have a report with one grouping. Currently, I have the details of each group hidden until the user clicks the toggle field to expand the detail rows. However, I would like the first row in each group to always show. How would I go about achieving this goal? Any help would be much appreciated.

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,878 questions
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 35,556 Reputation points
    2020-10-23T02:17:42.797+00:00

    Hi @Theresa Niemet ,

    It is impossible to meet your needs from SSRS side.

    As Olaf said, the action is an all or nothing on toggle.

    If the first row data in each group will not change, you may directly add the data to the table.

    Regards，

    Zoe

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments