I need help adding images to my Crystal XI report

mainrotor used Ask the Experts™
Hi Experts,
I need help with a Crystal XI report.  I need to add images for each row in my report.
Currently, I display the ItemNumber, ItemDescription, and ItemQty.
The item information is stored in a SQL Server 2008 R2 database.
Here's the query I use for my report:  
SELECT  ItemNumber, ItemDescription, and ItemQty FROM tblItems

I would like to add images to each row\item.  Each image is named after the ItemNumber.
The images are stored in the following file path:  

How can I add the images to my report?

Thank you very much in advance,
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Professor of MIS at Penn State Erie and Owner, Millet Software
Insert, Picture
and select one of the pictures.

Right-click the Picture, Format Graphic...
Go to Picture Tab, and set an expression for Graphic Location:
something like:  "C:\ReportImages\" & ToText({ItemNumber},0,"") & ".png"
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Sounds good.


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial