Export file formats for SAP Crystal Reports for VS 2010, 2012, 2013
With the release of Crystal Reports for Visual Studio 2010 Production Release Now Available (CRVS2010), I wanted to update the Wiki Available Export Formats, Crystal Reports 9.1 to Crystal Reports 2008 with info for CRVS2010. Unfortunately, CRVS2010 being somewhat of a different beast (it’s not a bundle, it’s not a stand-alone version), I am thinking of decoupling from the Wiki and document exports in CRVS2010 in this bog.
- Exporting using the CRVS2010 viewers
In CRVS2010, we have three viewers; Windows, Web and WPF. Each of the viewers has 10 default export formats available from the viewer export button. A new feature of CRVS2010 is the ability to modify the available export formats from the viewer export button. The following C# sample code demonstrates how to set the CrystalReportViewer to export only to PDF and Excel file formats:
int exportFormatFlags = (int)(CrystalDecisions.Shared.ViewerExportFormats.PdfFormat | CrystalDecisions.Shared.ViewerExportFormats.ExcelFormat);
Similarly, other supported export formats (see below) can be added to the viewer export button. For more details see KBase 1498827 – How to set the list of available export types in the .NET CrystalReportViewer control. And of course as always, the export formats can be exported to using code only. For samples of export applications see Crystal Reports for .NET SDK Samples.
- New export format types in CRVS2010
There are two new export file formats available in CRVS2010; XLSX and RPTR. For a demonstration of export to XLSX, see the demo Overview of Export to XSLX with Crystal Reports for Visual Studio 2010.
RPTR reports are Crystal reports that can be viewed with report viewer applications, but cannot be modified with the SDK or opened by report designer applications. The definition of an RPTR report cannot be modified, so you cannot use this SDK to set the data source location of an RPTR through the database controller. However, you can refresh the data of an RPTR report at run time by refreshing the report in a viewer.
- List of all available export formats for CRVS2010
Crystal Reports (*.RPT)
Adobe Acrobat (*.PDF)
Character Separated Values (*.CSV)
Microsoft Excel (97-2003) (*.XLS)
Microsoft Excel (97-2003) Data-Only (*.XLS)
Microsoft Excel Workbook Data-Only (*.XLSX)
Microsoft Word (97-2003) (*.DOC)
Microsoft Word (97-2003) – Editable (*.RTF)
Rich Text Format (RTF) (*.RTF)
Tab Separated Text (*.TXT)
The export types highlighted in the above list are available in the Crystal Reports viewer. Export types in black are only available via calling the appropriate export API.
- More information
I also highly recommend looking at the youtube video by Brian Bischof, Crystal Reports .NET 2010 Quickstart Guide.