BusinessObjects Board

providing "ALL" at prompt level

building reports webintelligence
#1

Hi All,
i have a requirement as
customer, cname, city
1 john a
2 james b
3 jimmy c
4 marry a
5 paul b

we have to provide prompts for these three as

customer
ALL
1
2
3
4
5

if user selects “ALL” then cnmae prompt has john,james,jimmy,marry, paul including “ALL” and like wise city also.

suppose if user selects customer as
1
2
3
then cname has to dispaly corresponding names at the prompt as
john, james, jimmy including ALL option
from this user selects john and jimmy city prompt has the vales only corressponding values.
Then generate a report.

Can any one tell me how to reach this one.
i tried this by using cascading prompts to each other. filtering is happening but “ALL” option is not working.

Regards
sunil.

sunil_ogl :india: (BOB member since 2007-04-19)

#2

Have you read Designer FAQ for All in LOV and remember that just adding all to LOV is not enough, you need to create a predefined condition also by ORing

.

haider :es: (BOB member since 2005-07-18)

#3

Hi,
Thanks.
Actually iam new to this concept. Can you provide me some description how to reach this concept.

Appreciate if u provide this with example…

Thanks & Regards
sunil.

sunil_ogl :india: (BOB member since 2007-04-19)

#4

Read this post

.

haider :es: (BOB member since 2005-07-18)