COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: admin_cog on 13 Aug 2009 09:24:45 AM

Title: Drill Down Report from months to weeks
Post by: 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?
Title: Re: Drill Down Report from months to weeks
Post by: cschnu on 14 Aug 2009 01:41:18 PM
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.