Skip to Content
0
Sep 06, 2016 at 08:11 PM

Report Selection based on Parameter Y or N

27 Views

I have a parameter called "Status" which will prompt the user for a Y or N. If they choose Y, then I only want to include Table1.Status='APPROV' and if they enter a N (or even leave it blank) then all possible values for that field will be included ie no restriction.

I've tried this but it doesn't work:

(if {?Status}='Y' then {Table1.Status}='APPROV' else {Table1.Status} in ('APPROV','PENDING','REJECTED')

Other variations doesn't work either. Since it's not just 2 values, it's not working. I can't conditionally suppress either.