Insert / Export attachment photos to report ?

[JackZHANG]

Hi,
The attachment function in ArcGIS desktop is great. However, I wonder whether it's possible to export the attachment (mostly are photos in my case) to report, something like asset report that have a few words for each asset and a couple of photos.

Thanks.

[LisaMcAleer]

Hi Jack,

Did you ever find a solution to your issue?

I could use some ideas when it comes to inporting geodatabase attachments in ArcGIS Reports. I have an SDE feature class with attachments enabled (photos taken out in the field), and I'd like to bring these pictures into our ArcGIS reports. It sounds easy enough to do in HELP, all 2 sentences: 

“ If you are generating a report on Geodatabase data with Attachments enabled, you can add a RelatedReport control to access the attachment table and use attached images from the Blob field as the source for your picture element.

Tip:   When using attachments, a definition query that filters the attachments by file types will be applied by default. The query is this: "Content_Type LIKE 'image/%'. If this query is removed, all attachment files will be used when generating the report, but only images will be displayed.”

So after adding the attachment table to the MXD they are using for the report and relating it to the inspections point feature class, I added a RelatedReport control into the report (a box to hold the image) -- that’s all good.   But when I go to choose my data source for that RelatedReport image element, the blob field (called “DATA” by default when the attachment table is created) is not in the drop down list of available fields.  Every other field in the attachment table IS in the dropdown list, but not the blob field…..   I can type in the name of the blob field, but nothing happens.   If I use any of the other available fields, I get the content of that field displayed in my report, but none of those are the image

What I’m missing?????????   I’m so close, and yet so far away………

Thanks much!

Lisa McAleer

[ClaytonCooley2]

@Lisa... Did you ever have any luck with this? I'm currently trying to do this exact same thing and keep getting the same result as you.

[SuzannePolk]

I am trying to do the same thing and having no luck either.  If anyone has some advice about adding images to a report I would be eternally grateful!!!

[CynthiaMatney1]

So I am having the same issue - no blob field called "DATA" in the drop down list.  Did you ever figure out what the issue was?  I am trying to add pictures to a sewer manhole inspection report and the pictures are there in the related attachment layer - but no DATA field showing up when trying to add said pictures to the report.

Thank you!

[PeterFerretti]

Hi All,

This is possible. Just be sure of the following:

- Add a RelatedReport element to your primary report layout (in the detail level in my case).

-Double click on the RelatedReport to open it in design view.

Add a Picture element to the RelatedReport

Change the image source of the Picture element (right hand side in element properties) to the "DATA" field

Change the Size Mode to Stretch (works best for me)

Arrange the size of the Picture element so it takes up most or all of the space of the RelatedReport

Arrange the size of the RelatedReport itself in design view of your primary report to ensure you have the image sized and aligned properly.

Run the report and you should be good to go!

[ZRex]

Hello!

I hope you are still around Peter!

This was very helpful and I was able to get a little farther along in my project.  I am running into an issue where the "Data" field is not showing up.

Here is how my database is set up (with the "1 to many" being the relationship type):

Form 1 (main table) - 1 to many - Photo table - 1 to many - Photo Attachment table.  

The blob field is in the Photo Attachment table but I cannot directly relate the attachment table to the main table (Form 1).  When I insert a related report into the main report for Form 1, I can set the relationship to the Photo table but I cannot set the relationship to the Attachment table.  Even if I insert another related table into the first one.

Thoughts anyone?  Thanks for your help and I hope everyone is staying safe during this craziness. 

[ClaytonCooley2]

Peter,

Your instructions worked perfectly! This will really help us generate reports based off of field inspections. Thanks so much!

[JacquelineKovarik]

This forum saved me so much time! Thanks Peter Ferretti​ for taking the time to explain the process.

[MariusBurger]

I am trying to create a report with attachments for 154 records in my FGDB. When I run the report I get a "System.OutofMemoryException: Out of memory" error. Any ideas why?

If I run it on a few selected records it works 100%