Custom reports let you choose exactly which records and fields to analyze. You can start with a template from the report library or choose Build a report and start from scratch.
The action is labeled Build a report, not Create Report. Find it in the report library at More > Reports. If the action is missing, review Settings > My Permissions for reporting access.
Start With a Data Source
The builder's primary data sources include Pets, Adopters, Fosters, Volunteers, and Transports. Additional report definitions and templates can use Adoptions, Foster Assignments, Medical Records, Vaccinations, Procedures, Events, Drivers, and Prescriptions.
After selecting a source, give the report a clear name and optional description.
Pets in the Archived status are left out of custom reports, including pet details joined into a report on another data source.
Choose What the Report Shows
Use the builder to configure:
- Columns for the values shown in each result row.
- Related data when the report needs records connected to the primary source.
- Filters to include only matching records.
- Sorting to control result order.
- Grouping and aggregation to count items or calculate totals, averages, minimums, and maximums.
- Date range for time-based data.
The preview updates as you build so you can confirm that the selected fields and conditions produce useful results.
Use a column's eye toggle to hide it without removing it. A hidden column is kept with the saved report and appears dimmed in its place when you reopen Edit. A report needs at least one shown column before Create or Save is available.
Filters support thirteen operators: equals, does not equal, contains, starts with, ends with, greater than, less than, greater than or equal, less than or equal, between, is empty, is not empty, and is one of a list. The operators available for a particular field depend on its data type. The contains, starts with, and ends with operators ignore capitals and accents, so "zoe" matches "Zoë".
For example, to review last month's adoptions, start with an adoption or outcome template, set the adoption date range to last month, include pet name and species, and add payment method when that field is available to the selected report definition. Export the finished result rather than printing each adoption receipt individually.
Start From a Template
Templates provide ready-made columns, joins, filters, and sorts for common questions across animal care, medical work, outcomes, fosters, adopters, volunteers, finance, events, and operations.
Open a template to preview it. The Customize panel lets you reorder or hide its columns and add other available fields. Choose Open builder when you need to change filters, related data, sorting, or grouping. Choose Save to create your own reusable copy.
Work With a Saved Report
Open a report from the Saved reports workbench to run it with current data. You can change the date range without changing the saved definition, then use Save to make that range the default. Use Edit to change the report definition itself.
Grouped reports with aggregated fields include a chart above the detailed results. The bar chart draws the first 50 groups in report order and says how many groups there are; the table and summary cards still use every group. A summary card for an Average column shows the average across every value in the report, not the average of the group averages, and averages keep up to two decimal places. Copy link copies the current report URL, including its active date range.