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

Unable to download excell output

Started by babu babu, 10 Sep 2009 06:50:04 AM

Previous topic - Next topic

babu babu

HI ALL,
i am running the report having the records more than 75000 records.When we are run in html i am getting output but when i run the same report in excell its giving error.Is it bug in cognos 8 please let me know

Thanks,
Babu

flyboy

Typically, Excel can't accept more than 65536 records.  You might have better luck using the .csv output option.

Keep us posted on what works!

m23

Quote from: babu babu on 10 Sep 2009 06:50:04 AM
HI ALL,
i am running the report having the records more than 75000 records.When we are run in html i am getting output but when i run the same report in excell its giving error.Is it bug in cognos 8 please let me know

Thanks,
Babu

from http://support.microsoft.com/kb/120596

"In Microsoft Excel 97 for Windows, Microsoft Excel 2000, Microsoft Excel 2002, and Microsoft Office Excel 2003, text files that contain more than 65,536 rows cannot be opened in their entirety. You cannot open these files because these versions of Microsoft Excel are limited to 65,536 rows. If you open a file that contains more data than this, the text file is truncated at the row 65,536, and you receive the following error message. File not loaded completely.

Versions of Excel later than Excel 2003 have a limit of 1,048,576 rows."

billylodz

you can use option rows on page
then will be splited for few sheets

works for 8.3