Urgent! Print an image using data report.

I have a database that contain staff records.  One of the field is a string data type (path) that refer to the image (staff photo) in hard disk.

My problem is, how to print out the image when i print the staff information?

In same report, another problem is one staff/teacher, can teach more than one subject. I stored all the subjects that a staff teach in a table called "subjects".  How to print it how when i print the staff information.  I link it with staff ID.

Thanks first for your help.  Please give me the code within this two days.

Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

bobbit31Connect With a Mentor Commented:
you could do something like:

set DataReport1.Sections("Section1").Controls("Image1").Picture = LoadPicture ("<path to picture>")

for the second part, use a sql query something like:
select staff.*, subjects.* from staff inner join subjects on staff.staffID = subjects.staffID
yongyihAuthor Commented:
I give you the marks first.   But, if i have problems with this question again, please help me, ok. ^^
Éric MoreauSenior .Net ConsultantCommented:
Why this question is still open? Points should have been given to bobbit31.
yongyihAuthor Commented:
Sorry.. just sent the commend but forgot to accept the commend as answer. =P
All Courses

From novice to tech pro — start learning today.