Survey 123 Custom Report Conditional Statement

DoriBro

I've attached a report template (WC_TempWIP021821.docx) and one output report (Culvert_February_18_2021_DNR.docx).  The report template utilizes many conditional If statements so that only the questions that were answered will show up in the output report.  The custom report is working but it seems to add a bunch of extra lines between some of the sections of the report so it looks a bit sloppy.  You will see in the output report the "Crossing Information" section and "Was Follow Up Needed" section has multiple lines added.  I'm thinking it has something to do with the numerous "If" statements required because there are many different types of crossings that the survey handles.   

I'm wondering is there is a workaround for this or a better method of writing the If statements to generate a cleaner looking report.  Thanks in advance for any advice.

Culvert_February_18,_2021_DNR.docx

WC_TempWIP021821.docx

431170311_413519284601544_1417092907646413589_n.jpg

431764163_122115784784226223_2675368901456339305_n.jpg

BarbaraWebster1

Hello,

You could eliminate the unwanted returns in the exported report by placing those returns inside the conditional statement in the template report. For example, if you change this:

 

to this:

there will only be a return after the ${if WaterType | selected:”fish_water”} section if that section is shown.

Thanks,
-Barbara