Exporting a Report

The data displayed while viewing a report in the on-screen report viewer (see Viewing a Report) may be exported to a variety of industry-standard file formats. Click the  button from the toolbar within the report viewer to open the export window.

Select the desired file format and destination and then click the OK button to begin the export. Click the Cancel button or press the Esc key to close the export window without exporting.

See the tables below for a list of export formats and destinations supported by Crystal Reports. Some export formats or destinations may prompt you for additional options. Follow the directions on-screen.

Export Formats


File Extension

Acrobat format


Crystal Reports


HTML 3.2


HTML 4.0        


Microsoft Excel 97-2000


Microsoft Excel 97-2000 (data only)     


Microsoft Word          




(any supported ODBC extension)

Record style (columns no spaces)


Record style (columns with spaces)


Report definition


Rich text format


Separated values


Tab separated text






.xml, .dtd


TIP      When exporting to the Microsoft Excel 97-2000 format, selecting a smaller constant column width (e.g. 10 points) may improve the exported formatting.


NOTE   While Crystal Reports attempts to preserve as much report layout formatting as the selected export file format allows, some layout formatting may be lost if it is not fully supported by the selected file format. Further, when exporting reports with complex report layout formatting to simpler file types, some of the data fields may not be exported (e.g. only header fields might be exported). Since all exporting is controlled exclusively by Crystal Reports and not by the At Your Service program itself, then if the export results are not as expected or desired then the first option is to select a different export file format. A second option is to have a custom data export prepared (see Custom Data Exports).

Export Destinations




The reporting engine exports the report to a temporary file in the specified format and then opens the file in the appropriate application.

Disk File

The reporting engine exports the report in the specified format to a filename that you select.

Exchange Folder

The reporting engine exports the report in the specified format to a Microsoft Exchange folder that you select.



The reporting engine exports the report in the specified format and e-mails it as an attachment via an installed and configured MAPI mail client (e.g. Microsoft Outlook, Microsoft Mail, or Microsoft Exchange; see also Technical Overview of E-mailing via MAPI).


(See also Exporting Overview, and Exporting a Form.)


Repair Reports