COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: DJessey on 16 Nov 2010 08:11:21 AM

Title: Cognos Link to run an excel spreadsheet from a web page
Post by: DJessey on 16 Nov 2010 08:11:21 AM
I have a link to execute a Cognos report from a web page in excel format which works fine (I used the default action URL link found on the set properties page). I get the excel report window asking if I want to open or save, which is also fine, but I also get another browser window in the Cognos viewer that says "The webpage you are viewing is trying to close the tab. Do you want to close this tab?" Is there anyway I can suppress this window appearing? We want the user to only have the excel spreadsheet appear and the extra Windows Internet Explorer window is confusing for the user.
Title: Re: Cognos Link to run an excel spreadsheet from a web page
Post by: DolAny on 16 Nov 2010 09:04:29 AM
DJessey,
You could setup export by drill thru in the same report using output format as excel.
The  only issue here that will run report again and render to excel format without keeping the place where you were drilled up/down.

Keeping your approach.
About first window u'll be asked always (open/save) about second - didn't see this window before. What's the version Cognos/Office you use?
Title: Re: Cognos Link to run an excel spreadsheet from a web page
Post by: DJessey on 16 Nov 2010 09:57:53 AM
I have Cognos 8.3 and Excel 2007. I'm thinking this is a browser issue, not a Cognos one. The first window choosing to save or open Excel is fine, it's the browser asking that it's trying to close and do I want to that is the problem.
Title: Re: Cognos Link to run an excel spreadsheet from a web page
Post by: DolAny on 16 Nov 2010 10:11:21 AM
DJessey,
What's the browser version?

Have a look this one http://support.microsoft.com/kb/926693/en-us
Title: Re: Cognos Link to run an excel spreadsheet from a web page
Post by: DJessey on 16 Nov 2010 01:31:50 PM
This is IE 7. Thanks for the link. This may help.
Title: Re: Cognos Link to run an excel spreadsheet from a web page
Post by: zamcognos on 23 Mar 2016 10:10:46 AM
Hi was this issue resolved if so can I get the resolution please