BusinessObjects Board

Including 'ALL' in list of values

building reports desktopintelligence
#1

Hi All,
Greetings to all

    I have prompt on supervisor name which includes 20 list of values. All the values should be selected at time by including 'ALL'in list of values.how it can be done and whether it is done at universe level or repoting level

please help me out in this regard !

Regards

BADRI.BAINDLA

BADRI (BOB member since 2005-08-10)

#2

Read the designer FAQ on BOB

highandstoned :netherlands: (BOB member since 2005-08-01)

#3

I guess, something like this will help

(@Select(Class\SubClass) IN @Prompt(‘Select Your Data or enter * for all ‘,‘a’,‘Class\SubClass’,multi,free) ) OR
(’*’ in @Prompt('Select Your Data or enter * for all,‘a’,‘Class\SubClass’,multi,free))

[Moderator Edit: I deleted your duplicate post which you had made 1 minute later.]

pvalters (BOB member since 2004-08-30)

#4

You will still need to set up the dummy objects and the Union query that will lead into this prompt - as suggested in the Designer FAQ - do a search on *ALL

ngosz :us: (BOB member since 2003-09-25)

#5

Hi there, I found exactly what I was looking for, but is there a way I can include the ‘*’ in the LOV?

ghostman :switzerland: (BOB member since 2006-01-12)

#6

See the following link, If your database is Oracle:

https://bobj-board.org/t/60982

BO_Chief :us: (BOB member since 2004-06-06)