BusinessObjects Board

Entering "ALL" in a user prompt

I currently have a report build off of a data warehouse and have a couple of user prompts in the report. When running the report, I want to be able to enter “ALL” in one of the prompts. However, it does not recognize ALL. What needs to be done to be able to choose ALL?


cwhittington (BOB member since 2007-08-13)

Hy,

try using something like this:

@Select(Class1\Customer Class) IN @Prompt('CustomerClass (* for all):','A','Class1\Customer Class',multi,free,not_persistent,,user:0)
OR
( '*' in @Prompt('CustomerClass (* for all):','A','Class1\Customer Class',multi,free,not_persistent,,user:0))

biankutzu22 :romania: (BOB member since 2008-05-16)

Hi,

Read these 2 entries in Designer’s FAQ:


Marek Chladny :slovakia: (BOB member since 2003-11-27)