Report with Photos (one to many relationship)
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
-
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
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
1 Kommentar