Drill Through in Cognos Excel Output

[PRIT AMRIT]

Hi Gurus,

Is it possible to create drill throughs from one Excel tab to the other using Report Studio.

Lets say we have 2 tabs in the excel report output - One summary and one detail. Using Report Studio, is it possible to provide a link on the Summary tab for a column (for eg. Product Line), so that when we click on 'Camping Equipment', it takes us to the detail info on the detail tab. Both Summary and Detail tab would have data for all the Product Lines....

Thanks
P

[cognostechie]

I did something like this in a PDF output . Define bookmarks in the Report in Report Studio. Once the report opens up in PDF, if you click on 'Camping Equipment', it will take you to the detailed section of Camping Equipment. I don't remember the steps to do it but check the Report Studio User Guide. That has the steps. Maybe it will work in Excel too, not sure though. You can also define a Table of Contents in 8.4

[PRIT AMRIT]

Thanks for your input though, but it Bookmark concept only works in PDF, but for excel it doesn't.

I wonder if any JAVA script can do the job?

[EArumugam]

Its working for excel 2007 thru bookmark. i tried its sucessful.

[PRIT AMRIT]

Good to know this though, but i have excel 2003  :(

[PRIT AMRIT]

Its working for excel 2007 thru bookmark. i tried its sucessful.

Easwar, can you let me have the steps or XML spec of your sample report?

Thanks in advance

Prit