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 21 Jun 2011 08:27:49 PM

Title: Reduce size of exported excel report
Post by: SGD on 21 Jun 2011 08:27:49 PM
Hi,

How can we reduce the size of excel exported report? I have 29002 rows in the report which creates 84MB of excel file when I export the same using Excel 2002 option.

Please suggest.
Title: Re: Reduce size of exported excel report
Post by: SGD on 21 Jun 2011 09:52:21 PM

Observed that same report generated in Excel 2007 format has less size (4MB) than Excel 2002 format.

However, user use MS Office 2003 Professional edition hence need to export report in Excel 2002 option only.
Title: Re: Reduce size of exported excel report
Post by: Peewee71 on 22 Jun 2011 09:47:14 AM
When you export to excel cognos uses a verbose xml based format, hence why your file is so much bigger.

I believe this was mitigated in version 8.4  and beyond. Which version of cognos are using?

My solution that i needed to take was export as a csv.  You may lose format if you choose this option.
Title: Re: Reduce size of exported excel report
Post by: SGD on 22 Jun 2011 08:03:36 PM
Hi Peewee71,

I am using Cognos 8.4.1 version.

No idea why size of the file is big. report has 29002 rows and it might increase also however exported in Excel 2002 format it generates 84MB excel file and in Excel 2007 format it generates 4MB excel file.

Can not use .csv format because as you said I need to maintain the formatting of report as it is.
Text only | Text with Images