Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Insert bitmap image dynamically into Crystal Reports

Hello,

I read the post by Zack H and the response by Asha Lund.

Zack:

I apologize but I am new to creating dynamic formulas. You're correct in that the photos are stored in a folder on a network path outside the main database. I am not clear as to how I can link the report with the pictures in this folder and have it display the corresponding photo for each employee in the report?

If it is not too much to ask, can you give me more details on the procedure in getting this to work?

Asha:

You can insert bitmap image dynamically with the help of OLE object in Crystal Report.Mentioned below are the steps to insert OLE object

1)Click on Insert Menu

2)Click on OLE object.

3)3)If you have existing image the click on "Create from file."

4)Place the image in the section.

5)Right click the OLE image ->FormateGraphic->Picture Tab.

6)In Graphic Location pane(X-2) specify the path.

JC:

I was able to complete steps 1-5. However, I am bit confused with step 6?

I opened the Formula Workshop editor, and I see the "Picture2" object and

"Graphic Location" underneath it. The path to the .JPG file is stored in a database

field named "GRAPHIC_IMAGE". How do I connect the database field "GRAPHIC_IMAGE",

to "Picture2"? I dragged and dropped the GRAPHIC_IMAGE field into the

formual editor, and "Saved and Closed" the editor. But, when I "Refresh" the report

I do not see the image associated with the path and .JPG image that is stored in the

GRAPHIC_IMAGE field.

What step am I missing?

Thanks,

JC

Former Member
Not what you were looking for? View more on this topic or Ask a question