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

You just have to create formula that returns the path to the image

For example

If {?Who} = "CB" THEN "C:\pix\CBSig.JPG"
Else "C:\pix\MRSig.JPG"

k.

Please do not crosspost.

-LB

Sorry about crossposting.

In your report, you can try creating a formula (Formula name example: IMG):

D:\BlazeLIMS Data\Attachments\BlazeLIMS\TestDoc\ + {doc_file.df_filename}

Close the formula
Then insert your dummy photo
Right Click and edit the photo
Choose Picture
Choose the Picture location (formula button) and enter: @IMG

That worked for me. Maybe it will work for you.

It might be:
D:\BlazeLIMS Data\Attachments\BlazeLIMS\TestDoc\Place Holder Image for Image Capture.jpg + {doc_file.df_filename}

Sorry. Maybe one of those will work for you.

Thanks Kim296,

Here is what ultimately worked for me:
In the "Graphic Location" formula box, I used the following:

"\\server name\folder name\" & {doc_file.df_filename}



Stephen

Hi Kim296,

I do have another question in regards to resizing the images so they fit on one page instead of getting cut and going to the next page.
Currently my (.jpg image files) are being displayed on two pages due to their large size.


Is there a script that would auto-fit the images to constrain them to one page?





Thanks
Stephen

Can you resize them by the drag and pull method or Format the Picture and change the width and height and Choose Not to Grow? Let me know if that works. I'm still learning myself.