COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: stancho on 13 Jan 2011 06:35:07 AM

Title: Drill-through and pass empty params
Post by: stancho on 13 Jan 2011 06:35:07 AM
Hi,

I have two reports with the same parameter - paramName. It is optional.
I do not have prompt page. I have auto-submit prompt list box for paramName in the Report Pages.

There is a drill-through definition from Report 1 to Report 2 which passes the paramName value.
The following scenario:
1. Report 1 is loaded.
2. paramName value is not selected ot Report 1(it is optional).
3. Drill to Report 2.
4. No data is shown in the tables in Report 2 which are filtered by paramName.
This is caused because no paramName value is selected in Report1 (so empry paramName value is passed).
Report 2 needs to be reloaled by changing the value in paramName listbox (Report 2 will be auto-submited).
This case the data is shown .. but after reloding Report 2 again.

If I choose paramName value in Report 1 and then drill to Report 2 the data in Report 2 is shown.

Any ideas?

BR,
Stancho

Title: Re: Drill-through and pass empty params
Post by: jive on 13 Jan 2011 08:25:02 AM
Hi,

In report 2 i hope your filter is optional... if it's not It will wait for a value, if none are passed they will ask for. Just check that the answer maybe there.

Regards
Title: Re: Drill-through and pass empty params
Post by: stancho on 13 Jan 2011 08:57:57 AM
jive,
it's optional. it's not asking for value in Report2.