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.
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.
Yes it does prompt me but the prompts and the filters behind are set to optional.
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.
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.