Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: SGD on 20 Jun 2011 10:24:46 PM

Title: Resolved: Exporting report to Excel issue...
Post by: SGD on 20 Jun 2011 10:24:46 PM
Hi,

I am trying to open or export report studio report in Excel 2002, Excel 2000 single sheet, CSV formats but it shows screen for 4-5 seconds and vanishes.

I can successfully run the report in HTML format then open/export in PDF & XML format.

I am using Cognos 8.4.1 & MS office 2003 Professional Edition installed on MS 2003 Server 64 bit OS.

Any suggestions/idea?
Title: Re: Exporting report to Excel issue...
Post by: SGD on 21 Jun 2011 01:49:21 AM

As mentioned here http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos-l/can-not-run-reports-in-excel-format-in-cognos-83-2885201 I am able to open/export & save the report in excel format if I press 'ctrl' key continueasly.

But still not able to see report in excel format without holding 'ctrl' key.

i have checked that my IE's popup-block is disabled. Any clues?
Title: Re: Exporting report to Excel issue...
Post by: cognostechie on 21 Jun 2011 01:12:32 PM
I had the same problem. Turned out that I had the Google toolbar installed and Google was blocking the new window as a pop-up. Check your browser toolbars and see if it has Google/Yahoo or something else like that.
Title: Re: Exporting report to Excel issue...
Post by: SGD on 21 Jun 2011 08:18:51 PM
Hi cognostechie,

I have checked the IE's toolbar but nothing has installed. Not sure where is it new window getting blocked?  :-\

Moreover, report opens perfectly fine in new window when I export it to PDF format.
Title: Re: Exporting report to Excel issue...
Post by: Prerna Chaudhary on 22 Jun 2011 07:32:42 AM
Hi,

You can follow the following steps sequentially to resolve the issue:
1.   Setting Option: Advanced Tab

1.   In Internet Explorer: Go to -> Tools menu-> Internet Options-> Advanced tab
2.   Go to the Security section all the way at the bottom.
3.   Clear the check on the "Do not save encrypted pages to disk"
4.   Click on "Apply" and "Ok" to apply the settings

2.   Setting Option: Automatic prompting for file download

1.   In internet explorer: Go to—>Tools menu->  ->Internet Options->Security (Second TAB)
2.   Click Button "Custom Level "->Scroll to Downloads under "Settings" section
3.   Choose Downloads ->Automatic prompting for file download -> Choose the Enable option available there
4.   Click on "Ok" to apply the settings
5.   Close all Internet Explorer windows
6.   Start IE and download the file again

Please let me know if this was helpful or not.

Thanks and regards
prerna
--------------------------------------------------------------
pchaudhary@infocepts.com | www.infocepts.com
--------------------------------------------------------------
Title: Re: Exporting report to Excel issue...
Post by: SGD on 22 Jun 2011 08:49:20 PM

Thanks a lot Prerna...your suggestions worked  :)
Text only | Text with Images