Survey123 Report: Get only the first entry to be displayed in the Summary Report

[jantolihao]

Hello, everyone.

I have created a Summary Report Template (in word doc) for the submitted entries from my Survey123 form. The submitted entries look like the screenshot below.

Now, my generated sample summary report looks like this when I tried selecting just 2 entries from my submitted entries and a summary report from it. The Customer and Date parameters printed also 2 values instead of just 1. (Please see screenshot below)

This is my sample summary report template used: (Please see screenshot below) 

Since I am creating a summary report, I placed everything under $<$summary> parameter. Please take note that I have $</> at the end to close it.

I have no problem with the rest of my report, except for the Customer and Date parameters.

I only need 1 value to be printed in the summary report for the Customer and Date parameters since values are the same for both of these parameters (Example: Under Customer parameter, all values are Company 1. For Date, all values are January 24-26, 2024).

Does anyone know here how to manipulate my summary report template so that it will only print 1 value for Customer and 1 value for Date?

Thank you very much in advance.

[jantolihao · Accepted solution]

Hello, everyone!

Update on this post: I already figured this out by adding the following parsing details in my report template:

${#survey | stats:”min,objectid,MinObjectID”:”customer”}${customer}${/}