2000859 - How to export a report to MS Excel with a .xlsb extension from Crystal Reports?

SAP Knowledge Base Article - Public

2000859 - How to export a report to MS Excel with a .xlsb extension from Crystal Reports?

Symptom

  • How to save a report to a .xlsb extension?
  • How to export a report from Crystal Reports to a MS Excel .xlsb extension?

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Cause

  • There is no option in Crystal Reports to export to MS Excel with a .xlsb extension.

Resolution

  • .xlsb format, is a binary format of a MS Excel spreadsheet. Therefore a workaround will be to export to MS Excel format from Crystal Reports, and manually enter extension as .xlsb:
       
    1. In Crystal Reports, open the report.
    2. Under the menu "File", select "Export - Export Report"
    3. In the "Export" window, under format, select: Microsoft Excel(97-2003)
    4. In the "Destination" drop-down list, select: "Disk file", and click "OK"
    5. In the "Select Export File" window, provide the file name along with .xlsb extension, and click "Save"

 

Keywords

.xlsb, crystal reports, export , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016