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.
Solved! Go to Solution.
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:
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_3...
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
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.
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:
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!