BusinessObjects Board

Adding a Condition

All,

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’)

Thanks in advance


schip (BOB member since 2004-02-27)

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).

Hope this helps,

Joe :slight_smile:


mtb4ever (BOB member since 2003-11-20)

Or create a predefined condition in Business Objects Designer. Please, see the Designer FAQ for more details on this.


Andreas :de: (BOB member since 2002-06-20)