Search code examples
reporting-servicesssrs-2012ssrs-tablix

How can I display or hide a table column based on the parameters passed to an SSRS report?

I have an SSRS Report with 4 parameters. Parameter 1 = Country. The list of valid values for country is: 1,2,3,4,9,16.

When parameter is in 1,2,3,4 I'd like to set the visibility of a textbox to true. If parameter is 9 or 16 then I'd like to hide the column.

I've tried: 

=IIF((Parameters!CountryList.Value in (1,2,20,21), true,false))

"In" is not a valid operator in Visual Basic. I feel like this should be easy but haven't found an "in" equivalent. Any insight is appreciated.

Solution

  • Try this. Based on the least parameters to test.

    =IIF(Parameters!CountryList.Value ="9" OR Parameters!CountryList.Value = "16", False,True)