Drug and Weapon Violations

CJIWave 1

20 reports · 1,720 runs (12 mo) · Simple · Target: Paginated report

Member reports Template Power BI output Validation (10)

Name	Source	Folder	Runs	Last run	Mapping
Drug and Weapon Violations - Agency L (2026 YTD)	CoCognos	Incidents	822	9/30/2026 2:28 PM	Mapped
Drug and Weapon Violations - Agency L (2024)	CoCognos	Incidents	780	9/30/2026 5:42 PM	Mapped
Drug and Weapon Violations - Agency I (2026 YTD)	CoCognos	Incidents	33	9/30/2026 11:12 AM	Mapped
Drug and Weapon Violations - Agency C (2025)	CoCognos	Incidents	18	9/27/2026 12:41 AM	Mapped
Copy of Drug and Weapon Violations	CoCognos	user132	17	9/22/2026 12:42 PM	Mapped
Drug and Weapon Violations - Agency H (Last 90 Days)	CoCognos	Incidents	15	9/23/2026 6:39 AM	Mapped
Drug and Weapon Violations - Agency D (Last 90 Days)	CoCognos	Incidents	12	9/17/2026 12:00 AM	Mapped
Drug and Weapon Violations - Agency I (2024)	CoCognos	Incidents	8	8/18/2026 2:31 PM	Mapped
Drug and Weapon Violations - Agency J (2026 YTD)	CoCognos	Incidents	8	9/10/2026 4:32 PM	Mapped
Drug and Weapon Violations - Agency B (2026 YTD)	CoCognos	Incidents	7	8/29/2026 5:44 AM	Mapped
Drug and Weapon Violations - Agency D (2026 YTD)	CoCognos	Incidents	0	Never	Mapped
Copy of Drug and Weapon Violations	CoCognos	user101	0	Never	Mapped
Copy of Drug and Weapon Violations	CoCognos	user311	0	Never	Mapped
Drug and Weapon Violations - Agency L (2025)	CoCognos	Incidents	0	Never	Mapped
Drug and Weapon Violations - Agency J (2024)	CoCognos	Incidents	0	Never	Mapped
Copy of Drug and Weapon Violations	CoCognos	user482	0	Never	Mapped
Copy of Drug and Weapon Violations	CoCognos	user286	0	Never	Mapped
Drug and Weapon Violations - Agency C (Last 90 Days)	CoCognos	Incidents	0	Never	Mapped
Drug and Weapon Violations - Agency C (2026 YTD)	CoCognos	Incidents	0	Never	Mapped
Copy of Drug and Weapon Violations	CoCognos	user343	0	Never	Mapped

20 of 20

Template

Target: Paginated report
Parameters: @Agency, @DateFrom, @DateTo
Security: Row-level, by agency
Replaces: 20 reports
Layout: Standard

SELECT i.incident_id,
       i.occurred_date,
       i.offense_code,
       i.beat
FROM incident i
WHERE i.offense_code IN ('35A','520')
  AND i.agency_id = @Agency
  AND i.occurred_date BETWEEN @DateFrom AND @DateTo