Recommendations for Post Processing Data, Running Queries, and Creating Reports

[ChristopherMatechik]

I created a survey123 App to replace an older system in which paper forms were brought into the field and then later entered into a Microsoft Access Database. The old Access database had numerous queries and reports that were automatically generated to meet our state and federal permit reporting requirements, and now I need to create the same reports from the survey123 data. Can this be done within the program? From what I can tell you can generate reports but they are for each individual survey. I need to report all of the data at the end of each year such that each survey is its own row in a table. Do I need to do import the data into ArcMap to do this? I'm guess there are plenty of ways to do this. I'm curious what some of you all do. My supervisor wants me to import the data into Access and then generate the reports but I prefer to keep workflows as streamlined as possible.

Thanks for your advice.

[Anonymous User]

Hi Christopher,

Currently reports can not be generated from within the app on the device, however after submission, reports can be generated on the http://survey123.arcgis.com/ website. There are two options to print reports, using the Print Individual Response option or the Report (Beta) option. Both of these are available on the Data tab.

The Report (Beta) option will allow you to create you own custom report, for more info see Print survey results—Survey123 for ArcGIS | ArcGIS and https://community.esri.com/groups/survey123/blog/2017/07/26/introducing-custom-form-report-templates....

We are currently working on the next update to the Report functionality which will include filtering, batch printing and other enhancements. Hopefully these improvements will help to meet your criteria to be able to print your.

Phil.