How can I fix excel problem in cognos? (FIXED)

[ersin.gulbahar]

I make a report as pdf.It s fine. But when I export it to excel ,there are many sheets on excel . I do not wan to it.I want to 1 sheet.How can I fix this?

Thanks.

[Greg]

Cognos creates one Excel sheet per report page, so if you're report has multiple explicit report pages defined then you can't combine them in one Excel sheet.  If, on the other hand, you just have one explicit report page but the data in your list/crosstab is breaking across multiple pages you can change the rows per page property so that it all fits on one page.

[MMcBride]

How many records are you returning?

In 10.1.1 using Excel 2007 format you are still limited to 65k rows per Excal Tab - even though Excel 2007 supports 1 Million.

I have not tested Cognos 10.2 to see if this is fixed yet.

I am not aware of anyway to force more than 65k Records on a single tab when running a cognos report in excel format. To be honest when a user comes to me with this issue I remind them Cognos is not an ETL tool and there are other (and easier) ways of getting large csv files out of our databases.

[Lynn]

The 65K rows in excel 2007 from Cognos is intended to support users that have older versions of excel but work with 2007 files via the compatability pack (or something like that).

In a pinch I'd say use CSV output and then save as Excel 2007.....but......Amen to the comment that Cognos is not an ETL tool !!

[ersin.gulbahar]

Thanks everybody, I changed the rows per page number and it is fixed now. Thanks again.