Drug and Weapon Violations - Agency B (2026 YTD)

<?xml version="1.0" encoding="utf-8"?>
<Report Name="report" FileName="report.rpt">
<Database>
<Tables>
<Table Name="incident" Alias="i" ClassName="CrystalReports.Table"/>
</Tables>
<TableLinks/>
</Database>
<DataDefinition>
<FormulaFieldDefinitions>
</FormulaFieldDefinitions>
<ParameterFieldDefinitions>
</ParameterFieldDefinitions>
<RecordSelectionFormula>{incident.offense_code} in ["35A","520"] and {incident.agency_id} = 2 and {incident.occurred_date} in Date(2026,1,1) to Date(2026,9,30)</RecordSelectionFormula>
</DataDefinition>
<ReportDefinition>
<Areas>
<Area Kind="Detail">
<Sections>
<Section>
<ReportObjects>
<FieldObject Name="Field0" FormulaName="{incident.incident_id}"/>
<FieldObject Name="Field1" FormulaName="{incident.occurred_date}"/>
<FieldObject Name="Field2" FormulaName="{incident.offense_code}"/>
<FieldObject Name="Field3" FormulaName="{incident.beat}"/>
</ReportObjects>
</Section>
</Sections>
</Area>
</Areas>
</ReportDefinition>
</Report>