User`s guide

Page-based formats tend to produce a more exact output. The emphasis of these formats is layout
representation and formatting. Formatting refers to attributes such as font style, text color, text alignment,
background color, and so on. Layout refers to object position, object size, and the relationship between
these attributes and other objects. Depending on the format you choose, it may not be possible for the
program to preserve all layout and formatting perfectly, but page-based formats, in general, preserve
these properties as closely as possible.
With record-based formats, the emphasis is on data rather than the layout and formatting. However, in
some formats—such as Microsoft Excel - Data only—you will notice that some formatting is exported.
Some of the record-based formats are only data-exchange formats.
Crystal Reports (RPT)
Exporting to Crystal Reports format is much like using the Save As feature with the "Save Data with
Report" option selected. This format exports (saves) your report with the current data without modifying
the original report.
Crystal Reports Read-only (RPTR)
Crystal Reports Read-Only (RPTR) reports are Crystal reports that can be viewed with report viewer
applications, but cannot be opened by the Crystal Reports designer. This enables you to protect your
intellectual property by preventing users from modifying the report or obtaining information about
proprietary business logic that is stored in the report definition
HTML 3.2 and HTML 4.0
HTML export formats are page based. The HTML 4.0 format preserves the layout and formatting of the
report by using DHTML. The HTML 3.2 format, however, cannot maintain all of the layout precisely.
The HTML 3.2 format is intended for backward compatibility with older browsers that do not support
HTML 4.0. All of the images in your report are saved externally and a hyperlink is inserted in the exported
HTML output. Therefore, this export format generates more than one file in the output.
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.
2012-03-14381
Printing, Exporting, and Viewing Reports