Reports

​

Overview

The Reports module gives church administrators a way to define structured data-collection forms that group leaders fill in on a regular schedule. Reports are highly flexible: administrators choose the fields, the frequency, the target group category, and the visualisation type.

---

​

Report templates

A Report defines the template:

​

View types

Reports can be displayed as:

---

​

Report fields

Each report has one or more ReportField records that define the questions leaders answer when submitting:

---

​

Submissions

A ReportSubmission is one leader’s submission for one report period: ReportSubmissionData normalises the field values for querying.

---

​

Demo reports

The seed data creates four report types:

---

​

Submission tracking

Leaders who have not submitted a report for the current period appear as overdue in the admin view. The system tracks expected submission dates based on submissionFrequency and targetGroupCategory.

---

​

Metric field maps

ReportMetricFieldMap links a report field to a dashboard metric key, enabling the dashboard to surface specific report values as KPIs without custom SQL.

---

​

API endpoints