Send image path to Crystal report8 through VB6 [modified]
-
I am working on large-scale project entitled as MIS (Marketing information System). As I told you that I am using Vb 6 as front end, Ms Access as back end and Crystal report 8 as reporting tool. 1) In the project it is required to save dealer’s photo, and it should be shown in individual dealer’s detail report, which will include his/her image. I had taken Common dialog box control to select image and display it in image control. 2) The size of database is very large then, which will be useful from the following? i. to store image to database? (But it makes database larger in size which leads to slower access) ii. Saving path of image in database To keep database safe I want to try the second option first. Instead coding directly into project, I want test the logic into small program first. As we know that by use of common dialog control we can select image and show it in image control. Also same path can be stored in database. Also we can retrieve the path from database and show it image control. Until here all things are ok. Now problem is that how to show the image in crystal report. Usually we pass the fields directly to crystal report by sending sql-query to it. If you require more details, please let me know. I will make it available. Regards, Kiran. -- modified at 1:42 Saturday 4th November, 2006
Kiran Sajanikar Software Engineer CleverBIT softwares. Pune.