Symptom
- The report has in excess of 6,000 rows
- Exporting to Excel format appears to be successful
- Opening the exported file in Excel results in the error;
Excel found unreadable content in name_of_file.xls. Do you want to recover the contents of this workbook?
- Allowing "recover the contents of this workbook", results in all formatting being removed from the xls file
- Report with less rows exports correctly
Cause
- The report had a New Page After option on the detail section enabled
- This resulted in an xls file that had too many pages for Excel
- For limits of Excel files, see the Microsoft Office Online documentation; Excel specifications and limits
Resolution
- Filter the report data for smaller result set
- Remove the New Page After option
- Export to a different format
- Note. The number of rows is not the defining variable, number of pages generated is
Keywords
Forum thread , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , How To
Product
Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 10.0 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 9.0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2