Using URL's to grab a picture to display on report

[fparkerropes]

I want to display a photo of an employee above some information about the employee on a Crystal Report. The firm stores the photos in a folder on the firm's website. We can get the URL for each person's photo(.jpg). How do I use that to display on a report? I am currently using Crystal 10.

 

[Turkbear]

Hi,
Probably cannot have it display without user action:

You can create a formula that creates the link needed
( something like):

@PicLink
"[URL unfurl="true"]http://yourserver/images/"[/URL] + {<JPGNAMEFORTHISEMP>}

Then place it in the same location as the other employee data and right-click the field-
choose Format Field..
Select HTML as the 'Interpret as' selection..
Move to the Hyperlink tab, choose 'A Web Site' from the selections at the top
and for the web site entry,
clear the supplied http:// and, instead,
click on the formula button ( x*2) and insert the formula created above there..


Run the report..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kenhamady]

If you upgraded to v11 you could do this. There is a property that allows you to set the path of the jpg for dynamic images and this can be a calculated URL as well as a network or hard drive path.

Alternately you could use a third party external function that does the same thing for older versions.

http://www.chelseatech.co.nz/ctprod.htm#cViewIMAGE

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/

 

[fparkerropes]

Thanks. That worked. I upgraded to Crystal 11, put an Ole Object on the report, and put a formula in graphic location of format graphic editor usin URL for picture. Thanks again.