SAP Knowledge Base Article - Public

3064879 - Cannot change Location Path of an Excel OLE Object

Symptom

 Cannot change Location Path of an Excel OLE Object.

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Reproducing the Issue

  1. Create an Excel OLE object in a crystal report
  2. Right click on the OLE object->Format graphic->Picture-> add a new Graphic Location to another Excel file
  3. Notice that the OLE object is not updated

Cause

  • The "Graphic Location" feature only supports the image formats that can be shown as an image in the formatted report page,And that is why this functionality is available under "picture" tab.
  • The image format can be DIB, EMF, OleImage, or other image formats that are supported by third party libraries like paintLib.
  • Graphic location of OLE objects such as Word, Excel, and PDF is not supported because the designer can not dynamically vary their file location.

Resolution

Create a new OLE Object and delete the previous one.

See Also

1199940 - Unable to preview the entire OLE Object document inserted on a report in Crystal Reports

Keywords

CR, 4.2, 4.3, 4.1, limitation, workaround , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020