Core · Video walkthrough

Build, validate and run a saved Records report

Choose a definition and columns, validate a finalized-record filter, download CSV, and add a grouped count.

Audience: Department administrators, Records managers, Department supervisors

Before you begin

Chapters

  1. Find saved reports
  2. Choose the definition and fields
  3. Set the sort and keep detail rows
  4. Filter finalized records and limit the result
  5. Validate before saving
  6. Run and download the detailed result
  7. Reopen and add a grouped count
  8. Validate, save and rerun the changed report
  9. Apply the review to your department

Watch the walkthrough

Download video · Download captions

Step 1

Find saved reports

From Records, open Reports and select Saved reports. This is where you keep a reusable report instead of rebuilding the same query each time. The page explains that a saved report queries one definition, can group or aggregate its records, and can export the results to C S V. Results still respect record visibility and restricted fields. Select New report to begin a separate fictional community coordination report.

Find saved reports: screen 1
Find saved reports · Screen 1
Find saved reports: screen 2
Find saved reports · Screen 2

Practice

Find saved reports

Step 2

Choose the definition and fields

Give the report a recognizable name and description. Select the definition that owns the records you want to review. Here it is the training community software exercise. The Columns panel then offers record fields and that definition’s detail fields. Select record dot number, record dot state, and Summary. These three choices become the three result columns. Leave Notes unselected for this example. A clear report name helps supervisors choose the right recurring review.

Choose the definition and fields: screen 1
Choose the definition and fields · Screen 1
Choose the definition and fields: screen 2
Choose the definition and fields · Screen 2

Practice

Choose the definition and fields

Step 3

Set the sort and keep detail rows

Set Sort by to record dot number and check Descending. The first version is a detail report, so leave Group by and Aggregates empty. This makes the newest training number appear first in the recorded result. Sorting determines the order of rows; grouping is a separate decision. Later we will edit this same report to count records by state without replacing the detail columns.

Set the sort and keep detail rows: screen 1
Set the sort and keep detail rows · Screen 1

Practice

Set the sort and keep detail rows

Step 4

Filter finalized records and limit the result

Scroll to Filters. This example uses a J S O N array with FieldKey set to record dot state, Operator set to Equals, and Value set to Finalized. Match the quoted text and brackets shown in the form. The inline example and schema help explain the expected structure. Set Max rows to twenty-five. Leave Include drafts and Include restricted fields unchecked. Leave Version mappings empty for this exercise. These choices keep this report focused on a small, permitted set of finalized records.

Filter finalized records and limit the result: screen 1
Filter finalized records and limit the result · Screen 1

Practice

Filter finalized records and limit the result

Step 5

Validate before saving

Select Validate before saving. The page returns with The report is valid above the prepared settings and selected columns. Validation checks the report definition; it is not a result count and does not replace Save. Return to the bottom controls and select Save. The Saved reports page now shows Report saved, the report name, its definition, three columns, and the Run action. That saved row is the first readback that the reusable report exists.

Validate before saving: screen 1
Validate before saving · Screen 1
Validate before saving: screen 2
Validate before saving · Screen 2
Validate before saving: screen 3
Validate before saving · Screen 3

Practice

Validate before saving

Step 6

Run and download the detailed result

Select Run on the saved row. The result shows two of two rows, with Record number, State and Summary as configured. Both records are Finalized, and the larger training number is first. Compare those values with the purpose of the report before distributing its output. Use the C S V button on this result page to download the data. In this exercise the downloaded file contains the same three headers and the same two fictional records shown here.

Run and download the detailed result: screen 1
Run and download the detailed result · Screen 1
Run and download the detailed result: screen 2
Run and download the detailed result · Screen 2

Practice

Run and download the detailed result

Step 7

Reopen and add a grouped count

Select Edit and review the persisted settings. The three column choices and descending record-number sort are still present. Set Group by to record dot state. In Aggregates, enter a J S O N array whose object has Aggregate set to Count, exactly as the form’s Count example shows. This asks a different question: how many matching records are in each state? The original detail columns remain selected.

Reopen and add a grouped count: screen 1
Reopen and add a grouped count · Screen 1
Reopen and add a grouped count: screen 2
Reopen and add a grouped count · Screen 2
Reopen and add a grouped count: screen 3
Reopen and add a grouped count · Screen 3

Practice

Reopen and add a grouped count

Step 8

Validate, save and rerun the changed report

Validate the changed report and confirm The report is valid. Use the same bottom Save control, then run the saved report again. The updated index identifies Group by record dot state and shows a Last run time. The new result has a Groups section: Finalized has a count of two. The detail section still shows the same two rows. Check both sections so that the summary count can be traced back to its records.

Validate, save and rerun the changed report: screen 1
Validate, save and rerun the changed report · Screen 1
Validate, save and rerun the changed report: screen 2
Validate, save and rerun the changed report · Screen 2
Validate, save and rerun the changed report: screen 3
Validate, save and rerun the changed report · Screen 3
Validate, save and rerun the changed report: screen 4
Validate, save and rerun the changed report · Screen 4

