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

65000 rows in Excel

Started by alf, 10 Dec 2012 04:56:20 AM

Previous topic - Next topic

alf

Hello,
i have produced a report in Excel2007 but when reaching 65,000 stops and keeps in a new sheet....Is there a paramether to control this because what i would like is to have all in one sheet in excel 2007.
Thanks,

alf

Forget friends, i have just read that in Cognos 8 works like that and only in Cognos 10 you can change a paramether.
Solution could be to obtain in CSV and then open in excel.

Alfredo

alf

Unfortunatly i have tried in CSV but no luck...is no able to produce the report.....Any idea ? or i have to live with 65000 rows in each page...

markallen.cincinnati

It is a limitation in Excel 2007

norkos

It's not an Excel 2007 limitation, it's a limitation in Cognos 8 to maintain backward compatibility.
So you can generate Excels over 65000 rows only in Cognos 10 which support native XLSX format.

The workaround to export the result into CSV can't work if your report contains crosstab or chart because CSV is a text file which can't store graphical information.

Sorry but that's the case

alf

Thanks a lot norkos !!
so it is possible to use CSV to extract huge information from a List Report...isn't it?

Regards,
Alf