Migration Workbench | Workspace: CJIS environment Sample data
MFA RE
Report inventory › Juvenile Arrests - Agency L (2026 YTD)
CR

Juvenile Arrests - Agency L (2026 YTD)

RetireCJI
SAP Crystal Reports report  ·  /Crystal/Agency L/Arrests/Juvenile Arrests - Agency L (2026 YTD)
Agency_L/Arrests/Juvenile_Arrests_-_Agency_L_(2026_YTD).rpt.xml
<?xml version="1.0" encoding="utf-8"?>
<Report Name="report" FileName="report.rpt">
<Database>
<Tables>
<Table Name="arrest" Alias="r" ClassName="CrystalReports.Table"/>
</Tables>
<TableLinks/>
</Database>
<DataDefinition>
<FormulaFieldDefinitions>
</FormulaFieldDefinitions>
<ParameterFieldDefinitions>
</ParameterFieldDefinitions>
<RecordSelectionFormula>{arrest.arrestee_age} &lt; 18 and {arrest.agency_id} = 12 and {arrest.arrest_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="{arrest.arrest_id}"/>
<FieldObject Name="Field1" FormulaName="{arrest.arrest_date}"/>
<FieldObject Name="Field2" FormulaName="{arrest.charge_code}"/>
<FieldObject Name="Field3" FormulaName="{arrest.arrestee_age}"/>
</ReportObjects>
</Section>
</Sections>
</Area>
</Areas>
</ReportDefinition>
</Report>