Arrests by Charge - Agency E (2024)

<?xml version="1.0" encoding="utf-8"?>
<Report Name="report" FileName="report.rpt">
<Database>
<Tables>
<Table Name="Command" Alias="Command" ClassName="CrystalReports.CommandTable">
<Command>SELECT r.charge_code, r.arrest_type, COUNT(*) AS arrests FROM arrest r WHERE r.agency_id = 5 AND r.arrest_date BETWEEN '2024-01-01' AND '2024-12-31' GROUP BY r.charge_code, r.arrest_type</Command>
</Table>
</Tables>
</Database>
<DataDefinition>
<FormulaFieldDefinitions>
</FormulaFieldDefinitions>
<ParameterFieldDefinitions>
</ParameterFieldDefinitions>
</DataDefinition>
<ReportDefinition>
<Areas>
<Area Kind="Detail">
<Sections>
<Section>
<ReportObjects>
<FieldObject Name="Field0" FormulaName="{Command.charge_code}"/>
<FieldObject Name="Field1" FormulaName="{Command.arrest_type}"/>
<FieldObject Name="Field2" FormulaName="{Command.arrests}"/>
</ReportObjects>
</Section>
</Sections>
</Area>
</Areas>
</ReportDefinition>
</Report>