Report on Entries Across All Awards
The Report Entries Across All Awards is a report which enables admin users to select one or more organisations and export data for all of the entries they have submitted across all awards. This report is useful for admin users who want to run like for like data comparisons across multiple years.
How to Enable the Report for ALL forms in your site
Before the Report Entries Across All Awards can be run admin users need to turn it on in the Configuration Values Section:
- Log into the Admin Interface
- Open Control Centre, scroll down and click to open General Settings
- In the Name column search for Enable export entries across all awards
- Click Edit in the Actions menu, and make sure that in the Value field there is written Yes. Save before exit
How to Enable the Report only for selected forms in your site
- Log into the Admin Interface
- Open Control Centre, scroll down and click to open General Settings
- In the Name column search for Enable export entries across all awards
- Click Edit in the Actions menu, and make sure that in the Value field there is written No. Save before exit
- Open the relevant Award
- Go to Settings
- Look for the Include in All Awards reports option and choose Yes
- Click Save
Important Note – If your site has multiple forms with many questions, the system may take some time to process and download all the data. Once you enable either option (in Awards Settings or General Settings), we recommend running the report about 1 hour later. This allows sufficient time for the system to gather the necessary information.
How to Run the Report
- Open Reports and click on Custom Entry Reports
- In the Custom Reports page, click on the … Actions menu icon either at the top-right of the page, or below the form, and click on Custom reports
- You will now be directed to the Saved Entry Reports page. Click on the … Actions menu icon either at the top-right of the page, or below the list of reports, and click on Update All Reports Data
- Once done, locate Report entries across all awards (normally it’s the last one in the list), and click on Run
- The report will now be automatically downloaded and placed into your designated Downloads folder
Note – This report is best used for awards with similar question sets. For each question the data will be exported in a separate column, unless the internal question names match. For awards with very similar question sets the data will be able to be viewed across awards but where the questions names differ you will likely see a report with many columns and there is no easy way to make sat a comparisons.