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
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.
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.
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!
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.
Curious if you've found a solution yet. I'm trying to do something similar.
vertical repeats in a table? see this solution https://community.esri.com/t5/arcgis-survey123-questions/unable-to-display-repeats-in-a-report-table...
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'.