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.