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
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!
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."
you can use option rows on page
then will be splited for few sheets
works for 8.3