SSRS report collapsing and expanding part of the table

Question

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.

Answer 1

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

For example:

• Create a parameter (Boolean) and set the default to false.
• Right click the column and go to Column Visibility.
• Select Show or Hide based on an expression.
• Create an expression, =IIF(parameter == True, True, False)

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.