Dynamically embed PDF - Change OLE file source

[tarquinng98]

Hello SAP Community,

I am trying to dynamically embed a PDF in SAP Crystal Reports 2016, similar to this question which was answered, but I am unable to follow the steps successfully.

- Notable Differences

• I am not using a database to retrieve the PDF's URL
• The PDF URL is a parameter, which I intend to pass from the main report (this is going to be a sub report)

- Steps I followed

1. Go to insert "OLE Object"
2. Select "Adobe Acrobat Document"
3. I linked to my "Place Holder PDF"
4. I placed the "Place Holder PDF" into the details section of the report
5. From the context options menu I went to "Format Graphic" and on the "Picture tab" I changed the "Graphic location" formula to PATH

- Testing

• I passed the same URL Path into the Hyperlink formula option.
• Clicking on the PDF opened the correct PDF in the default application handling PDFs on my system.

Could this be a problem with the OLE handler?

I am using Adobe Reader XI, and have tested this on a system with Adobe Acrobat DC installed.

Any help or clarification is kindly appreciated.

Thanks and Regards,

Tarquinn

[ido_millet]

What is the value in your {?Path} parameter?
If this is sensitive, just share the first portion of it.

[tarquinng98]

I used

C:\TEST\TEST PDF EMBED.pdf

I also tested this URL https://help.sap.com/doc/37c8938b12384f399940e22b7315979f/2020/en-US/cr20_usergde_en.pdf

The same parameter works for the hyperlink formula, cick event loads the PDF in my default PDF handler.

[ido_millet]

afaik, Crystal doesn't support https for this use case.
There is a way around that limitation by using a UFL.

[DellSC]

1. Try unchecking "Use original URL".

2. Be aware that Crystal will only show the first page of the PDF in the report. It will not expand to multiple pages.

-Dell

[tarquinng98]

Hi Dell,

I have unchecked the checkbox "Use Original URL", still having issues, my Place Holder PDF is not replaced..