Visibility using multiple select

  • Hi,

    And thanks in advance.

    I have a multi-valued parameter which has the following select options 'A1', 'A2', 'A3', 'A4', 'A5', 'A6','A7','A8'

    I would like the visibility of a table based on and expression that will only make one table visible if A1, A2 and A3 are selected. And if A4,A5,A6 are selected then another table and if A7 and A8 selected then a different table.

    I tried the following but with no luck.

    =iif(instr(Join(Parameters!Control_Group.Value,","),"A1")>0,false,true) AND iif(instr(Join(Parameters!Control_Group.Value,","),"A2")>0,false,true) AND iif(instr(Join(Parameters!Control_Group.Value,","),"A3")>0,false,true)

    However this did not work.

    Any help would be appreciated. Many Thanks.

  • Johnny D (2/24/2015)


    Hi,

    And thanks in advance.

    I have a multi-valued parameter which has the following select options 'A1', 'A2', 'A3', 'A4', 'A5', 'A6','A7','A8'

    I would like the visibility of a table based on and expression that will only make one table visible if A1, A2 and A3 are selected. And if A4,A5,A6 are selected then another table and if A7 and A8 selected then a different table.

    I tried the following but with no luck.

    =iif(instr(Join(Parameters!Control_Group.Value,","),"A1")>0,false,true) AND iif(instr(Join(Parameters!Control_Group.Value,","),"A2")>0,false,true) AND iif(instr(Join(Parameters!Control_Group.Value,","),"A3")>0,false,true)

    However this did not work.

    Any help would be appreciated. Many Thanks.

    When you put an expression in there, it only has to evaluate to True or False.

    The expression sets the visibility property to hidden when it is evaluated to True.

    Lets say that for Table 1 should be visible if the parameter value is A1, A2, or A3.

    Here is the expression I would use (again, this expression Hides the table when evaluated as True):

    =Parameters!Control_Group.Value <> "A1" or Parameters!Control_Group.Value <> "A2" or Parameters!Control_Group.Value <> "A3"

  • Thanks a million Sarah.

    I was over complicating it. Much appreciated.:-)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply