BusinessObjects Board

Prompt with 'ALL'

building semantic layer
#1

Hi,
I need to have a prompt, for example for object1.How can i add ‘ALL’ in the list of values and when I select ‘ALL’ all the LOV should be displayed.
I tried the code below but not getting exactly what I needed.Its propmting twice for object1.

(@Select(class\object1) IN @Prompt(‘Select …enter ALL for all object1’,‘A’,‘class\object’,MULTI,FREE) )
OR
(‘ALL’ in @Prompt(‘Select… or enter ALL for all groups’,‘A’,‘class\object’,MULTI,FREE))

I tried with the code which is given in FAQ, but little bit confused how to do it.
Can someone help me with this.
Thank You.

cris (BOB member since 2006-10-17)

Error during SQL Execution:(DA0003)
Prompt 'ALL'
#2

I am working on BO 5.1.8 FC

cris (BOB member since 2006-10-17)

#3

Search for Cascading prompts, this is what you need probably.

–Luckys.

Luckys :united_arab_emirates: (BOB member since 2006-08-02)

#4

Hi Luckys,
Thank you for the reply.Actually I am looking for only one prompt where I want to add ‘ALL’ to the values and when I pick all I want to display all the values.

cris (BOB member since 2006-10-17)

#5

In that case this is what you require:

https://bobj-board.org/t/15227/9

Luckys.

Luckys :united_arab_emirates: (BOB member since 2006-08-02)

#6

I generate report using above post.

I run the report. Select “ALL” in prompt.

No data displayed in the report. I missed any thing?

//Ravi

ravi523 (BOB member since 2006-04-07)

#7

Hi Ravi,
Can you please please…post the steps/code you followed to do this because I am still facing some problem with this. :hb:
Thank You.

cris (BOB member since 2006-10-17)

#8

Hey Ravi one more question did you select ‘ALL’ or entered in the prompt?If you selected ‘ALL’ from values, can you please send the steps you followed to get ‘ALL’ in the values.
Thank You.

cris (BOB member since 2006-10-17)

#9

Hi All,
My problem is solved.I found where I was going wrong.
We need to put the text message( ‘Enter…’ ) exactly the same in both the prompts :smiley:
Thank You.

cris (BOB member since 2006-10-17)

#10

hi all,

my values in the report is

“request” is field name. values in database is (yes,no).

i want to create “all” for selecting both( yes and no).

i successfully create all using above post.( UNION SELECT ‘ALL’ FROM DUAL)

but, i generate report. i enter prompt value as “all”.

report shows no data. pls help me :hb:

ravi523 (BOB member since 2006-04-07)

#11

did you type all as answer to the promp and put ALL in the query ? Then it could by case sensitivity.

Regards,

Gerard

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

#12

hi gerard,

my report prompt values is yes,no and all.

i selected from values only(not typing).

i select prompt values yes/no . i got result of the report. :frowning:

Thanks,
Ravi

ravi523 (BOB member since 2006-04-07)

#13

I assume that you’ve handled the ‘ALL’ or yes/no part in the predefined condition for filtering the records, some thing like,

(Table1.Col IN @Prompt('Select Value', 'A', 'Class\Object', Mono, Constrained)) 
OR 
('ALL' IN @Prompt('Select Value', 'A', 'Class\Object', Mono, Constrained))

–Luckys

Luckys :united_arab_emirates: (BOB member since 2006-08-02)

#14

if your list shows ‘all’ and the query is something like ‘(‘ALL’ IN @Prompt(‘Select Value’, ‘A’, ‘Class\Object’, Mono, Constrained))’ then there’s still a possible case sensitivity problem (depending on database parameters).
Try changing the LOV so show ALL and not all. See if that helps.
If that doesn’t help, there’s some syntax errorin your where clause. See the example of Luckys

Otherwise post your code.

Regards,

Gerard

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

#15

Hi Gerard/Luckys

i got the result using above solution

Thanks for your suport

Ravi :lol:

ravi523 (BOB member since 2006-04-07)