BusinessObjects Board

prompts

HI,
I have one problem

i have 3 objects one proj_bu,proj_name,resource_id

i will create prompts for proj_bu,proj_name,resource_id

if i create prompts it will show pick the values
so if i pick one value
for eg:proj_bu= cls
and second prompt for project_name like this thrird promt also

frist prompt if i pick one values like cls based on cls i want to show project_name and resource_id
how to create one prompt based another prompt
it possible to create in report level its like nested prompts

for eg:
[b]pro_bu , proj_name, resporce_id
cls bo 111
bo1 1112
bo3 1113

abc etl1 2 22
etl2 3333[/b]

what i want i will created prompts for proj_bu,proj_name,respource_id

frist prompts proj_bu it will show values like cls and abc
if i chose cls based on cls i want show the proj_name(bo,bo1,bo3) and resorce_id(111,1112,1113)
plz tell me what the solution…
can u please tell me the solution…

cheers
nsai


nsai (BOB member since 2007-03-27)

I guess you are talking about cascading prompts
Look into Designer FAQ for Cascading prompts

.


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