If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Drill down from multiple columns to one report

Started by JamesK99, 15 Jul 2009 10:56:18 AM

Previous topic - Next topic

JamesK99

Hi Everyone,
I'm trying to set up a drill-down in Report Studio (Cog 8.3)
i have 4 levels, and each one of the 3 upper levels contain 5 columns. I want to drill-down using those columns, but without having to make up a separate bottom level (detail) for each column.
The columns are equal to either 1 or 0.

I have no problem setting this up with multiple reports, but I was guessing there is a way to do this down to one, passing variables.

Example:  Column B | Column C | Column D.
I want to click on one of those (they age categories) and have them drill to the correct data - only column b, or only column c, or only column d data shows. Again, the data in the columns is just a count, so it's equal to either 1 or 0 (Text format)

Thanks for any help,
James