COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: Nura on 04 May 2006 02:16:24 AM

Title: Passing Parameter from Crosstab(Main) to List(Child) report
Post by: Nura on 04 May 2006 02:16:24 AM
Hi

I have a crosstab report. It has "Data from" and "Date to" prompts and it has multiple filters. Its a main report. I have another one list report. Its a child report. The child report has the filter
"production date between ?Data from? and ?Date to?". I need to pass these two parameter from main crosstab report to child list report through drill through.

Can any one help me.

Regards
Nura
Title: Re: Passing Parameter from Crosstab(Main) to List(Child) report
Post by: bdybldr on 18 May 2006 08:03:50 AM
Nura,
Make sure that the "Date From" and "Date To" are query items in your crosstab.  Then, when you define drill-throughs in your crosstab report, align the parent.date_from with the ?child.date_from? parameter.  The same goes for date_to.  The important thing is that the parameters you want to pass must be in the underlying query of the parent report (but they don't have to be displayed in the report).

HTH.  Keep us posted.