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

Linking to different areas in the same report

Started by rannandale, 24 May 2010 08:15:11 AM

Previous topic - Next topic

rannandale

Hi guys,

I have a requirement to compile a report that fetches data - based on a key / lookup - from various data sources.

The "Top" list will basically be the information I get from the authoritative source for these key/lookup pairs. I want to be able to click a value in this list, which essentially "scrolls down" further into the report, to show me the detail for that specific value.

So it's sorta like a mix between a table of contents and a drill through report.

The easy answer is obviously to just use drill throughs, which I can understand. However, the trick here, is that there's usually between 10 and 100 items of "interest" that someone might want to click on, and I'd like to send the report out as a PDF for "offline" viewing, instead of having to run drill through reports.

I invision it working like a summary report, and a couple of appendices that you reach by clicking on items in the summary report.

If anyone has done something similar, please tell me how you went about it. I'm pulling my hair out trying to get this sorted out.

Thanks,
Riaan

tupac_rd

I think there is a TOC - table of contents object 8.3 onwards, will that work

rlp

I like to add bookmarks (report expression based) in the details with drill-throughs in the summary section.  For easier navigation, I usually sprinkle a few 'Return to Summary' type reverse drill-throughs also.

This also works great in both PDF and Excel 2007 formats.  I have found the Excel can be a bit picky about characters allowed in the bookmarks though.  PDF and HTML formats seem to be more forgiving.

P.S.  This only works well if you run and save the report.