SAP Knowledge Base Article - Public

1526412 - How to export Crystal report to Excel 2007 file format from CrystalViewer in a .NET application?

Symptom

How to export a Crystal report to the Microsoft Excel 2007 .xlsx format using the Crystal Report Viewer control in .NET application.

Environment

  • Crystal Reports for Visual Studio 2010.
  • Visual Studio 2010.

Resolution

  • Export option in .xlsx is included in CrystalReports for Visual Studio 2010.
  • Steps to export report to the .xlsx format are:
    1. Click on Export button on the Crystasl Report Viewer toolbar.
    2. Select the desired location.
      3.JPG
    3. Click 'Save' to save.

See Also

NOTE:

  • Exporting report to Microsoft Excel 2007 in .xlsx format is not available in Crystal Reports XI R2 and Crystal Reports 2008. See SAP Knowledge Base article 1420458 - "Is it possible to export to Microsoft Excel 2007(.xlsx format) from Crystal Reports 2008?" for details.
  • Video for export in xlsx is available here:
    XLSX Export Viewlet.

Keywords

xlsx, ms excel, vs, cr4vs2010, dot net, net, app, viewer tool, viewer control, docx , KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , How To

Product

SAP Crystal Reports, developer version for Microsoft Visual Studio