Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Visual-Studio image , +
Hi folks,
 
Within our database application we have a number of staff, each of whom has a photo saved as a jpg file on the server.
We have developed a report with information about each person and would like to have the relevant photo displayed on the page with the person's info.
 
I am using Crystal Reports to create the report in a Visual Studio 2008 (VB) application.
 
The background database is a MySQL database running in a Windows environment.
 
I have imported the photos into a specific table for the purpose as BLOB data.
 
In the design mode of the Crystal Report I can see the picture for the first person on the report but when I preview the report the photo is not displayed - only the border of the relevant field.
 
Can anyone advise how I may achieve the display of a different image on each page of the report.
 
Thanks in advance,
Jerry.
Posted 9-Aug-11 5:22am
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

For the graphic control in your report, you will have a property that can take a file path. Set that to the field that has the jpg file name. That should do it, I think.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Hi folks,
 
Just typical - no sooner posted a help request than I get it working. All fine now. Issue was with importing the BLOB info to the table.
 
Cheers,
Jerry.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web01 | 2.8.1411022.1 | Last Updated 9 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100