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
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