topic Increase Maximum number of records allowed in one print request in ArcGIS Survey123 Questions

Increase Maximum number of records allowed in one print request

BenBaker1 — Fri, 30 Jul 2021 15:38:35 GMT

Is there any plans to increase the maximum number of records allowed in a feature report summary? I run a report each month that shows cumulative totals for the entire year, but this is the first month that we are over 1,000 inspections.

Re: Increase Maximum number of records allowed in one print request

Ruth_JiatengXu — Tue, 03 Aug 2021 11:42:49 GMT

Hi @BenBaker1

If you only need to the summary report for all records, you can use the !important filter to ignore the data filter and the this 1000 restriction. Please see the documentation for more information: https://doc.arcgis.com/en/survey123/browser/analyze-results/featurereportqueries.htm#ESRI_SECTION1_34D03ABEE83B49CE82B0B1D8FDCE04D1

For example, when you print the summary report using the sample summary template, no matter what you select in panel, you get the actual total record count in the summary report. So if you print summary report using the sample template you should see the total record count equals to 1018 in your case.

If you want to overwrite the selection and the 1000 limitation, use the !important filter. Please note this only works in the summary report, you still cannot print over 1000 individual report at a time.

Thanks,

Ruth

Re: Increase Maximum number of records allowed in one print request

BenBaker1 — Tue, 17 Aug 2021 18:18:24 GMT

Thank you for the response Ruth. Unfortunately, I don't think the !important filter will work, because my summary report is set up to populate individual cells in a table by month and inspection type. Thus, the !important filter would override those filters and my table would not be accurate.

Re: Increase Maximum number of records allowed in one print request

Ruth_JiatengXu — Wed, 18 Aug 2021 08:59:54 GMT

Hi @BenBaker1

The !important filter will only override what has been inherited from the data page (such as selection, 1000 limitation). If you put the !important at end of your where clause, it should work. e.g. ${Fire.. | where: "inspType=100 ... !important" | stats: "..."}

Here is my test survey, and I choose to print selected record only:

Here is my template:

Here is my final output, as you can see in the screenshot below, the !important override the selection:

Re: Increase Maximum number of records allowed in one print request

BenBaker1 — Tue, 31 Aug 2021 19:21:44 GMT

Thank you for clarifying, Ruth. I was still trying to create a selection before generating the report, which was exceeding 1,000 records. When I updated the summary report template with !important in each filter and only selected 1 record, the report shows the totals as-expected. Thanks!