Hide column based on option selected by SSRS

Question

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

The problem is that I don’t want a specific parameter to be set for this (i.e. hide the column X True / False)

There are several different “departments” in my report that are only interested in specific columns.

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

Answer 1

You can follow these steps step by step:

1- right click in your favorite column

2- select column visibility

3- " "

4- . :

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