Creating a report with repeats

[LydiaCarey]

Good afternoon everyone,

I am very curious if this is possible. I trying to create a report which has a lot of information on it and trying to keep the pages to a minimum. In my survey I have a repeat and I am wondering in my template i can create a "sideways" table for it. Its currently not working out for me and just wondering if anyone has any suggestions on how i can display all this repeat data in a minimalistic way

 

 

[Katie_Clark]

Is the first screenshot you shared what you want the output to look like? I'm not quite sure what you mean by a "sideways" table. 

[Juneau_GIS]

When I first looked at reports I was trying to do the same.  My interpretation of sideways table:

I would love to be able to recreate this style with 1 report per feature, Sewer Manhole in this case.

[Katie_Clark]

In this case, since there is a set number of entries (maximum of 5 pipes in, two pipes out) I think your best bet will be to have specific questions for each cell. Each column in the table (pipe) could be a different group to help keep things a little better organized in the UI. But that way, you can reference specific field names to pull into the feature report. 

I know that's not the ideal answer, but as far as I know, you can't format repeats to populate vertically like that. I'd love to know if that's incorrect, though!

[LydiaCarey]

Sad that's exactly what I am looking for, my repeats to populate vertically. Ill have to find another way to show the repeat data that doesn't take up multiple pages.

[JenniferWeaver1]

Curious if you've found a solution yet. I'm trying to do something similar.

[DavidCook2]

vertical repeats in a table? see this solution https://community.esri.com/t5/arcgis-survey123-questions/unable-to-display-repeats-in-a-report-table...

[AddieZannes1]

I think I worked out a solution to this problem.  The first step is to add a hidden integer field to your repeat which calculates a sequential number for each record in your repeat.  

once(count(${gfs_rpt_time})+1)

This is the formula for the calculation but replace ${gfs_rpt_time} with any field in your repeat.  Now you will have a value of 1, 2, 3 etc for each record in your repeat.

Then, in your report template, add the following where statement to the first part of your repeat section.  The structural_repeat_no field should be whatever you called your new integer field.

${#structural_repeat | where:"structural_repeat_no='1'"}

The only other issue is that if you are inserting the repeat values into a single table in Word, the repeats will populate in rows instead of in columns.  To overcome this, add each repeat section into a separate vertical table with one column.  Add the next table to the right with one column and start the repeat with a where clause that specifies "structural_repeat_no='2'.