Migration Workbench | Workspace: CJIS environment Sample data
MFA RE
Convert › F013

Property Loss Report

CJIWave 2
27 reports  ·  1,353 runs (12 mo)  ·  Medium  ·  Target: Paginated report
Download RDLView outputRefresh
Member reportsTemplatePower BI outputValidation (16)
NameSourceFolderRunsLast runMapping
Property Loss Report - Agency A (Last 90 Days)CoCognos Incidents1,1649/30/2026 7:17 PMMapped
Property Loss Report - Agency F (2025)CoCognos Incidents239/24/2026 10:40 AMMapped
Property Loss Report - Agency K (2024)CoCognos Incidents229/18/2026 12:55 AMMapped
Property Loss Report - Agency L (2024)CoCognos Incidents229/24/2026 2:40 AMMapped
Property Loss Report - Agency C (2026 YTD)CoCognos Incidents139/14/2026 12:48 AMMapped
Property Loss Report - Agency F (Last 90 Days)CoCognos Incidents139/25/2026 6:05 AMMapped
Copy of Property Loss ReportCoCognos user116139/21/2026 5:53 AMMapped
Copy of Property Loss ReportCoCognos user302128/9/2026 1:57 PMMapped
Property Loss Report - Agency G (2025)CoCognos Incidents109/13/2026 6:20 AMMapped
Property Loss Report - Agency J (Last 90 Days)CoCognos Incidents109/21/2026 7:05 PMMapped
Property Loss Report - Agency H (2024)CoCognos Incidents106/7/2026 3:39 PMMapped
Property Loss Report - Agency E (Last 90 Days)CoCognos Incidents105/14/2026 2:21 AMMapped
Property Loss Report - Agency K (Last 90 Days)CoCognos Incidents109/20/2026 10:13 PMMapped
Property Loss Report - Agency F (2024)CoCognos Incidents89/5/2026 9:54 AMMapped
Property Loss Report - Agency G (Last 90 Days)CoCognos Incidents76/29/2026 8:11 PMMapped
Property Loss Report - Agency G (2024)CoCognos Incidents69/4/2026 4:09 AMMapped
Property Loss Report - Agency E (2025)CoCognos Incidents0NeverMapped
Property Loss Report - Agency I (Last 90 Days)CoCognos Incidents0NeverMapped
Property Loss Report - Agency E (2026 YTD)CoCognos Incidents0NeverMapped
Property Loss Report - Agency H (2026 YTD)CoCognos Incidents0NeverMapped
Property Loss Report - Agency J (2025)CoCognos Incidents0NeverMapped
Property Loss Report - Agency B (2025)CoCognos Incidents0NeverMapped
Property Loss Report - Agency H (2025)CoCognos Incidents0NeverMapped
Copy of Property Loss ReportCoCognos user1260NeverMapped
Copy of Property Loss ReportCoCognos user3030NeverMapped
Property Loss Report - Agency D (2026 YTD)CoCognos Incidents0NeverMapped
Property Loss Report - Agency L (2026 YTD)CoCognos Incidents0NeverMapped
27 of 27
Template
Target
Paginated report
Parameters
@Agency, @DateFrom, @DateTo
Security
Row-level, by agency
Replaces
27 reports
Layout
Rebuild formatting
SELECT i.incident_id,
       i.occurred_date,
       i.offense_code,
       i.property_loss
FROM incident i
WHERE i.property_loss > 0
  AND i.agency_id = @Agency
  AND i.occurred_date BETWEEN @DateFrom AND @DateTo