Passing multiple parameter values to a drillthrough report

[Arvind]

Hello,

I have a master report that has a drill through to a child report.  I'd like to pass the parameter values from the first report to the next. The parameter can have multiple values selected. How do I pass the list of parameters to the second report? In the drill through definition, I have pass parameter value as the option and the in the target report, I have [Column Name] in ?parameter? in the filter condition.

Thank you in anticipation.

[jasmine0619]

Hi Arvind,

It's actually very easy ( in Cognos 10) Just make sure that the underlying drill through report has been programmed to take in multiple values  " IN" clause.

In the Target report, please select the values in the column that you want to pass multiple values by pressing the shift and selecting multiple rows

Right click and you will see "Drill Through Definitions"

Click on that and you will run the target report with multiple values selected.

Please let us know how it went

Regards
Jasmine

[Satheesh]

Hi,




Make Your Detail Report filter condition by using 'in' operator.


you can pass 'n' No.of values through parameter that parameter you can use at Ur child report as well.


as U mentioned [column_name] in ?param? that is right..


but while applying drill-through u make sure to pass the param value.




Sateesh

[Arvind]

Thanks Satheesh and Jasmine. I found the problem. It was an user error. Me in this case. thanks for your response.