SSRS - how to collapse all rows except first row

Theresa Niemet 21 Reputation points

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,727 questions
0 comments No comments
{count} votes

1 additional answer

Sort by: Most helpful
  1. ZoeHui-MSFT 30,411 Reputation points

    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.



    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 No comments