SAP Knowledge Base Article - Public

1922860 - Text appears below a picture, when exporting a report to MS Excel, despite the text displays on top of a picture in Crystal Reports

Symptom

  • Text does not display on top of a picture.
  • In Excel, the text does not appear on top of a picture, like in Crystal Reports.
  • The text does not appear on top of the image in MS Excel, when exporting a report from Crystal Reports to MS Excel format, that contains an image, with a text object  added on top of the image.

Environment

  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
  • SAP Crystal Reports 2025       

Reproducing the Issue

  1. In Crystal Reports, create a new report off any data sources.
  2. Insert a picture in any section of the report.
  3. Insert a text on top of the picture.
  4. Export the report to MS Excel format.
  5. When opening the spreadsheet generated in MS Excel, the text appears one line below the picture.
    It does not appear on the picture as it appears in Crystal Reports.

Cause

  • This is a limitation in Excel where it cannot hold image and text both in the same cell. That's the reason we see the text moved to a different cell.

Resolution

  • Since it is a limitation of the MS Excel format, there is nothing that can be done.
  • The suggestion will be to export the report to a different format, like to PDF.

Keywords

Crystal Report, Export to Excel, xls, XLS , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2016 ; SAP Crystal Reports 2020 ; SAP Crystal Reports 2025