Practice

Validate, save and rerun the changed report

Step 9

Apply the review to your department

Use this pattern for the records your department actually maintains. A community paramedicine or mental health response team can review completed coordination records. Search-and-rescue teams can summarize activity forms, security departments can review service records, and wildland contractors or industrial emergency teams can track their operational paperwork. Fire and E M S departments can use the same controls. Choose the appropriate definition, select only needed fields, validate the settings, and verify the detail behind each grouped total.

Apply the review to your department: screen 1
Apply the review to your department · Screen 1

Practice

Apply the review to your department

Examples for your department

Fire / EMS
Choose the appropriate department record definition and verify the matching output.
Community response
Choose the appropriate department record definition and verify the matching output.
Search and rescue
Choose the appropriate department record definition and verify the matching output.
Security
Choose the appropriate department record definition and verify the matching output.
Wildland
Choose the appropriate department record definition and verify the matching output.
Industrial
Choose the appropriate department record definition and verify the matching output.

Transcript

Download transcript
Read the complete transcript
Build, validate and run a saved Records report
Audience: Department administrators, Records managers, Department supervisors

Find saved reports
From Records, open Reports and select Saved reports. This is where you keep a reusable report instead of rebuilding the same query each time. The page explains that a saved report queries one definition, can group or aggregate its records, and can export the results to C S V. Results still respect record visibility and restricted fields. Select New report to begin a separate fictional community coordination report.
Practice: Find saved reports

Choose the definition and fields
Give the report a recognizable name and description. Select the definition that owns the records you want to review. Here it is the training community software exercise. The Columns panel then offers record fields and that definition’s detail fields. Select record dot number, record dot state, and Summary. These three choices become the three result columns. Leave Notes unselected for this example. A clear report name helps supervisors choose the right recurring review.
Practice: Choose the definition and fields

Set the sort and keep detail rows
Set Sort by to record dot number and check Descending. The first version is a detail report, so leave Group by and Aggregates empty. This makes the newest training number appear first in the recorded result. Sorting determines the order of rows; grouping is a separate decision. Later we will edit this same report to count records by state without replacing the detail columns.
Practice: Set the sort and keep detail rows

Filter finalized records and limit the result
Scroll to Filters. This example uses a J S O N array with FieldKey set to record dot state, Operator set to Equals, and Value set to Finalized. Match the quoted text and brackets shown in the form. The inline example and schema help explain the expected structure. Set Max rows to twenty-five. Leave Include drafts and Include restricted fields unchecked. Leave Version mappings empty for this exercise. These choices keep this report focused on a small, permitted set of finalized records.
Practice: Filter finalized records and limit the result

Validate before saving
Select Validate before saving. The page returns with The report is valid above the prepared settings and selected columns. Validation checks the report definition; it is not a result count and does not replace Save. Return to the bottom controls and select Save. The Saved reports page now shows Report saved, the report name, its definition, three columns, and the Run action. That saved row is the first readback that the reusable report exists.
Practice: Validate before saving

Run and download the detailed result
Select Run on the saved row. The result shows two of two rows, with Record number, State and Summary as configured. Both records are Finalized, and the larger training number is first. Compare those values with the purpose of the report before distributing its output. Use the C S V button on this result page to download the data. In this exercise the downloaded file contains the same three headers and the same two fictional records shown here.
Practice: Run and download the detailed result

Reopen and add a grouped count
Select Edit and review the persisted settings. The three column choices and descending record-number sort are still present. Set Group by to record dot state. In Aggregates, enter a J S O N array whose object has Aggregate set to Count, exactly as the form’s Count example shows. This asks a different question: how many matching records are in each state? The original detail columns remain selected.
Practice: Reopen and add a grouped count

Validate, save and rerun the changed report
Validate the changed report and confirm The report is valid. Use the same bottom Save control, then run the saved report again. The updated index identifies Group by record dot state and shows a Last run time. The new result has a Groups section: Finalized has a count of two. The detail section still shows the same two rows. Check both sections so that the summary count can be traced back to its records.
Practice: Validate, save and rerun the changed report

Apply the review to your department
Use this pattern for the records your department actually maintains. A community paramedicine or mental health response team can review completed coordination records. Search-and-rescue teams can summarize activity forms, security departments can review service records, and wildland contractors or industrial emergency teams can track their operational paperwork. Fire and E M S departments can use the same controls. Choose the appropriate definition, select only needed fields, validate the settings, and verify the detail behind each grouped total.
Practice: Apply the review to your department

Examples for your department
Fire / EMS: Choose the appropriate department record definition and verify the matching output.
Community response: Choose the appropriate department record definition and verify the matching output.
Search and rescue: Choose the appropriate department record definition and verify the matching output.
Security: Choose the appropriate department record definition and verify the matching output.
Wildland: Choose the appropriate department record definition and verify the matching output.
Industrial: Choose the appropriate department record definition and verify the matching output.