Export to excel issue

[Former Member]

I have one issue when exporting to Excel. When using the 'data only' option it is ok the columns get smaller and user complains.

Using regular option ( the first one). IT Created an excel with lots of blank cells intermittent. (that is why we use the 'data only') but is there a way to format

the CR in such a way that will not produce this issue?

[former_member203168 · Accepted solution]

Hi Paul,

Check your database fields format whether there is any gap/Space between two fields. If exists then remove/adjust the space, because if we have space in the design then that space is also consider as a Cell in Excel.
Maintain the height is same for all database fields.

Check below URL for your reference.

http://scn.sap.com/community/crystal-reports/blog/2013/03/27/tips-to-export-crystal-report-rpt-to-ex...
http://scn.sap.com/thread/3329390
http://scn.sap.com/docs/DOC-6687

Check the below information about Excel and Excel Data-Only formats

Microsoft Excel (97-2003):
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 (97-2003) Data-only:
Microsoft Excel (97-2003) Data-only is a record-based format that concentrates on data. However, this format does export most of the formatting as well. Unlike the Microsoft Excel format, this format does not merge cells; each object is added to only one cell. The data-only 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.
To get the best output from Excel export formats, you should design your reports in an Excel-friendly way. For more information, refer to the Technical Brief called "Exporting to Microsoft Excel" found on the SAP Business Objects Support site.