• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 145
  • Last Modified:

Crystal Report Image from SQL field with file location

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.
0
John-S Pretorius
Asked:
John-S Pretorius
1 Solution
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
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.
0
 
mlmccCommented:
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
0
 
John-S PretoriusTechnical Service Manager, Mid-AtlanticAuthor Commented:
That works perfect, thank you.
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now