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'.
Hi Addie,
This is exactly what I was looking for, thanks!
However, I need to tweak it a bit further and I was wondering if you would know how.
I created a hidden field within my repeats called 'hidden_field_repeat' which performs the once(count(${test_repeat})+1).
Then later in my survey, after the repeats are completed, I ask the user to number the repeat that is successful (to be included in the report). This field is an integer called 'repeat_integer'.
Within the report, I can make your expression ${#test_repeat| where:" hidden_field_repeat='1'"}) ${floc_type}{\} work. However, I need it to be 'repeat_integer instead of '1'. This doesn't work 🤔
Do I need to include any further expressions such as GetValue?
I appreciate any advice!
Thanks,
Nat
I managed to make it work like this:
${#test_repeat| where:"hidden_field_repeat='"+repeat_integer+"'"}) ${floc_type}
${/}
I hope this helps 🙂
Nat