Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Drill to Details

Status
Not open for further replies.

Jamjune

Technical User
Aug 30, 2009
4
US
I am a newbie to using Cognos 8.2. Previously I did reports in Crystal or Excel. I have a list report that is grouped and totaled by Exec. Is there a way, like in Crystal, that you can have the report render with just the totals for each person showing but allow the user to drill to the detail rows if they want to? Another example of what I am trying to do would be like subtotals in Excel where you can select the level to show the totals for each Exec but user can select a different level to show all rows. The data I am using is not dimentional.

Any help is appreciated!

Thanks!
Jamjune Crystal 8.5
 
Cognos accomplishes this with a subreport. The main report then show just the totals and you can then build a second report to pass a parameter or dataitem value to this report that opens up with the details.

There is no 'fold' option as in other tools.



Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top