question

qplcjp avatar image
qplcjp asked

SSRS Show all with multiple select

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.

ssrsparameters
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.