I need help adding images to my Crystal XI report

mainrotor
mainrotor used Ask the Experts™
on
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:  
C:\ReportImages\

How can I add the images to my report?

Thank you very much in advance,
mrotor
Comment
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
Commented:
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

Commented:
Sounds good.

mlmcc

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