Hey Everyone,
I get an error when making my report template, I want to list/order all of the selected records in a report like this:
![phess_luckstone_1-1698173580510.png phess_luckstone_1-1698173580510.png](https://community.esri.com/t5/image/serverpage/image-id/83846i811ACBFB143BF629/image-dimensions/262x204?v=v2)
Whenever I use: ${#survey|orderByFields:"objectid DESC"|resultRecordCount:3}${objectid}
It works for the object ID but if I change to ${outfall_number}, it messes up. And throws this error.
![phess_luckstone_0-1698173459131.png phess_luckstone_0-1698173459131.png](https://community.esri.com/t5/image/serverpage/image-id/83845i89A43E3167BA7085/image-size/medium?v=v2&px=400)
Currently my report has this but doesn't work
${#survey|orderByFields:"outfall_number"|result RecordCount:20}${outfall_number}
Any help would be amazing!