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

04-21-2021 09:25 AM
New Contributor II

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.  


Results: ${FINALTEST}


${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? 

0 Kudos
1 Reply
New Contributor II

Resolved: by using the following

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

0 Kudos