Arrest Detail with Incident

CJIWave 3

9 reports · 71 runs (12 mo) · Complex · Target: Paginated report

Member reports Template Power BI output Validation (6)

Name	Source	Folder	Runs	Last run	Mapping
Arrest Detail with Incident - Agency D (2024)	CRCrystal	Arrests	22	9/11/2026 3:02 PM	Mapped
Arrest Detail with Incident - Agency L (2024)	CRCrystal	Arrests	15	8/30/2026 4:41 AM	Mapped
Arrest Detail with Incident - Agency E (2026 YTD)	CRCrystal	Arrests	13	8/2/2026 3:34 PM	Mapped
Arrest Detail with Incident - Agency C (2026 YTD)	CRCrystal	Arrests	8	9/4/2026 10:25 PM	Mapped
Arrest Detail with Incident - Agency B (2026 YTD)	CRCrystal	Arrests	7	7/15/2026 12:45 AM	Mapped
Arrest Detail with Incident - Agency H (Last 90 Days)	CRCrystal	Arrests	6	6/11/2026 11:05 AM	Mapped
Arrest Detail with Incident - Agency J (2025)	CRCrystal	Arrests	0	Never	Mapped
Arrest Detail with Incident - Agency G (2024)	CRCrystal	Arrests	0	Never	Mapped
Arrest Detail with Incident - Agency F (2025)	CRCrystal	Arrests	0	Never	Mapped

9 of 9

Template

Target: Paginated report
Parameters: @Agency, @DateFrom, @DateTo
Security: Row-level, by agency
Replaces: 9 reports
Layout: Rebuild formatting

SELECT r.arrest_id,
       r.arrest_date,
       i.incident_id,
       i.occurred_date,
       i.beat
FROM arrest r
JOIN incident i ON i.incident_id = r.incident_id
WHERE r.agency_id = @Agency
  AND r.arrest_date BETWEEN @DateFrom AND @DateTo