Display .jpg files in CRP
Posted on 2004-08-25
I have a Crystal Report that has 1 Group line and 1 Details line. The Group is by Job Name, the Detail line has employee names (that are on that job that day) and a hyperlink to a picture of that person. The actual jpg employee photos are stored on our server and the file path of the picture for each person is in a SQL 2000 table.
Currently when the report is run you see the list of jobs and employees and are able to click on the hyperlink to seperately pull up each individual photo. I would like to have the photos automatically open on the report for each person. This would allow a user to print out the report and have a list of the employees on each job and a picture of the person right there.
Is this possible? Any tips on how to approach this will be greatly appreciated.
Thanks in advance.