The "flexibility"of the Hidden property.
When I develop reports for end users one of my goals is to minimize the amount of reports that I have to develop and to make reports as "flexible" as possible. One way that I have found that helps to minimize the amount of custom reports that I have to write is to creatively use the "Hidden" property to allow an end user to either hide columns or show columns on a report. Under the category "Formatting Tips" in my SSRS Tips and Tricks FAQ, I want to focus on two entries.
The first entry examines how easy it is to hide a column by simply adding a Boolean parameter to your report which represents the column you want to hide. Since the Hidden property is already a Boolean or a true/false value, all you have to do is simply add the parameter in the expression editor next to the Hidden property. In the example shown the "True" option is chosen and since the parameter is called HideProductNumber, then just placing the parameter into the Hidden property expression editor works perfectly.
The next example adds a level of complexity as it utilizes a multi-value parameter to build a list of columns on the report. If the user selects the column(s) this means that the column(s) will be hidden on the report. It adds the "flexibility" that I was referring to above where one report could display completely different columns just by the choices of the end user. When you think about this a little further you could add multiple sections to a report and allow the user to display any number of combinations of tables, charts, or matrices depending on the usage of the report.
This property definitely adds a dynamic capability to a report that can be utilized in clever ways. I would love to hear from others as to how you have creatively utilized the Hidden property in Reporting Services. I welcome your input...

Bob
Reader Comments (1)
I oftentimes use the Hidden property in various ways. Thanks for the creative post.
Best,
Jim