Inserting dynamic images in Crystal reports

[julie_jamieson2]

Following is the method required to add dynamic images to Crystal Reports.

The example adds the image from the item master.

NB: You will need to have the OADP table and the OITM table in your report, or have the relevant fields in your command.

The image path is stored in OADP - OADP.BitmapPath

IF ISNULL({OITM.PicturName}) THEN ‘’ ELSE {OADP.BitmapPath}&{OITM.PicturName}

First add a picture to your details section where your item code is using the insert picture icon:

This open a browse box, just choose any image, as it will be replaced in the next step

Right click on the image you have created & choose “Format Graphic”:

From the Editor, choose the Picture tab, then select the formula button beside Graphic Location .

Create a formula that starts with the bitmap path: {OADP.BitmapPath}, then adds the image name for the item code { oitm.PicturName}

You may also need to deal with NULL values in the graphic location path - e.g. IF ISNULL({OITM.PicturName}) THEN ‘’ ELSE {OADP.BitmapPath}&{OITM.PicturName}

You may need to do some image resizing, and put the can grow on to get the image to fit a space.

The image should now display dynamically.