Search code examples
reporting-servicesssrs-2008ssrs-tablix

How do I make hidden information appear below a row rather than next to it?

I have a table that shows the report name, report path , and the user who ran that report. I have currently added the user information in a column next to report name and report path and I have made it hidden and it only appears when you click on the report name data field. I am looking to achieve the following results : show the report name and report path only once(my current setup shows repeating report names and report paths because different users ran the same reports) and click on it to expand and show the different users that ran it. I believe this could be achievable by grouping but Im not sure how .

More information :

This is how my tablix looks right now

+----------------+---------------+-------------+
| [+Report Name] | [Report Path] | [User Name] |
+----------------+---------------+-------------+

The + sign toggles the visibility of [User Name]

However I would like to be presented like so:

+----------------+---------------+
| [-Report Name] | [Report Path] |
+----------------+---------------+
| [User Name]    |               |
+----------------+---------------+
Solution

  • As you express in comments this is a possible solution:

    I have this dataset as example:

    enter image description here

    Create a tablix with the following data arrangement:

    enter image description here

    Select the User row and right click it, select Row Visibility

    enter image description here

    Set the visibility to toggle by ReportPath

    enter image description here

    In the preview You can show or hide the user based on the toggled by setting:

    enter image description here

    Let me know if this was helpful