Question Re: Dynamically embed PDF - Change OLE file source in Technology Q&A

Dynamically embed PDF - Change OLE file source

tarquinng98 — Tue, 01 Aug 2023 04:16:21 GMT

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

Go to insert "OLE Object"
Select "Adobe Acrobat Document"
I linked to my "Place Holder PDF"
I placed the "Place Holder PDF" into the details section of the report
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

Re: Dynamically embed PDF - Change OLE file source

DellSC — Tue, 01 Aug 2023 14:29:31 GMT

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

Re: Dynamically embed PDF - Change OLE file source

ido_millet — Tue, 01 Aug 2023 15:53:09 GMT

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

Re: Dynamically embed PDF - Change OLE file source

tarquinng98 — Wed, 02 Aug 2023 06:32:40 GMT

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.

Re: Dynamically embed PDF - Change OLE file source

tarquinng98 — Wed, 02 Aug 2023 06:35:28 GMT

Hi Dell,

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

Re: Dynamically embed PDF - Change OLE file source

ido_millet — Wed, 02 Aug 2023 12:28:41 GMT

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