Running reports on submission data is one of the most common actions that program administrators perform. OpenWater provides some canned reports, but you can create your own custom reports as well.

To run a submission report, first navigate to your program.

Under the Submissions drop down menu, click Reports.

Run a Canned Report

By default, we have some canned reports ready to go for you. Most common is the Completed Submissions report. To run this report, click Select.

Click View List to view a quick list of the submissions in this report. To Export to Excel, click Excel.

If you have many submissions, the report may take some time to run.

Choose Columns to Export

The report will typically export all data from the submission form, user profiles, results, and other system data. If you only want to export certain columns / data to the excel file, click Advanced tab. Check the desired boxes and click Manage to choose which fields will be exported and click Save.

Create a Custom Report

You can create your own custom reports at any time by clicking Add Report.

Give your report a name. In our example, we will create a report that only outputs completed submissions in a car category.

We set our conditions so that Submission Status is Complete and Application Category Starts With Cars (to include all subcategories of Cars parent category).

You can create any report you like by mixing and matching conditions in the [all] and [any] section. Learn more about the OpenWater condition builder which is used throughout the system.

Did this answer your question?