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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
5 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |