COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: saumil287 on 14 Jun 2011 02:35:46 AM

Title: Pass dates from date prompt to another report -drill through
Post by: saumil287 on 14 Jun 2011 02:35:46 AM
Hi All,
I am having 2 reports
src and target.

src report contains 2 date prompts and chart
on click on chart bars will take u through tar report.

I want to know howdo I pass the start date and end date from src rep to tar report.
Any help is appreciated
Thanks in advance
Title: Re: Pass dates from date prompt to another report -drill through
Post by: Vish on 14 Jun 2011 05:57:20 AM
Hi,
You can create the same start and end prompt filter in target report and you can pass prompt value by sending parameter value in drill through definition.
Title: Re: Pass dates from date prompt to another report -drill through
Post by: saumil287 on 16 Jun 2011 04:28:04 AM
Hi,
I tried the same thing but it is still asking for date.
What I did is->I created 2 filter in target report as([docdote])>=?d1?  and [docdate]<=?d2?
properties -required
But still prompting for date,
Can u guide me in more detail how to achieve it.
Thanks in advance
Title: Re: Pass dates from date prompt to another report -drill through
Post by: Deep on 19 Jun 2011 09:42:53 PM
Hi,

In the source report please define Drill throug Definition and selected parameters to be passed.

Thanks