Contact Picture

(0) Share

Report

Posted on by Community Member

Does anyone know how to expose the Contact photo in a report in Dynamics CRM 2016? I have a request to include the profile photo of a contact in a report. I am in a hosted environment, not necessarily online but still hosted so I don't have access to the SQL box. I suspect I have to do everything through FetchXML but I am unsure if that specific picture attribute being exposed for reporting purposes.

*This post is locked for comments

All responses (5)

Answers (1)

Thomas David Dayman 11,323 on at

Like (0)

Report

RE: Contact Picture

I think its possible in SQL. www.mssqltips.com/.../rendering-images-from-a-database-on-ssrs-reports
Community Member on at

Like (0)

Report

RE: Contact Picture

Hi Thomas, do you know if this is possible with SQL datasources (2015 on Prem)
Suggested answer

Community Member on at

Like (0)

Report

RE: Contact Picture

Perfect! Thank you Thomas!
Verified answer

Thomas David Dayman 11,323 on at

Like (1)

Report

RE: Contact Picture

Hi maxxsir,

Hopefully this link helps:

dynamicscrmcoe.com/display-image-ssrs-fetchxml-report
Suggested answer

Pitipe 686 on at

Like (0)

Report

RE: Contact Picture

I don't know if this helps but I do have the image in word templates that I created from Dynamics.

The 'field' is entityimage, all I did was map to a picture contentcontrol in my word template and it works.