how to dynamically change the photos in crystal report from vb

i have a table(employee) with three fields(empno,empname,imgpath), where
empno contains the employee number(1001), empname contains the employee
name(rakesh), and imgpath contains the file path of the photo of that
employee(c:\photos\1001.jpg(or 1001.gif,1001.bmp,1001.tiff)).
i want to prepare a report for this table using crystal report, i can place
the fields(empno,empname) in the crystal report, but how do i dynamically get
the corresponding photo of the employee.

thanks for your interest.

with regards,
B.Senthil Kumar

Even if you are using the full blown product, Crystal can only view a picture that resides in a database, it will not see pictures on file.

I have in the past created a second database in code that locates the required pictures and then writes them to the database as a byte array. Then you run the report with two database sources.

But even if you did that, you couln't have the pictures dynamic, the report would have to be run for every refresh.

akia
http://users.chariot.net.au/~akia/Home.htm