Hide Column based up Parameter Selected SSRS

8
votes

I would like to set the visibility of columns based upon the value selected in a parameter.

The problem is I do not want a specific parameter to do this (i.e Hide column X True/False)

My report has several different "departments" who are only interested in certain columns.

What would be the syntax for example to hide the "Sales" column when the "Customer Care" parameter is set?

1
reporting-servicesreportingservice

1 Answers

22
votes

you can do these works step by step:

1- press right click of your mouse in your favorite column

2- select column visibility

3- from opened window select "Show or hide based on an expression" radio button

4- set an expression for hidden state. for example:

 =IIF(Parameters!CustomerCare.Value <> "favorite value", true,false)