Crystal Report Image from SQL field with file location

John-S Pretorius
John-S Pretorius used Ask the Experts™
on
I have a Crystal report 2016 and want to show images, the image path is in sql and shown below

M2ENL1\Pack_12\11879\Event11879_7e4c5cd3-105b-4acc-a32f-ef76386926ee.jpg

Below Image is the actual folder.

Image folder
Any ideas would be greatly appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet Software

Commented:
Please clarify: what logic maps between the path stored in the database and the path the image is stored under? If 1-to-1, simply set it as the 'Graphic Location' expression.  If not 1-to-1, use that logic to convert from the database info to the actual path.
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Try this

Insert a PICTURE object on the report
Right click the image
Click FORMAT GRAPHIC
Click the PICTURE tab
Click the FORMULA BUTTON to the right of GRAPHIC LOCATION
Insert the database field with the graphic as the location
Click SAVE AND CLOSE
Click OK


mlmcc
John-S PretoriusSystems Engineer

Author

Commented:
That works perfect, thank you.

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