Repeat Groups with Conditionals in Survey123 Report Not Working

[MichelleTanner]

Hello! I am trying to build a report that displays repeat groups in a report. Not all of these repeat groups are required, so I only want to show which groups have records in the report. 

However, I keep running into the error: An error occurred when checking the report template. Failed to parse ${sc1}. The field name or parameters cannot be found in the current parsing scope.

I am at my witts end. I believe I have the syntax correct and have triple checked everything, but it still will not work!  

Here is an example of the repeat group with conditionals. Ideally I put this in a nicely formatted table, but I am still just trying to figure out the syntax:

repeat group = sc1

each question within the group is then labeled sc1_l, sc1_f, etc.

${#sc1}${if sc1}Drainage Inlet Protection

• Location ${sc1_l}

• Type ${sc1_ft}

• Findings(s) ${sc1_f}

• Notes ${sc1_n}

• Photos ${sc1_p1 | size:375:0:0:600}${/}${/sc1}

Am I missing something here?? Thanks.

[BarbaraWebster1]

Hi Janella,

Thanks for sharing your forms. It looks like the end tag for the repeat is outside of the table that the rest of the repeat is in and that this is causing the error when a record includes multiple entries in the repeat section. 

If you move the end tag in your report template inside the table (to just after "${B_ServiceTec}") does that resolve the error for you?

-Barbara

[JanellaFlook]

Thanks Barabara,   I moved the end tag to the end as you stated and it now prints the same fields twice.  I have moved the closing tag to several different placed in the form and still prints the repeat fields twice?   I have attached and highlighted the print report and the template used. 

[JanellaFlook]

Barbara,   I just noticed, at this point I have two test survey124 forms completed for this location.  It is printing both Repeat sections for each date, one below the other.  I need to print only the last form completed.  What happens when I have multi forms (inspections) completed for the same location... will it print all?  How do I print only the most current? 

[BarbaraWebster1]

The default behavior for a repeat in a report is for each repeat to be shown, but you can limit which repeats are shown in the report by adding a query to the repeat start tag in the report.

For your report template you could change ${#BiAnnual} to ${#BiAnnual| orderByFields:"B_Inspection DESC” | resultRecordCount:1} . This would order the repeats by the date field and then limit the repeats shown in the report to one, so only the most recent inspection would be shown.

[JanellaFlook]

Looks Like that worked.  Thanks Barbara for your assistance

[BarbaraWebster1]

No problem, glad that worked for you!

[justin_scott8]

Hello Barbara, I am running into the same error as above.  I have attached my feature report template and .xls form here.  Thanks for looking into it.

[BarbaraWebster1]

Hi Justin,

All of the repeat end tags should be inside the table instead of after the table. The end tag should go after the last question in the table. See the attached report template with those changes incorporated.

You can also see the Repeats section of the Survey123 Report Templates Documentation for more information. 

Thanks,
-Barbara

[jantolihao]

Hello, @BarbaraWebster1.

I hope you are doing fine.

I have here a sample form (Sample Building Form.xlsx) with a repeat group. I am trying to generate a report using the attached feature report template (Sample Report Template.docx). However, I keep getting the same error above. So, I tried revising the report template. However, the output looks like this (please see screenshot below). I have attached the same generated output PDF as well (Sample Generated Report.pdf).

I noticed that each item in the "Additional Items" column were printed thrice. I only wanted to print every single item in the "Additional Items" column, whether they have entries or none, only once. I prefer to have an output something like this. (Please see screenshot below)

Do you have any suggestions on how to come up with this output? I did a couple of tests, but I couldn't figure it out how to revise my feature report template. Am I missing something out?

Thank you in advance for looking into it. I appreciate any ideas. Thanks again.