Menu
Help Center / Reports / Build a Custom Report: Dogs in Custody Over 10 Days

Reports · Detailed task guide

Build a Custom Report: Dogs in Custody Over 10 Days

This example was previewed in the demo using Intake / Custody, three filters, and descending length-of-stay sorting. It provides a reproducible pattern for a practical operational report.

Before you beginOpen Report Center → Create Report. Use a meaningful report name and choose whether it should be shared with authorized organization users.

Step-by-step instructions

  1. At Report Setup, enter Dogs in Custody Over 10 Days, choose an appropriate category, and describe its purpose. Select Intake / Custody as the Data Source.
  2. At Columns, select the fields staff need: animal number/name, species, intake date, custody status, days in custody, and current location. The example retained the source’s default nine columns.
  3. At Filters, select Add Filter. Choose Days in Custody, is greater than, and enter 10.
  4. Add a second filter: Species equals Dog. Add a third: Custody Status equals Active.
  5. At Group & Sort, leave Group By at No grouping for a detail list. Choose Sort By Days in Custody and Direction Descending.
  6. Select Preview. Review the source, columns, three filters, grouping, summaries, sort, matching rows, and record count.
  7. Check sample rows against their custody episodes. Dogs staying exactly 10 days are excluded by is greater than; use is at least for a different threshold.
  8. Choose sharing and favorite settings intentionally, then Save Report when the definition is ready. Reopen it from Report Center and confirm its result and name.

Fields and meanings

Field / controlWhat to review
Data SourceIntake / Custody
Filter 1Days in Custody is greater than 10
Filter 2Species equals Dog
Filter 3Custody Status equals Active
SortDays in Custody, Descending
Expected interpretationA list of qualifying active episodes, not all historical dog identities.

Screenshots

Select an image to open the full-resolution screenshot. Long forms may extend below the initial view.

Report Setup selects the approved data source.
Figure 1. Report Setup selects the approved data source.
Columns controls the fields included in the result.
Figure 2. Columns controls the fields included in the result.
The example filters active dog custody episodes with more than 10 days in custody.
Figure 3. The example filters active dog custody episodes with more than 10 days in custody.
The detail list is sorted by Days in Custody descending.
Figure 4. The detail list is sorted by Days in Custody descending.
The verified demo preview returned eight matching active dog custody episodes.
Figure 5. The verified demo preview returned eight matching active dog custody episodes.

Practical checks

Demo counts change as data resets or records change. Verify the criteria and representative rows rather than expecting the same count in your organization.

Troubleshooting

What you seeWhat to check
Historical outcomes appearConfirm the Active custody filter and source.
Cats or other species appearConfirm Species equals Dog rather than a broad text filter.
The result is emptyCheck spelling, operators, and actual source values in known records.
Download the Reports guide collection (PDF)

Interface reviewed October 12, 2026. Screenshots contain fictional demo records. Available controls depend on enabled modules and permissions.