Link to home
Start Free TrialLog in
Avatar of Michael Katz
Michael KatzFlag for United States of America

asked on

Add a .pdf to an existing Crystal Report that is a picture dynamically

I have a {StockCode} as a field in my report, I have {StockCode}.pdf in a folder within my network...

Is it possible to include this {StockCode}.pdf and insert into the Crystal Report so that it changes as the report changes??
Avatar of vasto
vasto
Flag of United States of America image

As far as I remember this will work for images but for PDF files you need to know the value during the report load (before any query to run) . If this is correct you will be able to use just hard-coded values. You can export the PDFs to images and try this approach or you can look for a software, which will be able to join your report with the existing PDF file. I guess there are multiple tools that can do this and I guess the other experts will add some names. I know that R-Tag (www.r-tag.com)  is able to join a report with existing PDF file(s) by exporting the report to a PDF and joining it with the other PDFs. It is free ( if you don't need tech support), so if a 3rd party tool is an option you can try it.
Avatar of Michael Katz

ASKER

How would I do it if its a jpeg?
Or bitmap
Avatar of Mike McCracken
Mike McCracken

Insert an image into the report
Click INSERT --> PICTURE
Right click the image
Click FORMAT GRAPHIC
Click the PICTURE TAB
CLick the FORMULA BUTTON the the right of PICTURE LOCATION
Enter a formula that returns the location of the image

mlmcc
Can you give me an example of a formula??  The problem is how do i reference this location based on the field
The formula just returns the filepath to the picture.

In your case it is just the field with the filepath

mlmcc
ASKER CERTIFIED SOLUTION
Avatar of James0628
James0628

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial