Reports

Reports

Reports

The Reports section provides tabular data views of information collected from participants. Each report can be filtered, sorted, grouped, and exported to Excel or CSV. Reports are found in the session sidebar under Reports.


Member Health History Report

Sidebar path: Reports → Member Health History
Required role: Participant Form Viewer or higher

The Health History Report shows medical and vaccination data collected from participants' health forms.

Default Columns

Column Description
First Name Participant's first name
Last Name Participant's last name
Asthma Inhaler Whether the participant uses an asthma inhaler
Inhaler Expires Expiration date of the asthma inhaler
Epi Injector Whether the participant uses an epinephrine injector
Epi Expires Expiration date of the epinephrine injector
OTC Auth Date OTC medication dispensing was authorized
Tetanus Vacc Has tetanus vaccination
Had Tetanus Has had tetanus disease
Tetanus Date Date of tetanus vaccination or illness
Pertussis Vacc Has pertussis (whooping cough) vaccination
Had Pertussis Has had pertussis disease
Pertussis Date Date of pertussis vaccination or illness
Diphtheria Vacc Has diphtheria vaccination
Had Diphtheria Has had diphtheria disease
Diphtheria Date Date of diphtheria vaccination or illness
MMR Vacc Has MMR (measles, mumps, rubella) vaccination
Had MMR Has had MMR disease
MMR Date Date of MMR vaccination or illness
Polio Vacc Has polio vaccination
Had Polio Has had polio disease
Polio Date Date of polio vaccination or illness
ChickenPox Vacc Has chicken pox vaccination
Had ChickenPox Has had chicken pox disease
ChickenPox Date Date of chicken pox vaccination or illness

Hidden Columns (available via Column Chooser)

Date of Birth, Height (inches), Weight (lbs), Insurance Company, Insurance Policy Number, Phone Number, Phone Extension, Email Address


Emergency Contacts Report

Sidebar path: Reports → Emergency Contacts
Required role: Any session or participant role

The Emergency Contacts Report shows each participant's primary emergency contact information.

Columns

Column Description
First Name Participant's first name
Last Name Participant's last name
Date of Birth Participant's date of birth
Emergency Contact Name Emergency contact's full name
Relationship Relationship to the participant
Address Emergency contact's address
Mobile Phone Emergency contact's mobile phone
Other Phone Emergency contact's secondary phone
Alternate Contact Name Alternate contact's name
Alternate Phone Alternate contact's phone number

Hidden Columns (available via Column Chooser)

Height (inches), Weight (lbs), Insurance Company, Insurance Policy Number, Participant Phone Number, Participant Phone Extension, Participant Email Address


Forms Report

Sidebar path: Reports → Forms Report
Required role: Participant Form Viewer or higher

The Forms Report shows form field data for a selected form type. Unlike the other reports, its columns are dynamic — they depend on which form type you select.

Selecting a Form Type

A Form Type dropdown appears in the top right of the report header. Select a form type to load its data. The grid populates with one column per field from that form, plus participant name columns.

If no form type is selected, the grid shows "Select a form type to view data."

Columns

Columns are generated from the form fields of the selected form type. Each field in the form becomes a column. Column names match the field labels as configured in Form Types.


Common Features (All Reports)

All three reports share the same grid capabilities:

Type in the search box (top right of the header) to filter visible rows. The search highlights matching text.

Sorting and Filtering

  • Click column headers to sort ascending/descending; Shift-click for multi-column sort
  • Filter row (below column headers): type values to filter specific columns
  • Header filter: click the funnel icon in a column header for dropdown-based filtering

Grouping

Drag any column header to the group panel (at the top of the grid) to group rows by that column. Right-click column headers for grouping options.

Column Chooser

Click Column Chooser in the action menu to show or hide columns. Many useful columns (date of birth, insurance, phone numbers) are hidden by default but available here.

Exporting to Excel

Click the Export button in the grid toolbar to download the current view as an Excel file. You can export all rows or only selected rows.

Exporting to CSV

Each report's action menu also includes an Export to CSV option (CSV file icon). Unlike the Excel export, the CSV export mirrors exactly how you've set up the grid:

  • It includes every row that matches your current filters and sort order, across all pages — not just the rows visible on screen.
  • It includes only the columns currently shown, in their current order — use the Column Chooser first to add or remove columns before exporting.

The file downloads as {Session Name} - {Report Name} {date}.csv (for example, Summer Camp 2026 - Health History 2026-06-23.csv). Exporting to CSV requires the same role as viewing the report.


Common Issues

The Health History or Forms Report shows no data

Participants must have submitted their health forms for data to appear. If the session has participants but the report is empty, check whether any forms have been submitted. You may also need the Participant Form Viewer role or higher.

The Forms Report shows no columns

Select a form type from the dropdown in the top right. If no form types appear, no forms have been assigned to this session, or no participants have submitted forms.


Q&A

Q: How do I see emergency contact information for all participants? A: Go to Reports → Emergency Contacts in the session sidebar. The report shows each participant's primary emergency contact. You can filter, sort, and export the data to Excel.

Q: How do I see vaccination records for all participants? A: Go to Reports → Member Health History. The report shows vaccination history and medical equipment (inhalers, epinephrine injectors). Use the Column Chooser to show additional fields like date of birth and insurance information.

Q: How do I export a report to Excel? A: On any report page, click the Export button in the grid toolbar. You can export all rows or just the selected rows.

Q: How do I export a report to CSV? A: Open the report's action menu and choose "Export to CSV." The CSV includes all rows that match your current filters and sort order — across every page, not just the page on screen — using the columns currently shown on the grid. Use the Column Chooser first if you want to add or remove columns before exporting.

Q: The Forms Report is empty — what do I do? A: Select a form type from the "Form Type" dropdown in the top right of the report. The columns and data change based on which form type you choose.

Q: Can I filter the report to show only certain participants? A: Yes — use the filter row below the column headers to filter by any column value, or use the header filter (funnel icon in column headers) for dropdown-based filtering. You can also use the search box in the top right.



See the Glossary of Terms for definitions of terms used in HealthForms.io.