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 from a chart to a list

Started by rams143, 09 Nov 2010 10:13:31 AM

Previous topic - Next topic

rams143

Hi All,

I have a report with combination chart.
Where,
Y-axis is fixed to Project count
X-axis is a data item created in the underlying query and the value is selected from value prompt (varies)
Legend is also a data item created in the underlying query and the value is selected from value prompt (varies)

Now I am trying to implement drill through from this chart to a list report but I am unable to get the filtered results. I am passing the dataitem value to drill through. I am getting the target report without filtering.

Any thoughts......

Thanks in advance.

Rams.

MFGF

How is the relevant filter defined on your target (list) report?  If you run the list manually (ie not by drilling through to it), does it prompt you for the expected value you are passing?

MF.
Meep!

rams143

#2
Yes it does prompt me but the prompts and the filters behind are set to optional.

MFGF

If you temporarily set the filter(s) to 'Required' on the target report, does the drillthrough work as expected, or are the values still not getting passed?

MF.
Meep!

rams143

No. The values are not getting passed if I change the filter to required. I guess the target report is good. The issue is with the source because it doesn't know what to pass when the Y-axis & Legend are not fixed as they are selected from value prompt. If I set them to fixed dataitems then the drill through works fine.