I'm adding a prompt to my report that selects records based on Status. Here are the available values:
Approved = 1
Cancelled = 2
Suspended = 3
Unapproved = 4
The SQL statement in my report uses an IN clause to select the records to return.
My issue is that the user would like another option called Non-Cancelled; which would be values 1, 3, and 4. I assume that I need an expression for the prompt value. I have tried "1,3,4" and "=(1,3,4)" and "(1,3,4)". None of these have worked. I either get errors or no records are returned.
Can I do this. Any suggestions on the expression I need to make this work would be greatly appreciated. I can always have a multiple value parameter and let the user select multiple options but I would rather do it this way if I can. Thanks for the help.......