Migration Workbench | Workspace: CJIS environment Sample data
MFA RE
Report inventory › Field Interview Log - Agency I (Last 90 Days)
CR

Field Interview Log - Agency I (Last 90 Days)

ConsolidateCJI
SAP Crystal Reports report  ·  /Crystal/Agency I/Field Interviews/Field Interview Log - Agency I (Last 90 Days)
Agency_I/Field_Interviews/Field_Interview_Log_-_Agency_I_(Last_90_Days).rpt.xml
<?xml version="1.0" encoding="utf-8"?>
<Report Name="report" FileName="report.rpt">
<Database>
<Tables>
<Table Name="field_interview" Alias="f" ClassName="CrystalReports.Table"/>
</Tables>
<TableLinks/>
</Database>
<DataDefinition>
<FormulaFieldDefinitions>
</FormulaFieldDefinitions>
<ParameterFieldDefinitions>
</ParameterFieldDefinitions>
<RecordSelectionFormula>{field_interview.agency_id} = 9 and {field_interview.fi_date} in Date(2026,7,2) to Date(2026,9,30)</RecordSelectionFormula>
</DataDefinition>
<ReportDefinition>
<Areas>
<Area Kind="Detail">
<Sections>
<Section>
<ReportObjects>
<FieldObject Name="Field0" FormulaName="{field_interview.fi_id}"/>
<FieldObject Name="Field1" FormulaName="{field_interview.fi_date}"/>
<FieldObject Name="Field2" FormulaName="{field_interview.beat}"/>
<FieldObject Name="Field3" FormulaName="{field_interview.reason}"/>
</ReportObjects>
</Section>
</Sections>
</Area>
</Areas>
</ReportDefinition>
</Report>