how to create a if statement for a report?

[JoseBarrios1]

Hello everyone

I am having hard time creating a report from survey123. First, I'm trying to just get a sample report using the the "individual record" template but it won't open on Word. I'm getting the attached pic error in word.

My second problem is trying to populate on a report the select_one question that have "other" answer.

The formula works in XLSForm but not on the report. It is just a simple "if statement" that record the entry on <other assessor> field if "otherAssessor" is selected on the select_one questions, otherwise <assessorname> is recorded. 

if(selected(${assessorName},'otherAssessor'),${other_Assessor},${assessorName})

 I just realized that the "if" expressions are different for the report but I can't find any examples or documentation. 

I try this but still won't work: 

${if assessorName == " otherAssessor "}${other_Assessor},${assessorName}${/}

Any suggestions?... Thanks

[DougBrowning]

try this post

https://community.esri.com/t5/arcgis-survey123-questions/survey123-report-template-if-statement-with... 

[JoseBarrios1]

Thanks Doug,

I did look at that example, but is not clear to me what was the solution!

[DougBrowning]

Sorry I do not use it much but it almost looks like there is no else.  So if yes do this is all there is.  Prob need 2 if statments to simulate a if.  Just a guess.

[Nicole_Ueberschär]

It looks to me like there are blanks around the expression. " otherAssessor " is not the same as "otherAssessor". And then the reports don't have an else option, they only execute if the expression is true and don't if not. If you need an else then as DougBrowning said, you need another if statement that covers the other options (!="otherAssessor").

Regarding the word issue: did you try this yet? https://support.microsoft.com/en-us/topic/how-to-resolve-the-problem-word-experienced-an-error-tryin...

[JoseBarrios1 · Accepted solution]

Thank you Nicole and Doug,

I go it to work! As you indicated, I created a second "if" statement to evaluate the "other" option. Thanks once again for your suggestions! 

Here is the expression for reference!

${if assessorName == "otherAssessor"}${other_Assessor} - ${assessorName}${/}${if assessorName != "otherAssessor"}${assessorName}${/}

Thanks,

JB

[JoseBarrios1]

I forgot to mention that the issue with word not reading the sample template created by survey123 still not working for me. The MS link suggested by Nicole does not work to solve the issue . I still unable to open ANY sample template (individual record or Combined) created by syrvey123. 

[Nicole_Ueberschär]

Sorry to hear that the MS link didn't solve your issue. Do you want to try the attached template? It was only downloaded not further manipulated in word. (It belongs to a quiz in case you wonder about the questions.) 

Did you try a different browser yet? Tech support's favorite advise is clearing the cache 😉  Did you try yet to open the file from a different location?

[JoseBarrios1]

Thanks  Nicole,

The file that you attached opened without any problem! I'm not sure what it is going on with the one I created! I did try to download the file with Chrome and Firefox and from different location.

[Nicole_Ueberschär]

Really strange. Is it only for this particular survey or is it happening for all surveys? Do you have (by any chance) another subscription where you could try downloading the template?