COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Good Friend on 14 Apr 2016 11:35:10 AM

Title: Drillthrough to Multiple Reports
Post by: Good Friend on 14 Apr 2016 11:35:10 AM
Hi All,
I need advice to implement a drill through functionality from one report studio report to multiple report studio reports without having a selection for the target report at run time.
I have a source report with a column target type, which will show a separate target type in each record, and there is a separate detail report for each target type. I am trying to setup drill through functionality from the source report to the target reports. If the user clicks on the hyper link of one of the target type in the source report, the detail report for the selected target type should open and it should be the same functionality required for other target types also.

Let's say if I have one column in my source report which could contain the values, A, B or C?
And based on the value I want a different report to be executed on the drill
through? So if A is in row 1, the Drill Through goes to report A, if B is in row2, then the report goes to report B?

Thanks.