Migration Workbench | Workspace: CJIS environment Sample data
MFA RE
Convert › F006

Arrests by Charge

CJIWave 1
18 reports  ·  2,584 runs (12 mo)  ·  Simple  ·  Target: Paginated report
Download RDLView outputRefresh
Member reportsTemplatePower BI outputValidation (12)
NameSourceFolderRunsLast runMapping
Arrests by Charge - Agency B (2024)CoCognos Arrests1,0639/30/2026 12:26 PMMapped
Arrests by Charge - Agency F (2024)CoCognos Arrests5779/30/2026 1:28 PMMapped
Arrests by Charge - Agency H (Last 90 Days)CoCognos Arrests5299/30/2026 8:23 AMMapped
Arrests by Charge - Agency J (2026 YTD)CoCognos Arrests3349/29/2026 8:41 AMMapped
Arrests by Charge - Agency H (2025)CoCognos Arrests209/25/2026 6:56 PMMapped
Arrests by Charge - Agency C (2025)CoCognos Arrests169/26/2026 3:03 AMMapped
Arrests by Charge - Agency G (Last 90 Days)CoCognos Arrests98/25/2026 11:25 AMMapped
Copy of Arrests by ChargeCoCognos user55796/3/2026 9:49 PMMapped
Arrests by Charge - Agency K (2024)CoCognos Arrests87/18/2026 7:49 AMMapped
Arrests by Charge - Agency G (2026 YTD)CoCognos Arrests79/25/2026 9:53 PMMapped
Arrests by Charge - Agency C (Last 90 Days)CoCognos Arrests69/5/2026 7:41 PMMapped
Arrests by Charge - Agency K (2026 YTD)CoCognos Arrests62/9/2026 11:35 AMMapped
Arrests by Charge - Agency H (2024)CoCognos Arrests0NeverMapped
Copy of Arrests by ChargeCoCognos user2480NeverMapped
Arrests by Charge - Agency E (Last 90 Days)CoCognos Arrests0NeverMapped
Arrests by Charge - Agency G (2025)CoCognos Arrests0NeverMapped
Arrests by Charge - Agency K (2025)CoCognos Arrests0NeverMapped
Arrests by Charge - Agency E (2024)CoCognos Arrests0NeverMapped
18 of 18
Template
Target
Paginated report
Parameters
@Agency, @DateFrom, @DateTo
Security
Row-level, by agency
Replaces
18 reports
Layout
Standard
SELECT r.charge_code,
       r.arrest_type,
       COUNT(*) AS arrests
FROM arrest r
WHERE r.agency_id = @Agency
  AND r.arrest_date BETWEEN @DateFrom AND @DateTo
GROUP BY r.charge_code, r.arrest_type