cancel
Showing results for 
Search instead for 
Did you mean: 

Error when exporting more than 65K rows to Excel

Former Member
0 Kudos

Running Crystal XI, v11.0.0.1282 (not sure what SP level we're at, or how to tell)

We're attempting to use Crystal XI as a front end to allow analysts to dump possibly large volumes of data to Excel for analysis. This is working satisfactorily when the number of rows is within the limit for earlier Excel versions (pre-2007), but appears to be failing when the row count exceeds the ~65K mark.

When I dump such a large set from my Crystal developer session at my workstation, the behavior is that the data is exported to one sheet up to the row limit, with any overflow placed in an additional sheet. Presumably, once the second sheet filled up, the remainder would spill over to an additional sheet, and so on.

When the "report" is run from the server, however, the instance runs for several minutes and fails, returning the error "Not enough memory for operation." I've experimented with running the output to the Crystal format - which completes successfully - and exporting from that, with the same results. Likewise, running to PDF works as advertised, though exporting from there to Excel is not an option. When I alter my selection criteria to yield a row count < ~65K, it exports to Excel by either method.

In general, I expect that row counts from these runs would not exceed Excel 2007's single sheet row limit, so just getting Crystal to export multiple sheets containing all the data would be sufficient. Our users could then convert to Excel 2007 and consolidate the exported results to a single sheet and work their magic.

I've scoured the archives looking for similar problems and solutions, but haven't found anything helpful. Any nudge toward a solution would be a great help.

Thanks!

Don

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Here is another recent post regarding a simular issue.

[Crystal Reports 11.5 excel export limit? |]

Answers (1)

Answers (1)

0 Kudos

Hello,

If you upgrade to CR XI R2, for free, and use your XI keycode to install it and then apply SP 5 and SP 6 when you export CR will create a new Sheet for all rows over the 65 k limit.

Also, be aware that depending on the version of Excel you are using it is NOT a CR limitation but an Excel limitation.

https://smpdl.sap-ag.de/~sapidp/012002523100011802732008E/crxir2_sp4_full_build.exe

https://smpdl.sap-ag.de/~sapidp/012002523100013876392008E/crxir2win_sp5.exe

https://smpdl.sap-ag.de/~sapidp/012002523100015859952009E/crxir2win_sp6.exe

Thank you

Don