0

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?

SqlLearner
  • 763
  • 8
  • 23
  • 37
  • 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 Oct 31 '14 at 17:45

1 Answers1

0

Try this:

=IIF(InStr(JOIN(Parameters!Sections.Label,", "),"A") And InStr(JOIN(Parameters!Fields.Label,", "),"X"), True,False)
Tab Alleman
  • 31,483
  • 7
  • 36
  • 52
  • Its not working when i select all in the 'Field' parameter which includes both X ,Y,Z – SqlLearner Oct 14 '14 at 20:46
  • Is "All" a separate option in the available values, or do you mean when you check X, Y, & Z? If the latter, then it should work unless you are not implementing correctly. – Tab Alleman Oct 15 '14 at 14:34