Solved

Display .jpg files in CRP

Posted on 2004-08-25
4
370 Views
Last Modified: 2008-02-26
I have a Crystal Report that has 1 Group line and 1 Details line.  The Group is by Job Name, the Detail line has employee names (that are on that job that day) and a hyperlink to a picture of that person.  The actual jpg employee photos are stored on our server and the file path of the picture for each person is in a SQL 2000 table.  

Currently when the report is run you see the list of jobs and employees and are able to click on the hyperlink to seperately pull up each individual photo.  I would like to have the photos automatically open on the report for each person.  This would allow a user to print out the report and have a list of the employees on each job and a picture of the person right there.

Is this possible?  Any tips on how to approach this will be greatly appreciated.

Thanks in advance.
0
Comment
Question by:JWAGNER19
  • 2
4 Comments
 
LVL 10

Expert Comment

by:ebolek
ID: 11892732
If the pictures are in yuor database it is easy. You get them as blob fiedls from the database in astored procedure. Then you declare that proc as your datasource. Because they are the fields of the stored proc you can drag and sdrop the fields to yuor report and crystal will display the images for you.

Regards
Emre
0
 

Author Comment

by:JWAGNER19
ID: 11892810
I do not have the pictures in the database.  From what I read everyone discouraged doing this.  The suggestion was to keep the pictures on the server and just put the file path in the database.  What is your opinion on storing image files in a database?  It would be roughly 250 employee photos.  Any ideas on how to do the report using the file path?

Thanks
0
 
LVL 10

Expert Comment

by:ebolek
ID: 11892890
yes then you have a hard scenatio, only way to do is datasets. You create adataset then in the runtime you load the pictures into the dtaaset, The dataset will be the reprot source of your report

You fill the dataset and load the image into the datset,then in your report you put the field into your report and report shows the image

Hard to code but you will do it

Regards'Emre
0
 
LVL 42

Accepted Solution

by:
frodoman earned 400 total points
ID: 11893395
You can load a picture based on a filename as long as you're using the RDC with your application front end.  Sample code for doing this with CR9 is here: http://support.businessobjects.com/communityCS/FilesAndUpdates/cr9_vb_rdc_loadpic.exe.asp

There's nothing inherently wrong with putting the pics in your database - it just takes up space and in some scenarios you may have to store the same picture more than once (wasting space).  For the situation you describe, with a couple hundred pics, I would just put them in your table and make your report and be done with it.

HTH

frodoman
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now