Column visibility based on 2 parameters in SSRS

Question

I have a parameter 'Section' which has values A,B,C and another parameter 'Field' which has values X,Y,Z. now my requirement is i need to make column visibility based on both the parameters,if my parameter 'section' is A and parameter 'field' is X then the column should be shown else hidden.both are multi-valued parameters. I have written the following expression which is not allowing me to run

=IIF(InStr(JOIN(Parameters!Sections.Label,", "),"A"),InStr(JOIN(Parameters!Fields.Label,", "),"X", False,True),True)

Error i am getting while running the report is "Input string was not in a correct format. Can anyone help me in correcting the format?

what should happen if you chose multiple select? column value should select base on row value ( like first row has 'A' and 'X' ) then value is blank , 2nd role has 'B' and 'Y' then value is there?) — Sanjay Goswami

Tab Alleman Tab Alleman · Accepted Answer · 2014-10-14T19:20:18

Try this:

=IIF(InStr(JOIN(Parameters!Sections.Label,", "),"A") And InStr(JOIN(Parameters!Fields.Label,", "),"X"), True,False)

Column visibility based on 2 parameters in SSRS

1 Answers