If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Drill Down Report from months to weeks

Started by admin_cog, 13 Aug 2009 09:24:45 AM

Previous topic - Next topic

admin_cog

Hi All ,

I have a cross tab report which having moths data(parent report) and weeks data(child report). And I have start date and end date from prompt parameters.  I have data in monthly buckets and weekly buckets.

If drill down particular month it should display to weekly data for corresponding month.i am able to display weekly data form drill down but I am unable to restrict for the particular month.

Can anyone help me?

cschnu

Quote from: admin_cog on 13 Aug 2009 09:24:45 AM
Hi All ,

I have a cross tab report which having moths data(parent report) and weeks data(child report). And I have start date and end date from prompt parameters.  I have data in monthly buckets and weekly buckets.

If drill down particular month it should display to weekly data for corresponding month.i am able to display weekly data form drill down but I am unable to restrict for the particular month.

Can anyone help me?

You will have to add a filter to the child report that restricts your query by a given month passed in through your drill down.