I have a table of many columns:
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.
You can add a parameter to the report and correlate it to the visibility of those columns.
For example:
=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.