Visibility using multiple select

Question

Visibility using multiple select

Johnny D

Ten Centuries

Points: 1030
More actions
February 24, 2015 at 2:27 am

#294809

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.

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

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

sql Sarah SSCrazy Points: 2081 More actions · Answer 1

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"

Johnny D Ten Centuries Points: 1030 More actions · Answer 2

Thanks a million Sarah.

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