reportingreporting-servicesservice
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?
Here's a solution by KarenH in the article Hide/Show Items Dependant On Export Format
Basically, you can set the DataElementOutput = NoOutput on the control you want to hide.
This worked for me to hide tables when exporting to CSV.
The expression
=IIF(Parameters!ImportStatus.Value = "M",true,false)
will give the same result as
=(Parameters!ImportStatus.Value = "M")
The expression you need to give specifies whether or not to hide the column, so to show a column where @ImportStatus = "M", you would simply reverse the logic:
=Not(Parameters!ImportStatus.Value = "M")
Best Answer
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: