COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: toaehsan on 22 Feb 2010 04:09:05 AM

Title: Parameter Passing (Source To Target)
Post by: toaehsan on 22 Feb 2010 04:09:05 AM
Hi All,

i have source and Target reports and i am using Drill through Definition to pass parameter from Source report to target report.

Source Report - 4 Parameter
1> Year
2> Period
3> Account
4> Source

Target Report - 4 parameter
1> Year
2> Period
3> Account
4> Source

My requirement is to pass only 2 parameter (Year & Period) at all the time when i click to see target report.

currently, if i run source report with all 4 parameter then it also pass all 4 parameter to target report.
i have also select the option called "Do not use parameter" for which i do not want to pass values but still target report shows those parameter. pls help?
Title: Re: Parameter Passing (Source To Target)
Post by: rockytopmark on 22 Feb 2010 09:46:56 AM
Your Target report's filters need to be set to optional to allow the report to run without prompting generation for filters with NULL parameters (Those that you are choosing to not pass)
Title: Re: Parameter Passing (Source To Target)
Post by: toaehsan on 23 Feb 2010 06:16:43 AM
Hi, thanks for reply..

My target report is already having optional filter only.

Regards,
Ali
Title: Re: Parameter Passing (Source To Target)
Post by: paddhu on 25 Feb 2010 07:03:07 AM
Have you tried setting Default Parameter value for those parameters in the Drill through definition???