Click here to Skip to main content
11,798,866 members (41,986 online)
Rate this: bad
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,
Posted 9-Aug-11 4:22am
Rate this: bad
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.
Rate this: bad
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.


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

  Print Answers RSS
0 CPallini 465
1 OriginalGriff 378
2 Maciej Los 305
3 Richard MacCutchan 281
4 phil.o 244
0 OriginalGriff 2,270
1 Maciej Los 1,810
2 KrunalRohit 1,496
3 CPallini 1,425
4 Richard MacCutchan 1,109

Advertise | Privacy | Mobile
Web03 | 2.8.151002.1 | Last Updated 9 Apr 2013
Copyright © CodeProject, 1999-2015
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