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

219
1
04-21-2021 09:25 AM
FrankDay
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.  

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

0 Kudos
1 Reply
FrankDay
New Contributor II

Resolved: by using the following

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

0 Kudos