reporting-servicesssrs-2008ssrs-2012ssrs-2017

SSRS report collapsing and expanding part of the table


I have a table of many columns:

Column names/table

Is there a way to make collapse/expand feature to the table part "Product Shelf Life History"? Because the tablix is too big, the user has to scroll all the way to the right side. That part is not important and should be hidden if not needed.


Solution

  • You can add a parameter to the report and correlate it to the visibility of those columns.

    For example:

    It doesn't have to be a Boolean, it is just an example. You can also use a dropdown with the two options or you can even add more.