1922860 - Exporting a Crystal Report with picture/image and text on top of image to excel format, the text on top of Picture appears one row below in excel file

SAP Knowledge Base Article - Public

1922860 - Exporting a Crystal Report with picture/image and text on top of image to excel format, the text on top of Picture appears one row below in excel file

Symptom

Crystal Report with image and text on top of image when exported to excel format, the text on top of image/picture appears one row below in excel file. It does not appear on the picture as it appears in the crystal report.

Environment

  • Crystal Report Designer 2008
  • Crystal Report Designer 2011
  • Crystal Report Designer 2013

Reproducing the Issue

  1. Create a new blank crystal report.
  2. Insert a picture/image (any format of picture ex: .png, .jpg etc.) in any section of the report.
  3. Insert a text on top of the picture.
  4. Export the report to excel format.
  5. In the excel file, the text appears one line below the picture. It does not appear on the picture as it appears in the crystal report.

Cause

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

Resolution

This is By-Design with the product

Keywords

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

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013