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)