If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Running Reports in Cognos 8.2 to Excel 2007

Started by jguevin, 05 Dec 2007 07:23:19 AM

Previous topic - Next topic

jguevin

I have tried running both AS reports as well as RS reports to Excel 2002, but have Excel 2007 on my machine.  Each time I try it to run them I get the Open/Save/Cancel window, press Open and then it attempts for about 15 minutes, and gives me an error.  I change the run options to Excel 2000 and then the report runs and opens in Excel fine.  Anyone else have these issues and or figure out how to resolve it?

Thanks
Jeff

rockytopmark

Execute the reports using the "Run with Options" action, and choose to save the reports, and select the Excel 2002 delivery format.  This will save a copy in the content store.

After the report succeeds, you can then click on the report versions icon, and select to open or download the report. 

Not exactly sure why, but there are differences in retrieving the output via the content store (fairly successful) versus running the report interactively and displaying in Excel 2002 (not as successful). I usually save to my local disk then open from there.

You can also see if emailing the file (.MHT) and then opening it from the email works better.