COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jagdish on 11 Dec 2008 07:53:18 AM

Title: passing prompt from main report to target report
Post by: jagdish on 11 Dec 2008 07:53:18 AM
Hi,
Requirment is like there is drill report and i have to pass the dates from main report to target report ie same filter should be applied for main and target report.

Thanks,
Jagdish,
Title: Re: passing prompt from main report to target report
Post by: jagdish on 11 Dec 2008 07:57:34 AM
i forget to mention that the date is parameter in main report.

Eg Suppose user selects From date and Through Date it should apply for both the reports; main as well as target report.

Thanks...
Title: Re: passing prompt from main report to target report
Post by: Gopinath on 12 Dec 2008 12:42:34 AM
Create a filter in your target report like
[date field] between ?From_Date? AND ?To_Date?

In the main report drill-through definitions set Method as Pass Parameter values and select the appropriate from and to date parameters to be passed to the target report
Title: Re: passing prompt from main report to target report
Post by: jahnavi_cse on 15 Dec 2008 10:29:55 PM
As of my knowledge the filter which we are passing in the main report should be there in the target as well