Arrest Detail with Incident

CJIWave 2

18 reports · 972 runs (12 mo) · Complex · Target: Paginated report

Member reports Template Power BI output Validation (10)

Name	Source	Folder	Runs	Last run	Mapping
Arrest Detail with Incident - Agency K (2026 YTD)	CoCognos	Arrests	829	9/30/2026 4:21 PM	Mapped
Copy of Arrest Detail with Incident	CoCognos	user491	42	9/30/2026 12:38 PM	Mapped
Arrest Detail with Incident - Agency A (2024)	CoCognos	Arrests	24	8/28/2026 4:45 PM	Mapped
Arrest Detail with Incident - Agency D (Last 90 Days)	CoCognos	Arrests	20	9/17/2026 6:37 AM	Mapped
Arrest Detail with Incident - Agency B (Last 90 Days)	CoCognos	Arrests	14	9/5/2026 1:59 PM	Mapped
Arrest Detail with Incident - Agency D (2024)	CoCognos	Arrests	13	9/28/2026 5:52 AM	Mapped
Arrest Detail with Incident - Agency K (Last 90 Days)	CoCognos	Arrests	9	9/13/2026 12:25 AM	Mapped
Arrest Detail with Incident - Agency H (2026 YTD)	CoCognos	Arrests	8	9/25/2026 5:18 PM	Mapped
Copy of Arrest Detail with Incident	CoCognos	user300	7	9/8/2026 7:46 PM	Mapped
Arrest Detail with Incident - Agency E (Last 90 Days)	CoCognos	Arrests	6	7/18/2026 5:30 AM	Mapped
Arrest Detail with Incident - Agency A (2025)	CoCognos	Arrests	0	Never	Mapped
Arrest Detail with Incident - Agency A (Last 90 Days)	CoCognos	Arrests	0	Never	Mapped
Arrest Detail with Incident - Agency C (Last 90 Days)	CoCognos	Arrests	0	Never	Mapped
Arrest Detail with Incident - Agency F (2026 YTD)	CoCognos	Arrests	0	Never	Mapped
Arrest Detail with Incident - Agency B (2024)	CoCognos	Arrests	0	Never	Mapped
Arrest Detail with Incident - Agency D (2026 YTD)	CoCognos	Arrests	0	Never	Mapped
Arrest Detail with Incident - Agency F (2024)	CoCognos	Arrests	0	Never	Mapped
Arrest Detail with Incident - Agency F (2025)	CoCognos	Arrests	0	Never	Mapped

18 of 18

Template

Target: Paginated report
Parameters: @Agency, @DateFrom, @DateTo
Security: Row-level, by agency
Replaces: 18 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