SAP Knowledge Base Article - Public

3592427 - Overlapping Characters and Extra Spaces in Crystal report with inserted Word document as an OLE object exported as PDF

Symptom

  • Report designed with embedded OLE object (a Word document) in Crystal reports and when the report is refreshed and viewed from a custom application using the Crystal Reports Viewer, words appear scrambled.
  • There are extra spaces between words when the report is exported to PDF from the custom application.
  • Space is missing between words when the report is viewed from CMC.

Environment

  • SAP BusinessObjects Business Intelligence platform 4.3  SP04
  • Crystal Reports 2020
  • Custom .NET or JAVA Application 

Reproducing the Issue

  1. Get some text in a Word document and insert it as an OLE object in Crystal Reports;
  2. Try to adjust the OLE Object size - squeeze or enlarge the object;
  3. Save the report;
  4. Export the report to PDF;
  5. Notice that the words in the text appear scrambled or extra spaces between the words have showed up;

Cause

The issue arises when the OLE Object is adjusted horizontally (squeezed or enlarged) inside Crystal Reports.

MS Word based OLE objects horizontal adjustment is not supported for PDF export in Crystal Reports. 

Resolution

  • You should not resize any OLE Object inside Crystal Report, better adjust the text size in MS Word document before insert

or  

  • Take a screenshot od the text and save it as an image, such as .jpg or .png. Then, you should be able to make any adjustment without losing the format in PDF export.

    Keywords

    Crystal Reports, Crystal Reports Viewer,  OLE object, font, scrambled words, extra spaces, PDF export, CMC, horizontal adjustment, image. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , BI-RA-CR-DES , Crystal Reports Designer (CR20XX) , BI-RA-CR-VW , Viewers , Known Error

    Product

    SAP Crystal Reports 2020