Cognos Active Reports - Cascading prompts with a single Object

[CogDeveloper]

Hello All,

I have a requirement in Active reports to cascade Region, County, Office prompts and display a chart based on user selection. When the report first opens it should show 'Statewide' Chart. When a selection is made in the Region prompt. It should display Region Chart and filter values(Cascade) in the county prompt. Similarly if a county prompt is selected, it should display County Chart and filter values(Cascade) in the office prompt.

I was able to accomplish cascading prompts with 3 Data Drop-Down lists. I created 3 Chart objects RegionChart(No data tab shows Statewide Chart), CountyChart and OfficeChart. However, the requirement is to show a single chart, not 3 charts. A single chart should show Statewide Chart by default and display Region chart when Region is selected, County Chart when Region and County is selected. Office Chart when Region, County and Office are selected. It would be okay if I hide the other 2 Charts. At any point of time only one chart should be shown.

I have attached the report specification. Can someone please help!

[nancysinghal]

Hi,

I have 3 variables: pRegion, pCounty and pOffice, and three coressponding cascading data dropdowns. again 3 charts , one displaying data by region, second by county and third by office.
Requirement: If user does not select any dropdown option, statewide data should be displayed.
When any region is selected, chart should be displayed with that particular region data only.
If then any county is selected(in second dropdown), chart should display data specific to that region and county combination.
If then any office is selected(in third dropdown), chart should display data specific to that region, county and office combination.

I want to conditionally show and hide charts according to user selection of dropdown prompts.

Can anyone please suggest.

Regards,
Nancy

[nancysinghal]

I have a similar requirement. But my chart is getting filtered for one region, instead of giving Statewide view.
Can you please suggest what I am missing here.

Regards,
Nancy

[MFGF]

I have a similar requirement. But my chart is getting filtered for one region, instead of giving Statewide view.
Can you please suggest what I am missing here.

Regards,
Nancy

I suspect you need to add a default card to your data deck, and create another version of the chart on the default card (with no connection to the region/county/office varaibles). The default card will display when no variable values are selected. As soon as you select a region, the corresponding region card of the data deck will be displayed.

Cheers!

MF.

[nancysinghal]

Thanks MFGF. It worked :)

Regards,
Nancy