Report inventory › Property Loss Report - Agency D (Last 90 Days)
CR
Property Loss Report - Agency D (Last 90 Days)
RetireCJIDefinition
- Source
- Crystal Reports 2016 (Jail and Records)
- Object
- Report
- Owner
- Shared
- Data access
- SQL query
- Layout
- List
- Parameters
- None
- Tables
- incident
- Columns
- i.agency_id, i.incident_id, i.occurred_date, i.offense_code, i.property_loss
- Complexity
- Medium
- Formatting
- Conditional styles (3 formula fields), Subreport
Usage (12 months)
- Runs
- 0
- Users
- 0
- Last run
- Never
- Failures
- 0
Migration
- Family
- F002 Property Loss Report
- Target
- Paginated report
- Wave
- Wave 2
- Validation
- Not applicable
Connector notes
- Record selection formula translated to SQL: {incident.property_loss} > 0 and {incident.agency_id} = 4 and {incident.occurred_date} in Date(2026,7,2) to Date(2026,9,30)