SAP Knowledge Base Article - Public

1200157 - What are the export format available from Crystal Reports, and Crystal Reports for Enterprise?

Symptom

  • What are the format we can save reports to?
  • What are the format we can export reports to, from Crystal Reports?

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
            
  • SAP Crystal Reports for Enterprise 4.1
  • SAP Crystal Reports for Enterprise 4.2
  • SAP Crystal Reports for Enterprise 4.3

Resolution

  • You can export a report to the following format:
     
    • Crystal Reports:
        
      • Crystal Reports (RPT)
      • Crystal Reports Read-Only (RPTR)   
      • HTML 3.2
      • HTML 4.0
      • Microsoft Excel (97-2003) (XLS)
      • Microsoft Excel (XLSX)    ( New from Crystal Reports 2020 )
      • Microsoft Excel (97-2003) Data-only (XLS)
      • Microsoft Excel Workbook Data-only (XLSX)   
      • Microsoft Word (97-2003) (RTF)
      • Microsoft Word (97-2003) - Editable (RTF)
      • ODBC
      • PDF
      • Record Style - Columns with spaces
      • Record Style - Columns without spaces
      • Report Definition
      • Rich Text Format (RTF)
      • Separated Values (CSV)
      • Tab Separated Text (TTX)
      • Text
      • XML
      • XML (Legacy)
                 
                   
         
    • Crystal Reports for Enterprise:
          
      • Crystal Reports Read-Only (RPTR)   
      • Microsoft Excel (97-2003) (XLS)
      • Microsoft Excel (97-2003) Data-Only (XLS)
      • Microsoft Excel (XLSX)     ( New from Crystal Reports for Enterprise 4.3 )
      • Microsoft Excel Workbook Data-Only (XLSX)
      • Microsoft Word (97-2003)
      • Microsoft Word (97-2003) - Editable
      • PDF
      • Separated Values (CSV)
      • Rich Text Format (RTF)
      • Report Definition
      • XML
      • Plain Text
      • Tab Separated Text (TTX) (Page Based)
      • HTML 4.0                   
           
            

  • Note for SDK:
    The new MS Excel format (.xlsx ) is currently not available in .NET or Java ( Eclipse ) and BOE SDK's
    An Enhancement has been requested to add a new ENUM value to add this format in the future.

See Also

  • For a list of Crystal Reports functionalities supported by exporting format, see the following SAP Knowledge Base Article:
         
             1946358 - Crystal Reports features supported by exporting format

  • For details on XLSX support:

    https://blogs.sap.com/2021/12/08/sap-bi-4.3-sp2-whats-new-in-crystal-reports/

Keywords

Export format, xport, CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020