Alternative prompts

[misdeveloper]

I wish to present the user with a prompt, giving the option to report on a set of data EITHER by a date range OR by a single month (in addition to two other matching criteria).

Is there any way of presenting the user with a prompt box in which they can fill in the two mandatory criteria and then (for the date) either one prompt field or another?

Very grateful for any help!

 

[PAULSGS]

When you are in the Query panel, in the Conditions section, if you click on the "AND" between two conditions it will change to an "OR"

You need to build your two date prompts around such an "OR"

 

[pwarr]

You might want to include a trick to allow the user to skip the prompt
example

('SKIP' in @prompt('Enter month or type SKIP to ignore this prompt','A','Class\Object',multi,constrain)
OR
Month in @prompt('Enter month or type SKIP to ignore this prompt','A','Class\Object',multi,constrain))

You can do this by editing the SQL and clicking the do not regenerate box. If the user types the word SKIP into the prompt which is share by the 2 conditions then the second condition is ignored

 

[promero]

>You can do this by editing the SQL and clicking the do
>not regenerate box.

You can also make a filter in the universe with that expression, and use that filter in the query panel of the report.

 

[skrandel]

Check out this tip from this months BO Newsletter:

http://www.businessobjects.com/newsletter/NL0032/us/tips_tricks.htm

Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com