COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ra on 26 Feb 2014 05:03:19 AM

Title: how to apply drill through in MS-Excel
Post by: ra on 26 Feb 2014 05:03:19 AM
Hi Cognos gurus

I have an requirement like in  MS-Excel   apply the drill- Through functionality , but we can apply drill-Through functionality in HTML , PDF   but i don't no how to apply drill -Through functionality in Excel.

Can anyone tell me  how to achive this.

Thanks in advanced

Rams.....
Title: Re: how to apply drill through in MS-Excel
Post by: MFGF on 26 Feb 2014 05:44:04 AM
Hi,

By rendering as Excel you are taking the output outside of the control of your web server. This means drill-through definitions will not work. The alternative is to bring in a hyperlink and set the URL source as a report expression. Use an expression to point to the URL of the report you want to link to, and add any passed parameter names and values into the URL.

Cheers!

MF.
Title: Re: how to apply drill through in MS-Excel
Post by: ra on 03 Mar 2014 01:27:52 AM
Hi MF,

Thanks for u r quick reply for my post , but i don't know hoe to apply hyperlink, could you send step by step process to achive this in Excel..... please.........
and link to understand


Thanks
Rams........