Photo on Constituent Profile?

Options
Is there anyway to get a photo to appear on a Profile report?  I've been able to accomplish this with Crystal by inserting an OLE Object, but I'm wondering if the canned reports offer something similar directly from RE?
Tagged:

Comments

  • Chris Z:

    Is there anyway to get a photo to appear on a Profile report?  I've been able to accomplish this with Crystal by inserting an OLE Object, but I'm wondering if the canned reports offer something similar directly from RE?

    We add donor profile and event photos in Media, but can only seem to add them to the Profile Report once we export it as a PDF and pop the pic in using Adobe Acrobat Pro. I'll look forward to seeing if someone else has a better solution.

  • Chris Z:

    Is there anyway to get a photo to appear on a Profile report?  I've been able to accomplish this with Crystal by inserting an OLE Object, but I'm wondering if the canned reports offer something similar directly from RE?

    I've done the same thing with Crystal Reports and grabbing the OLE Object from the Media tab, but I've never seen anything like it in a canned report.  I would suggest voting for (or adding) such a suggestion in the "Ideas" section, but I, sadly, don't have much faith in that section these days (it seems to not get much attention -- features that have now been implemented for years are still in the "planned" category and I'm getting kinda cynical about Blackbaud's commitment to that list).

  • The link to vote for the idea is: https://re7.ideas.aha.io/ideas/RE7-I-4105

  • John Heizer:

    I've done the same thing with Crystal Reports and grabbing the OLE Object from the Media tab, but I've never seen anything like it in a canned report. 

     

    John, would you be willing to share how you got a media object to show up in a Crystal Report? I'm having trouble with it, despite following every tutorial I can. My counterpart for the collections database and I are baffled.

  • Bethany McCarthy‍ we abandoned this so long ago I really had to dig to find the report I was working on.


    In RE I would use the regular Custom Report Export to an MDB file with the profile data and include the related Media System ID (filtered to only the Media Type of "Profile Photo"). That System ID is the record number of the media record in the SQL database that I'd link to via ODBC to pull in the photo binary data. If I remember correctly you can then just grab the OBJECT field in the Field Explorer of CR and drag it into your report. I know that I could only get it to work with bitmap photos and we had to severely limit the photo dimensions (200 pixels wide maximum) to ensure the photo would fit correctly within the report. It was a interesting challenge, but ultimately turned out to be more trouble getting the photos into RE than it was worth.

Categories