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
I think there is a TOC - table of contents object 8.3 onwards, will that work
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.