Need help on Report Design

[kadhir]

Hi All,

I need your suggestion on the report that I develop. The requirement is like this: I have to create multiple drop-down lists on top of the report. All drop-down lists are logically related. First drop-down list might contain continents and Second list might contain regions and third might contain countries,and so on. Based on the selection on regions, for example, the countries are displayed. In other words, the list items in third drop-down, is dependent on the value selected in previous list, that is in second list.

At the bottom portion of the report, based on the values selected in the multiple drop-downs, the report is displayed.

How would I achieve it ?

I am totally new to Cognos environment, please do help me.

Thanks in advance.

[Gopinath]

You can achieve this by using the Cascading Source property when creating prompts

[imts]

Hi,

On Prompt Page, place different Value Prompts ... Use Cascading Prompts.
Eg. For REGION-> cascading source will be COUNTRY.
      For CITY -> cascading source will be Region.

ENABLE AutoSubmit property for these prompts as the data will be reloaded when prompt value is changed.

Create the Report Page.

Regards,
Tarun