Arrest Detail with Incident - Agency D (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.arrest_id, r.arrest_date, i.incident_id, i.occurred_date, i.beat FROM arrest r JOIN incident i ON i.incident_id = r.incident_id WHERE r.agency_id = 4 AND r.arrest_date BETWEEN '2024-01-01' AND '2024-12-31'</Command>
</Table>
</Tables>
</Database>
<DataDefinition>
<FormulaFieldDefinitions>
<FormulaFieldDefinition Name="hl0" Text="if isnull({Command.beat}) then crRed else crBlack"/>
<FormulaFieldDefinition Name="hl1" Text="if isnull({Command.beat}) then crRed else crBlack"/>
<FormulaFieldDefinition Name="hl2" Text="if isnull({Command.beat}) then crRed else crBlack"/>
</FormulaFieldDefinitions>
<ParameterFieldDefinitions>
</ParameterFieldDefinitions>
</DataDefinition>
<ReportDefinition>
<Areas>
<Area Kind="Detail">
<Sections>
<Section>
<ReportObjects>
<FieldObject Name="Field0" FormulaName="{Command.arrest_id}"/>
<FieldObject Name="Field1" FormulaName="{Command.arrest_date}"/>
<FieldObject Name="Field2" FormulaName="{Command.incident_id}"/>
<FieldObject Name="Field3" FormulaName="{Command.occurred_date}"/>
<FieldObject Name="Field4" FormulaName="{Command.beat}"/>
</ReportObjects>
</Section>
</Sections>
</Area>
</Areas>
</ReportDefinition>
<Subreports>
<Subreport Name="Arrest detail"/>
</Subreports>
</Report>