WEBVTT

00:00:00.070 --> 00:00:04.010
From Records, open Reports and select Saved reports.

00:00:04.409 --> 00:00:07.719
This is where you keep a reusable report instead of rebuilding

00:00:07.719 --> 00:00:09.340
the same query each time.

00:00:09.760 --> 00:00:13.720
The page explains that a saved report queries one definition, can

00:00:13.720 --> 00:00:18.090
group or aggregate its records, and can export the results to C S V.

00:00:18.569 --> 00:00:22.200
Results still respect record visibility and restricted fields.

00:00:22.649 --> 00:00:27.200
Select New report to begin a separate fictional community coordination report.

00:00:27.530 --> 00:00:30.350
Give the report a recognizable name and description.

00:00:30.870 --> 00:00:33.999
Select the definition that owns the records you want to review.

00:00:34.349 --> 00:00:37.440
Here it is the training community software exercise.

00:00:37.830 --> 00:00:40.809
The Columns panel then offers record fields and that

00:00:40.809 --> 00:00:42.490
definition’s detail fields.

00:00:42.799 --> 00:00:46.700
Select record dot number, record dot state, and Summary.

00:00:47.060 --> 00:00:49.839
These three choices become the three result columns.

00:00:50.169 --> 00:00:52.409
Leave Notes unselected for this example.

00:00:52.810 --> 00:00:56.739
A clear report name helps supervisors choose the right recurring review.

00:00:56.960 --> 00:01:00.630
Set Sort by to record dot number and check Descending.

00:01:01.039 --> 00:01:05.779
The first version is a detail report, so leave Group by and Aggregates empty.

00:01:06.170 --> 00:01:09.980
This makes the newest training number appear first in the recorded result.

00:01:10.310 --> 00:01:14.539
Sorting determines the order of rows; grouping is a separate decision.

00:01:14.960 --> 00:01:18.859
Later we will edit this same report to count records by state without

00:01:18.859 --> 00:01:20.480
replacing the detail columns.

00:01:20.679 --> 00:01:21.980
Scroll to Filters.

00:01:22.470 --> 00:01:28.509
This example uses a J S O N array with FieldKey set to record dot state, Operator

00:01:28.509 --> 00:01:31.610
set to Equals, and Value set to Finalized.

00:01:32.060 --> 00:01:34.860
Match the quoted text and brackets shown in the form.

00:01:35.289 --> 00:01:39.080
The inline example and schema help explain the expected structure.

00:01:39.549 --> 00:01:41.439
Set Max rows to twenty-five.

00:01:42.029 --> 00:01:45.980
Leave Include drafts and Include restricted fields unchecked.

00:01:46.410 --> 00:01:49.019
Leave Version mappings empty for this exercise.

00:01:49.449 --> 00:01:52.890
These choices keep this report focused on a small, permitted

00:01:52.890 --> 00:01:54.559
set of finalized records.

00:01:54.720 --> 00:01:56.749
Select Validate before saving.

00:01:57.200 --> 00:02:00.939
The page returns with The report is valid above the prepared

00:02:00.939 --> 00:02:02.720
settings and selected columns.

00:02:03.140 --> 00:02:06.749
Validation checks the report definition; it is not a result

00:02:06.749 --> 00:02:08.720
count and does not replace Save.

00:02:09.129 --> 00:02:11.900
Return to the bottom controls and select Save.

00:02:12.320 --> 00:02:17.820
The Saved reports page now shows Report saved, the report name, its definition,

00:02:18.109 --> 00:02:20.129
three columns, and the Run action.

00:02:20.480 --> 00:02:24.740
That saved row is the first readback that the reusable report exists.

00:02:24.880 --> 00:02:26.840
Select Run on the saved row.

00:02:27.290 --> 00:02:31.329
The result shows two of two rows, with Record number, State

00:02:31.399 --> 00:02:32.970
and Summary as configured.

00:02:33.440 --> 00:02:37.119
Both records are Finalized, and the larger training number is first.

00:02:37.529 --> 00:02:41.619
Compare those values with the purpose of the report before distributing its output.

00:02:42.119 --> 00:02:45.830
Use the C S V button on this result page to download the data.

00:02:46.330 --> 00:02:50.439
In this exercise the downloaded file contains the same three headers and the

00:02:50.439 --> 00:02:52.810
same two fictional records shown here.

00:02:52.959 --> 00:02:55.819
Select Edit and review the persisted settings.

00:02:56.120 --> 00:03:00.269
The three column choices and descending record-number sort are still present.

00:03:00.639 --> 00:03:03.270
Set Group by to record dot state.

00:03:03.670 --> 00:03:08.959
In Aggregates, enter a J S O N array whose object has Aggregate set to Count,

00:03:09.279 --> 00:03:11.810
exactly as the form’s Count example shows.

00:03:12.119 --> 00:03:16.679
This asks a different question: how many matching records are in each state?

00:03:17.029 --> 00:03:19.519
The original detail columns remain selected.

00:03:19.760 --> 00:03:23.180
Validate the changed report and confirm The report is valid.

00:03:23.629 --> 00:03:27.549
Use the same bottom Save control, then run the saved report again.

00:03:28.060 --> 00:03:31.480
The updated index identifies Group by record dot state

00:03:31.690 --> 00:03:33.299
and shows a Last run time.

00:03:33.720 --> 00:03:37.870
The new result has a Groups section: Finalized has a count of two.

00:03:38.280 --> 00:03:41.239
The detail section still shows the same two rows.

00:03:41.639 --> 00:03:45.850
Check both sections so that the summary count can be traced back to its records.

00:03:46.000 --> 00:03:49.519
Use this pattern for the records your department actually maintains.

00:03:49.940 --> 00:03:53.650
A community paramedicine or mental health response team can review

00:03:53.650 --> 00:03:55.449
completed coordination records.

00:03:55.810 --> 00:04:00.050
Search-and-rescue teams can summarize activity forms, security departments

00:04:00.050 --> 00:04:05.020
can review service records, and wildland contractors or industrial emergency teams

00:04:05.020 --> 00:04:07.030
can track their operational paperwork.

00:04:07.409 --> 00:04:10.520
Fire and E M S departments can use the same controls.

00:04:10.959 --> 00:04:15.479
Choose the appropriate definition, select only needed fields, validate

00:04:15.479 --> 00:04:19.220
the settings, and verify the detail behind each grouped total.
