BusinessObjects Board

designer filter

I need to create a universe prompt that will enable the user to enter one or more values by which to filter, or to return all records (ie no filter).
I have seen this done, where the word “ALL” was entered.

Help would be appreciated.

Thanks

cheers
JD


jitesh :australia: (BOB member since 2005-05-20)

ok here you go…

Alter the LOV of the object to look like this

SELECT 'ALL'
UNION
SELECT distinct ....

Then your filter definition should be along the following lines…

table.col IN @PROMPT('<message>','A','LOV PATH',MULTI,FREE/CONSTRAINED) OR 'ALL' IN @PROMPT('<message>','A','LOV PATH',MULTI,FREE/CONSTRAINED)

Prateek Shah :india: (BOB member since 2005-07-24)

Designer FAQ 8)


Dave Rathbun :us: (BOB member since 2002-06-06)