Skip to Content

Exporting Crystal Report to Excel 97-2003 Exactly

I am using SAP BusinessObjects CrystalReports 2013 Support Pack 4 Version 14.1.4.1327 CR Developer.

I am trying to export my Report to Excel (97-2003) format. It exports, but not the way it gets exported in pdf format. My Columns get hidden. I tried with the export settings, but not applicable.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 07, 2016 at 06:25 PM

    Crystal is VERY picky about how things are formatted in order to get a "clean" Excel export.

    Please see https://archive.sap.com/documents/docs/DOC-39608 for information about how to do this configuration. Also note that if you're using an in-line subreport to get a single piece of data to include with other data on the same line, you will never get a clean export to Excel because of the way subreports are handled during the export.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 07, 2016 at 06:34 PM

    Also note that the formatting engine uses the Reports design printer so do not use No Printer and check on Dissociate.

    BOE then will have a better chance at formatting the same as what you see in CRD.

    Requires the printer to be installed on the BOE Server also.

    Don

    Add comment
    10|10000 characters needed characters exceeded