I have created a fiscal report in which I want to prompt the user the ability to include Revenue into the report. The revenue transactions are stored in the DB as account type 50. So essentially I want the user to select:
'Yes' for the filter to be disabled (allowing ALL transactions to be reported)
'No' for the filter to be account_type <> '50' (exclude revenue transaction types)
My other prompts are straight forward (Fiscal YEar & Fiscal Period).
I have searched the forums in vain only to find posts that are clear as mud!!!
Thank you to all for your help!!!
I think this filter expression might be what you want. Will exclude '50' if they pick 'No' and won't evaluate account type at all if they pick 'Yes'.
Filters ought to evaluate to a simple boolean without conditional (if, case) statements.
( ?IncludeRevenue? = 'No' and [Account Type] <> '50' )
or
( ?IncludeRevenue? = 'Yes' )
I think this may have worked!!!
Mucho Gracias!!!