Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 151
  • Last Modified:

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.


0
yongyih
Asked:
yongyih
  • 2
1 Solution
 
bobbit31Commented:
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
0
 
yongyihAuthor Commented:
I give you the marks first.   But, if i have problems with this question again, please help me, ok. ^^
Thanks.
0
 
Éric MoreauSenior .Net ConsultantCommented:
Why this question is still open? Points should have been given to bobbit31.
0
 
yongyihAuthor Commented:
Sorry.. just sent the commend but forgot to accept the commend as answer. =P
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now