This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 0%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETN%3C/text%3E%3C/svg%3E)
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 90%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
You could do this,
Filter that first row in database by something for example if latest date mark that row in new column as 'Yes' - Then Create a child group by that row and do not hide it or toggle it, then for rest of the data create a toggle - Hopefully this will help
It's not possible to achieve your requirements; it's an all or nothing on toggle.
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.