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 Michelle,

Have you tried ${if (sc1 | getValue:"count")>=0} instead of ${if sc1}? See the Report Template Documentation for more information regarding this method.

This is the recommended method for hiding an empty repeat. We will update the feature report documentation to reflect this.

Thanks,
-Barbara

[MichelleTanner]

Thanks, Barbara. Using that syntax still produces an error for me:

Error: An error occurred when checking the report template. Failed to parse ${if (sc1 | getValue:"count")>=0}. The field name or parameters cannot be found in the current parsing scope.

[BarbaraWebster1]

In the screen cap of your XLS form, it looks like the repeat name is capitalized while the repeat name in the feature report is lowercase. Repeat names in feature reports are case sensitive so that might be what's causing the error. 

-Barbara

[MichelleTanner]

Barbara,

I've updated the values to caps, but it looks like it is still finding an error:

Error: An error occurred when checking the report template. Failed to parse ${SC1_ft}. The field name or parameters cannot be found in the current parsing scope.

[BarbaraWebster1]

Does your report template still include ${#SC1} ${/} placeholders to start and end the repeat? Those placeholders would still be necessary in addition to the if statement.

[MichelleTanner]

Ah, okay. I didn't know it needed to include both placeholders.

Now that I've included both placeholders, it passes the validation. But when I try to run a sample report, it comes up with a generic "error" (below)

Is this syntax correct?:

${#SC1} ${if (SC1 | getValue:"count")>=0}Drainage inlet protection

• Type ${SC1_ft}
• Location ${SC1_l}
• Findings(s) ${SC1_f}
• Notes ${SC1_n}
• Photos ${SC1_p1 | size:375:0:0:600}${/}${/}

[BarbaraWebster1]

It's hard to say what what's causing the problem based on that error message. If you are willing to send your XLS form and report template, I could look into it and see if I can narrow down the problem. 

[MichelleTanner]

Thank you, absolutely! I've just updated my question to include two attachments - the word template and the xls form. please let me know if you need anything else. 

[MichelleTanner]

Any luck figuring out that error?