Migration Workbench | Workspace: CJIS environment Sample data
MFA RE

Assessment summary

Sheriff Records Reporting  ·  2 sources: SSRS 2016 (Records), Crystal Reports 2016 (Jail and Records)  ·  Target: Power BI
Rerun assessmentExport matrix Add sourceRefresh
Reports scanned
134
2 sources
Migrate
20
Report families
Consolidated
70
6 across platforms
Retire
44
No runs in 12 months
Validated
90
of 90 match
Mismatches
0
Review
Report runs
01803605407209002025-10: 847Oct 252025-11: 824Nov 252025-12: 864Dec 252026-01: 875Jan 262026-02: 798Feb 262026-03: 863Mar 262026-04: 810Apr 262026-05: 847May 262026-06: 841Jun 262026-07: 848Jul 262026-08: 846Aug 262026-09: 809Sep 26
Sources
RSSSRS 2016 (Records)80
CRCrystal Reports 2016 (Jail and Records)54
Complexity
Simple14
Medium5
Complex1
Target
Paginated report19
Power BI report1
Top report families
FamilyIDSourcesReportsRuns (12 mo)ComplexityTargetWave
Arrests by ChargeF001CR RS 153,114SimplePaginated reportWave 1
Property Loss ReportF002CR RS 131,120MediumPaginated reportWave 2
Incident ListingF003CR RS 151,067SimplePaginated reportWave 2
Drug and Weapon ViolationsF004CR 91,061SimplePaginated reportWave 2
Clearance Rate by OffenseF005RS 8937SimplePaginated reportWave 2
Monthly Crime TrendF006RS 4767MediumPower BI reportWave 2
Field Interview LogF007CR RS 9531SimplePaginated reportWave 2
Open Case AgingF008CR RS 9495MediumPaginated reportWave 2
Burglary by BeatF009RS 9431MediumPaginated reportWave 2
Records Request 205F010RS 1179SimplePaginated reportWave 3