Report with Photos (one to many relationship)

Jill Ryan

April 26, 2018 21:23

What is the best way to add photos to a report for a one to many relationship:  one point, many photos?  The photos are store as blobs in a related attachments table.  They have an Attachment ID and an Object OBJECTID, etc.  It seems the answers in past inquiries are dated.  Have there been any new methods to deal with this issue?  Thank you.

 

 

0

• 

  John Nerge

  April 27, 2018 13:49

  I honestly haven't set up a one to many report in a long time, but if I remember correctly, it's fairly straightforward.

   

  Assuming you have the one to many data link set up for the layer and its associated photo table, you should be able to set up a report that will put as many photos as you have into it.

   

  Here are the settings I use on my mailing labels report, which prints labels in three columns. I'm assuming you could use similar setting to print photos in three columns. I think the main trick was to set ColumnDirection to AcrossDown and ColumnCount to 3.

   

  _img_ alt="User-added image" src="https://latitudegeo--c.na53.content.force.com/servlet/rtaImage?eid=907f2000000bqRP&feoid=Body&refid=0EMf2000000cZsV"_/_img_

   

  I'd suggest trying to get the photos to export first and then deal with inserting as a subreport after, if that's what you're ultimately going to do.

  0

Please sign in to leave a comment.