I had search many topic about multiple parameter but no solution with my case.
I have SP like this
@flag varchar (10)
IF (@flag = 'A')
BEGIN
select Team, count(wait) Total
FROM Table
END
ELSE IF (@flag = 'B')
BEGIN
select Team, count(Courtesy) Total
FROM Table
END
In the SSRS:
Dataset from SP above.
Parameter name Flag with Allow multiple values, available values add 2 specify values A and B.
Created 2 tablix use the same dataset name ( one the data A and the other for data B).
On the tablix properties A, under Visibility, added expression
= IIF(InStr(Join(Parameters!Flag.Value,","),"A") > 0, False, True)
On the tablix properties B, under Visibility, added expression
= IIF(InStr(Join(Parameters!Flag.Value,","),"B") > 0, False, True)
Test run for each multiple selection and the tablix will show and hide correctly for select A or B
But when select ALL then both tablix show up BUT no data at all.
Am I missing something here? Thank you for your help.