I am working on say employee data. In the query panel I want to add a condition which allows me to either a select a particular mgr say “Mark” or if the user types “ALL”, I would like the report to retrieve all the employees for all the mgrs.
I created the following condition
Mgr Equal to prompt (‘Enter Manager’)
Now, how do I add an “OR” condition with something like this
“ALL” equal to prompt(‘Enter Manager’)
Try using Matches Pattern as the operator rather than Equal To, and in the prompt indicate tpying % will return ALL. For example, "Mgr Matches Pattern Prompt (Enter Mgr or type % for ALL Mgrs).