cascading prompt

[EArumugam]

Hi all,

I have 4 prompts in my report.

Region- Country-State-District.

By default it shud display all the values in all prompts.

scenerio 1: if i select any region, For ex if i select APAC it shud automatically display APAC ountries in country prompt.

scenerio 2: without selection any region, if i select country (india) it shud display correspoding states.

is it possible to achive this in cognos. if yes please explain.

thanks.
eas

[holsy1982]

Hi,

I think you want to set up the four prompts. 
Looking at the Country Prompt Properties, select the Region Parameter in the Cascade Source Option, and also select Pre-Populate option as Yes
Looking at the Region Prompt select Auto-submit as yes.    This will then show the full options for region until Country, but will only show the countries within the a selected Region.
I think you'll then be able to Cascade down into the State and district accordingly.

I hope this helps