Skip to Content
avatar image
Former Member

Insert bitmap image dynamically into Crystal Reports


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


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?


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.


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


What step am I missing?



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 12, 2008 at 03:43 PM

    Hi Jac,

    What is the format in which the path is stored in your database?

    Ex: The path should be like "C:\Folder\text.jpg".



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Vinay,

      Please disregard my previous posting, the report is now being displayed with

      the path and filename from the database field. The problem was the set of

      double quotes that I incorrectly added in the database field. Once, I removed

      the set of double quotes, the graphic image displays OK.

      Thanks again,