Reports - Questionnaires

This report is aimed at branches and organizations that have used a questionnaire in their online store. It allows you to display the answers to your questionnaires.

Filter Options

Using the filter options allows you to narrow your search results. By leaving a filter blank, your report will include all options in that field.

Fields marked with an * are mandatory

* Organization: You can use the drop down or the tree to select an organization. (Selecting another MHA is permission based).

* Period: By default it will be set to the current season. Use the drop down to select a different season if needed.

* Form: Forms can be used by registration fees, membership fees or clinics.

Registration Fee: You can use the drop to select all registration fees, or target the registrations fees you want to report on.

Membership Fee: You can use the drop to select all membership fees, or target the membership fees you want to report on.

Clinic: This will be grayed out, unless you select a form that was used in a clinic.

Gender Identity: Use drop down to filter by male, female, prefer to to say or prefer to self describe.

Date of Birth - Start & End: You can use the birth date range to narrow your search.

 

Action Button

  • New custom report - You can create your own custom appeals report that will allow you to choose the columns that are generated.

  • Export excel - click to export your report

 

Custom Reports

You can create a custom report using any combination of the default columns listed below.

To create this report, click New custom report from the Action button, or the New custom report button located at the top of the search result display.

 

Give the report a name, and a description (optional but is useful if you want to save the custom report and use it again later). Click the box Save Filter Values if you want to save this custom report. Next, select all, or choose from the column options, then click Save.

 

Questionnaires Report Default Columns

  1. Invoice Number

  2. Item Name

  3. Item Type

  4. Division Name

  5. HCR Number

  6. First Name

  7. Last Name

  8. Birthdate

  9. Gender Identity

  10. Gender Identity Description

  11. Email

  12. Parent 1 - First Name

  13. Parent 1 - Last Name

  14. Parent 1 - Email

  15. Parent 1 - Phone

  16. Parent 2 - First Name

  17. Parent 2 - Last Name

  18. Parent 2 - Email

  19. Parent 2 - Phone

  20. Amount

  21. Paid Amount

  22. Due Amount

  23. Owed Amount

  24. Name on the Invoice

  25. Email on the Invoice

The next columns will be the questions you have listed on your questionnaire.

 

Search Results

In each of the columns, you will find a sort option with a directional arrow letting you know which way the sort is going in.

The blue arrows allow you to move from left to right when viewing the columns of your report.

Click on the Show box to change the amount of lines visible in your search results.

 

Exports

You can export your reports by clicking on the Action button and selecting Export Excel, or from the export button located at the top of the search display results. Using the export button, you can export to CSV or Excel.

A history of your exported reports can be retrieved from the Exports menu.

Tips

When using any of the filters for your search, the system will save your most recent options. to clear your search history, either click Clear, or click on Reset filters.

There will be times that your report is too large to display on the screen. A message will appear - Your report is too heavy, click here to download the complete report. Click on it, and you can view the full report from the export.

 

Â