Report inventory › Drug and Weapon Violations - Agency H (2026 YTD)
CR
Drug and Weapon Violations - Agency H (2026 YTD)
ConsolidateCJIDefinition
- Source
- Crystal Reports 2016 (Jail and Records)
- Object
- Report
- Owner
- Shared
- Data access
- SQL query
- Layout
- List
- Parameters
- None
- Tables
- incident
- Columns
- i.agency_id, i.beat, i.incident_id, i.occurred_date, i.offense_code
- Complexity
- Simple
- Formatting
- Standard
Usage (12 months)
- Runs
- 353
- Users
- 134
- Last run
- 9/30/2026 11:25 PM
- Failures
- 12
Migration
- Family
- F004 Drug and Weapon Violations
- Target
- Paginated report
- Wave
- Wave 2
- Validation
- Match
Connector notes
- Record selection formula translated to SQL: {incident.offense_code} in ["35A","520"] and {incident.agency_id} = 8 and {incident.occurred_date} in Date(2026,1,1) to Date(2026,9,30)