CODEWITHSUNDEEP
reporting-servicesreportingservice
David Adlington
David Adlington

Reputation: 666

Hide Column based up Parameter Selected SSRS

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?

Upvotes: 8

Views: 37526

Answers (1)

masoud ramezani
masoud ramezani

Reputation: 22920

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)

Upvotes: 24

Related Questions