If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Drill-through and pass empty params

Started by stancho, 13 Jan 2011 06:35:07 AM

Previous topic - Next topic

stancho

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


jive

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

stancho

jive,
it's optional. it's not asking for value in Report2.