Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Accessing Employee Pics and Displaying in Crystal Reports.

I am moving from Crystal Reports forum to here, hoping for a solution.

I am designing reports using Crystal Reports on SAP R/3 ECC6 using the SAP Integration kit for crystal reports.

Since i am working with Crystal Reports, all that i can access is Tables and Function Modules from APAB Dictionary.

For this specific task that is displaying employee pics in report forms i have discovered the following till now:

We have the PERNR of the employee whose pic we need.

We pass this PERNR to the function module

HR_IMAGE_EXISTS

FROM there we pass inputs to SCMS_DOC_URL_READ

CREP_ID = P_CONNECT_INFO - ARCHIV_ID

DOC_ID = P_CONNECT_INFO - ARC_DOC_ID

SET FOLLOWING RECORD SELECTION FORMULA:

{SCMS_DOC_URL_READ.I_COMP_ID} = "DATA"

and

{SCMS_DOC_URL_READ.I_SIGNATURE} = "X"

and

{SCMS_DOC_URL_READ.I_USE_LOCATION} = "A"

Output from this function module we get the url field, which is displayed properly.

output field: {SCMS_DOC_URL_READ.E_URL}

e.g. SAPR3://DF4117E7A1102CF188B4001A4BAAFA16/DATA

I tried using this url (E_URL) field as formula to Graphic Location of an OLE Object. But no pic shows up

In ABAP programs they use a method "LOAD_PICTURE_FROM_URL" of the class "CL_GUI_PICTURE". But unfortunately i cannot use this in Crystal Reports.

So i need to find a way to convert the file at the above URL into a picture, because i think its not stored in a picture format.

Any ideas?

Former Member
Not what you were looking for? View more on this topic or Ask a question