Click here to Skip to main content
15,904,497 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I am using MS Access table named "House_mst" containing the following fields:

camera_no                     Text
pno                           Text
pic                           Text   // This field have path of image (i.e. .jpg file)


through Crystal report 8, I want to display the image mentioned in path in field "pic" dynamically. Plz help me. Its urgent. what i have to do?
Posted
Updated 26-May-12 11:45am
v2
Comments
ShaikhM 29-May-12 0:08am    
Very difficult. Can you elaborate.

1 solution

I am not sure about Crystal 8, but this works in Crystal 11 so try and work out something similar.

1) Insert a picture in your report. You have to start with some picture, it doesn't matter which one.

2)Right click on the picture and choose Format Graphic from the popup Format menu.

3) Click the picture tab in the Format Editor dialog.

4) Click the Graphic Location formula button at the bottom of that page.

5) Drag and drop your parameter into the formula section. Your graphic location formula should just contain the parameter field.

6) Save it.

7) Now when you pass your parameter, you should not enclose it in quotes: that will not compute. Just pass the path to the image and the image name, such as c:\pics\cat.bmp.


That should do with some alterations here and there.
 
Share this answer
 
Comments
wsun87 25-May-13 0:12am    
Hi,

I'm also facing the same problem in crystal report 8 to display picture by retrieving the picture path from database(SQL 2005). I found that there are no Graphic Location formula button under Format Editor dialog in crystal report 8. Do you have any others solution ?
Hope can get your help as soon as possible.


Thank you.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900