1420458 - Is it possible to export to Microsoft Excel 2007(.xlsx fromat) from Crystal Repots 2008?

SAP Knowledge Base Article - Public

1420458 - Is it possible to export to Microsoft Excel 2007(.xlsx fromat) from Crystal Repots 2008?

Symptom

Is it possible to export to Microsoft Excel 2007(.xlsx fromat) from Crystal Repots 2008?

Environment

Crystal Reports 2008

Reproducing the Issue

Try to export the report from Crystal Reports designer. It shows the options to export to Microsoft Excel (97-2003) and Microsoft Excel (97-2003) Data-Only. However there is no option to export to export to Microsoft Excel 2007 or xlsx format.

Resolution

Office 2007 is a supported version with Crystal Reports 2008. Although Crystal Reports designer does not show the option to export to xlsx format the existing format of Microsoft Excel (97-2003) / Microsoft Excel (97-2003) Data-Only can be chosen. This will produce a file with xls format which is compatible and can be opened with Microsoft Excel 2007.

Crystal Reports XI R2 SP5 and SP6 also supports Microsoft Office 2007 as an Export destination.

See Also

1526412 - How to export Crystal report to Excel 2007 (.xlsx) file format from CrystalViewer?

Keywords

KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1