Solved

Display .jpg files in CRP

Posted on 2004-08-25
4
359 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

762 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

19 Experts available now in Live!

Get 1:1 Help Now