SAP Knowledge Base Article - Public

1200216 - What are the differences between the 'Excel' and 'Excel (Data Only)' export options?

Symptom

When exporting from the Crystal Reports designer or a Crystal Report document from Business Objects Enterprise, what are the differences between the Excel and Excel (Data Only) export options?

Resolution

Microsoft Excel format is a page-based format. This format converts your report contents into Excel cells on a page-by-page basis. Contents from multiple pages are exported to the same Excel worksheet. If a worksheet becomes full and there is more data to export, the export program creates multiple worksheets to accommodate the data. If a report object covers more than one cell, the export program merges cells to represent a report object. Microsoft Excel has a limit of 256 columns in a worksheet; therefore, any report object (or part of it) that is added to cells beyond 256 columns is not exported. This export format retains most of the formatting, but it does not export line and box objects from your report.

Microsoft Excel - Data only, as the name suggests, is a record-based format that concentrates on data. Even so, this format does export most of the formatting, too. Unlike Microsoft Excel format, Microsoft Excel - Data only format does not merge cells, each object is added to only one cell. This format can also export certain kinds of summaries in Crystal Reports as Excel functions. The summaries that are supported are SUM, AVERAGE, COUNT, MIN and MAX.

Keywords

Crystal Designer export Excel details , 4382901 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2