COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Sheldon on 15 May 2012 02:55:49 PM

Title: Multiple Drill-Throughs In the Same Report
Post by: Sheldon on 15 May 2012 02:55:49 PM
If I have a report that lists in one column the number of, 3rd, 4th and 5th graders.  And let's say those totals are 10, 12 and 14 respectively.  And, at the bottom of that same column would be the total number of students (36).  I would like to click on the 10, 12 or 14 and see each group of kids which is easy to do.  But what if I want to also be able to click on the 36 at the bottom and see student information on all 36 kids, is that doable?  i.e. Another drill-through in the same report.

Thanks, Sheldon
Title: Re: Multiple Drill-Throughs In the Same Report
Post by: pricter on 16 May 2012 02:27:12 AM
Hi Sheldon,

I am not having any relationship with Senturus but have you check the following video if it fits your requirements?

http://www.youtube.com/watch?v=Knul2EGA0TM (http://www.youtube.com/watch?v=Knul2EGA0TM)
Title: Re: Multiple Drill-Throughs In the Same Report
Post by: Sheldon on 16 May 2012 07:35:49 AM
Thank you.  I did watch the video.  It was informative but did not answer the question I had.

Sheldon
Title: Re: Multiple Drill-Throughs In the Same Report
Post by: Sheldon on 07 Jun 2012 10:02:50 AM
This is do-able.  I was pointing to the wrong drill-through and this lead to the error I was getting when I tried to get this to work.

Sheldon
Title: Re: Multiple Drill-Throughs In the Same Report
Post by: barrysaab on 13 Jun 2012 10:58:42 AM
Sheldon,Could you please elaborate a bit,how did you actually you get it.Thanks