Open Case Aging - Agency G (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>
<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>
<RecordSelectionFormula>{incident.disposition} = "Open" and {incident.agency_id} = 7 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.reported_date}"/>
<FieldObject Name="Field2" FormulaName="{incident.offense_code}"/>
<FieldObject Name="Field3" FormulaName="{incident.disposition}"/>
</ReportObjects>
</Section>
</Sections>
</Area>
</Areas>
</ReportDefinition>
<Subreports>
<Subreport Name="Arrest detail"/>
</Subreports>
</Report>