[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • Last Modified:

set visibility of a column in a table based on a parameter

how do i set the visibility of a column based on a parameter in a report using SQL Server reporting Services,
1 Solution
of an entire column?  You would do this....

1) Highlight the entire column by clicking the gray column button at the top of the table
2) In the properties window, scroll down to Visibility
3) Click the plus sign
4) Pull down the drop-down next to "Hidden" and choose Expression
5) In the right hand expression window, your expression will look something like this:

=IIF(Parameters!MyParameter.Value = "HideTheColumn", True, False)

That's it.  Working with the IIF statement above, essentially, if my parameter called "MyParameter" is set to "HideTheColumn" then the column will be hidden, else hidden=false.
vinny45Author Commented:

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now