
Export Report will look the way it displayed in Preview tab. This export retains both layout and formatting options. Crystal report can export to HTML in HTML 3.2 Version or in HTML 4.0 Version PDFĮxport to PortableDocFormat (PDF) is a page based export type. These formats preserve the layout in HTML Format. Useful for mailing nice looking reports to customers. The difference is that this format supports 16384Ĭolumns while ExcelRecord option can handle only 256 columns. ExcelWorkbook (Microsoft Excel 2007 (XLSX) Data-Only Only the report data is exported without the formatting information. ExcelRecord (Microsoft Excel (97-2003) Data-Only) This is a page based export option and retains the formatting, but lines and boxes are omitted from the report. XLS format corresponds to Microsoft Excel (97-2003) (*.xls) Version. There are three export options are available. The formulas that are supported are SUM, AVERAGE, COUNT, MIN and MAX. This option also exports report formulas. If there are more columns in the report than excel can handle, then the additional report columns are omitted from the export.XLS Format can only support 256 columns while the XLSX formats can handle 16384 columns. If the worksheet becomes full, then the crystal report creates another worksheet and continues. Worksheet name is the same as the report name. The report is exported in page by page basis and added to the single worksheet. Each column in report corresponds to a column in Excel.

This produces the report in Excel format. Both these files can be opened in word processing programs like Microsoft Word. EditableRTF file that contains only text and no drawing objects while RichText Option produces the file that contains text and drawing objects. This is the same as using the Save As feature with the Save Data with Report option selected. rpt file, which you open in Visual Studio just like any other report. This is a very popular way of exporting raw reports to Microsoft Excel users. This export file can be opened in Excel or Notepad. If TAB is used, then it is called TabSeparatedText (TTX). If the delimiter used is the comma, then it is called comma separated values or CSV. Each column is separated by a predefined character called delimiter in the export. Let us look into some of the very commonly used types of export formats Character Separated Values Record-based formats focus on accurate data representation rather than layout and formatting. They tend to produce the output that closely matches the layout and formatting of the original. These format tries to retain the look and feel of the page. Crystal Report Export Formats Export TypeĬrystal Report export formats can be broadly classified into two group
