SAP Knowledge Base Article - Public

1425793 - When a Crystal Report with many columns is exported to Excel the pages are divided into multiple pages.

Symptom

When a Crystal Report with many columns is exported to Excel, the pages are divided into multiple pages while export to PDF works well.

Environment

  • Crystal Reports 2008
  • Crystal Reports XI Release2

Reproducing the Issue

  • Create a Crystal Report with many columns of data (15-20 columns)
  • Export it to Microsoft Excel (97-2003)
  • In exported Excel sheet click View>>Page Break Preview to see the page structure that is created in Excel.

Observation: a single page in Crystal Reports is divided into multiple pages.

Cause

  • When a report is exported to MS Excel it keeps showing data with 100% zooming and no scaling (reducing the zoom level) is done.
  • When clicking on ‘Page break view’, the pages are formed with 100% of the report size which is not the case with PDF.
  • If in Excel the report is scaled down to say 75% (similar to as we seen in PDF) it fits all the report in only one page.
  • This scaling down (zooming down) is a property of the Excel or PDF which cannot be controlled from Crystal Reports.

Resolution

  1. Under Page Setup in Crystal Reports set page orientation as ‘Landscape'.
  2. While exporting the report to MS Excel check option for "Create Page Break For Each Page"

This option can be selected to maintain the page breaks from the report that can be seen in MS Excel's Page Break View. But this option does not guarantee about the Page Breaks created by Excel. It helps to a certain extent only. This information about this in Crystal Reports Help file.

If the above steps do not give the expected output then the page borders in exported Excel sheet need to be set manually.

In Excel, in Page Break View, page breaks can be inserted or move the existing once as per the requirement. Also under Page Setup the scaling options can be used as per the requirement.

See Also

For detail information on Page Break in Excel please check below link

http://office.microsoft.com/en-us/excel/HP100215391033.aspx

Keywords

scaling, print, exel , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports XI R2