INSERTING DYNAMIC IMAGE BASED ON PARAMETER - CRYSTAL REPORTS 2016

[Roguetrooper01]

Hi

I need to add an image to a works order based upon the part number on the works order.

I believe the way to do this is to insert a picture, go to Format picture and click on the X2 button.

That done I'm also sure that I need to enter the folder location, and then ensure that the picture file name I require, is equal to the the part number field in my report.

The file location is:-
\\Aeoserver01\FactoryMaster\FMAST11\M52480.jpg - with M52480 equal to the part number found within the field below.

{vFM_WORKS_ORDER_HEADER.PartNumber}

What I'm not sure of is how to create the formula to ensure I select the correct picture.

Any thoughts appreciate?

 

[lbass]

Select the field on the report->right click->format field->hyperlink-> and in the formula editor x+2, enter"

"\\Aeoserver01\FactoryMaster\FMAST11\"+{vFM_WORKS_ORDER_HEADER.PartNumber}+".jpg"

-LB