Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to display dynamic picture's on a report

Status
Not open for further replies.

san1234

Programmer
Nov 27, 2001
7
IN
I'm trying to include photo's onto a Employee profile report.One report contains many employees, so the photo will be different on each Employee section.I saved this photos as .jpg files (not in DB), so as to reduce the database size.

Thanks in advance.

EssDavis
 
Unfortunately, the only way a report can read pictures, is if they are in the database. It can't decode a path to the image file. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
ken,

How would you go about putting the pictures in a database? In my specific case, I have items in a Btrieve database and the .JPGs in a data directory.

Any ideas? Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office
 
The only way I know of is with BLOB fields, which may not be supported in Btreive. They are supported in MS Access (See the Empolyee table in the Xtreme.mdb, Photo field.

In the RDC, IF there is a path property for image files, you MIGHT be able to force the image to change during the reports run. This would only work from your VB Code, and I have never tried to find out if it would work. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Good Afternoon. I am a systems developer at Florida International University.
I have a encounter some difficulties while developing an online based employee profle report with Crystal Reports.
I found a response to my exact question here on tek-tips.com... CR can only read the picture if it is stored in the database.
That was my conclusion after some research...

My question is. How can CR convert the binary data stored in the database to a picture????
I appreciate your concern and time.
 

You add the the BLOB field as u do with other fields.
That means pls insert the particular field (picture) into
the report as u insert a name,code.....

pls feel free to have more queries if u still found problem.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top