Report Function: Creating a report from a survey with a repeat section. I want to only show the latest entry in the repeat.

FrankDay

We perform a test on a piece of equipment every year.  When I generate my report I get all the previous year's submissions.  I have attached a copy of the report that prints.  I want to get only the most current submission.  

${#BACKFLOWTESTRESULTS|resultRecordCount:1}

Results: ${FINALTEST}

${TESTPERSON}

${TESTDATE | format:”DD/MM/YY HH:MM”}

${/}

If I use the code above I get the submission from 2020.  I want to get the submission from 2021. 

Can anyone help me out, please? 

April Backflow Tests_122 records_20210421085524_sample (4).pdf

Backflow Test List.docx

AnLize_0-1714636089577.png

AGOL_AddStyles_added.png

FrankDay

Resolved: by using the following

${#BACKFLOWTESTRESULTS | orderByFields:"TESTDATE DESC" | resultRecordCount:1}