Sorting Fields in a repeat Report Template

Question

Hello S123 team mates, I can use some guidance on how to sort fields within a Repeat Section in a Report Template (Word Document).

Is it possible to use the 'orderByFields' in a repeat section?

Here is the syntax that does not work for sorting:

${#repeat_tree_survey | orderByFields:"tree_tag_id ASC"}

Survey Site:             South Watershed Monitoring

Tree Tag ID:            ${tree_tag_id}

Survey Date:            ${Tree_Survey.survey_date}

Tree Species:           ${tree_species}

${/}

Your thoughts and tips are greatly appreciated!

Debbie

TrafficOpsGIS · Answer

Please see screen shot of how to format table in word doc in order to accomplish.

Report_Repeats.PNG

abureaux · Answer

You can use sorting in the Feature Report just fine for a repeat. See Report templates

${#defects | orderByFields:"state_name ASC, pop2000 DESC"}...${/}

EDIT: forgot to mention, but please ensure that your field (tree_tag_id) is a number and not a number stored as text.