Hide Column based up Paramater Selected SSRS

Question

I would like to set the visiblity of columns based upon the value selected in a paramater.

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

My report has several diffrent "departments" who are only intrested in certain columns.

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

Answer 1

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)