COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: gosoccer on 18 Feb 2016 02:44:27 PM

Title: Report Studio - Drill-thru from Source to Targe issue (10.2.1)
Post by: gosoccer on 18 Feb 2016 02:44:27 PM
Hi, it's me again. Sorry for taking so much of your time. :) :)

I have a Summary Report  (Source) and a Detail Report (Target)

The Summary Report shows/Displays in the Crosstab only the Description of State like (CD=CA, DESCRIPTION=California) BUT the
Detailed Drill-Thru Report only has the State CD as a part of the filter and NOT the Description.

So, since the State CD is not displayed as a part of the Summary Report Crosstab Top Edge, I don't know how to create a Drill-Thru
definition that would Pass the State CD as the Value to be send to the Target Drill-Thru that is using the State CD as a part of the Filter.

The Target Report is a List and not a Crosstab. The source is a Crosstab.

Please help if you can.

Thank you in advance for your time. 8) 8)

Title: Re: Report Studio - Drill-thru from Source to Targe issue (10.2.1)
Post by: BigChris on 19 Feb 2016 02:00:37 AM
Does the target report have access to the state description? Could you bring it into the filter but just not show it in your report?

Alternatively (I haven't tried this, so I don't know if it would work), could you bring your state code into your cross tab, but create a render variable so that it doesn't show/print?
Title: Re: Report Studio - Drill-thru from Source to Targe issue (10.2.1)
Post by: gosoccer on 19 Feb 2016 06:21:39 AM
Thanks a lot. I'll try both approaches. Good ideas. Thx :) :)