Show or Hide SSRS column based on specific parameter value

reporting-services parameters ssrs-2008 ssrs-expression
NonProgrammer picture NonProgrammer · Dec 18, 2014 · Viewed 28.1k times · Source

I am having trouble showing/hiding a column based on parameter value chosen.

How my report is set up: Parameter: ImportStatus --ImportStatus parameter has three values you can choose from: M, V, E

If I choose ImportStatus value = 'M', then I want the report to display a specific column.

Currently, if I go to Column Visibility screen of a column I want to show/hide, I am able to hide column for all values instead of specific. Any idea how to do this correctly?

My expression:

=IIF(Parameters!ImportStatus.Value = "M",true,false)

Answer

SQLDiver picture SQLDiver · Dec 31, 2014

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")

Related questions

SSRS 2008: error message saying my parameter doesn't exist but it clearly does?

I have a report that has about 10 parameters and about 10 datasets and one datasource. I typed alot but I really need help so I figured I would try and provide as much info about the problem as I could right …

Read More
SSRS Grey out Parameter based on result from other Parameter

I wondered if it was possible to grey out a parameter based on the the result from another parameter? In this case, if specify date is set to 'No' then Start Date and End Date should be greyed out. As …

Read More
Passing multiple values for a single parameter in Reporting Services

I have several Multi-Select parameters in my report. I am trying to find a way to pass in multiple values for a single parameter in the web query string? If I pass in a single value, it works fine. The …

Read More