I am developing a report in SSRS 2008 R2 that is based on a dataset that has a column "row type" and I need to hide the initial visibility based on the valu contained in that column (only two values are returned) and then be able to toggle the visibility of the rows. The dataset is returning both the detail and summary rows – detail first then summary for each group – grouping and sorting being done in the stored procedure (no grouping in the report). This is a requirement that is out of my hands. What I would like to accomplish is having the detail rows hidden when the report is run with a toggle indicator on each summary row that when clicked will display the detail rows for that summary. Is this possible?
SSRS 2008 Toggle visibility of rows based on data contained in row
reporting-servicessql-server-2008ssrs-2008
Best Answer
You need to create groups. If you have some way that your summary rows from the dataset are linked to specific data rows, then you should group on that.
Or you could group on the "Row Type" column. Keep the formula you are currently using for detail row visibility, and use the group header to toggle visibility. You can hide the group header for your summary rows using a visibility formula with the logical inverse of your current formula. This will it visible for the detail rows.