CODEWITHSUNDEEP
reporting-servicesssrs-2012ssrs-tablix
user5085862
user5085862

Reputation: 7

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.

Upvotes: 0

Views: 1490

Answers (1)

SS_DBA
SS_DBA

Reputation: 2423

Try this. Based on the least parameters to test.

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

Upvotes: 1

Related Questions