For those of you who know how to replace an image with a different image within Crystal Reports, Please Help!!!


I am creating a report that will pull image files such PDF files etc. into the main report.

So far, I have imported an image placeholder that is located on my local server.
Its location will never change.

The image location is:
D:\BlazeLIMS Data\Attachments\BlazeLIMS\TestDoc\Place Holder Image for Image Capture.jpg

The database field that retrieves this file path is:  {doc_file.df_filename}

{doc_file.df_filename} will link to the image that I will want to have on the main report each time it is run. This image will always be different as well.

I am attempting to use the "Graphic Location" formula box to write a formula that will replace the (Place Holder Image for Image Capture.jpg) with the image that is linked to my database field: {doc_file.df_filename}.



I greatly appreciate any help on this matter!!!


Stephen

Hi Dell,

Thank you for your reply.

I did try the formula and I am still having trouble getting my placeholder image to update or to be replaced with the image file that my database is feeding my subreport.


Perhaps there is another way to pull images, PDFs, Word/Excel files from a database to appear in a report?


Stephen




Edited by Yosteevo777 - 06 Jul 2012 at 7:58am

Crystal Reports 2008

If IsNull({doc_file.df_filename})
Then
'D:\BlazeLIMS Data\Attachments\BlazeLIMS\TestDoc\Place Holder Image for Image Capture.jpg'
Else
'D:\BlazeLIMS Data\Attachments\BlazeLIMS\TestDoc\ + {doc_file.df_filename}'

Thanks hilfy,

All of our end users will be within our company's closed network.
The folder that contains the files that are read by Crystal Reports through the database field {doc_file.df_filename} is a shared folder located on one of our department's local servers. All users have read/write privileges to the folder.

I'm assuming my issue is related to my syntax being incorrect that I'm using within Crystal Reports. I have tried my formula in both the Graphic Location formula box as well as the Hyperlink information formula box.

I even tried local files on my desktop and my formula still did not replace the OLE placeholder graphical image.