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

0
votes

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.

1
reporting-servicesssrs-2012ssrs-tablix
So where did the values 20 and 21 come from? Anyway, if you want to hide based on 2 values. Use OR. – SS_DBA

1 Answers

1
votes

Try this. Based on the least parameters to test.

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