Migration Workbench | Workspace: CJIS environment Sample data MFA RE

Report inventory › Clearance Rate by Offense

RS

Clearance Rate by Offense

ConsolidateCJI

SQL Server Reporting Services report · /Shared/NIBRS/Clearance Rate by Offense

Open family F005 Validation result

Overview Query Source definition

Definition

Source: SSRS 2016 (Records)
Object: Report
Owner: Shared
Data access: SQL query
Layout: List
Parameters: Agency, DateFrom, DateTo
Tables: incident
Columns: i.agency_id, i.cleared, i.occurred_date, i.offense_code
Complexity: Simple
Formatting: Standard

Usage (12 months)

Runs: 8
Users: 8
Last run: 9/14/2026 6:18 AM
Failures: 1

Migration

Family: F005 Clearance Rate by Offense
Target: Paginated report
Wave: Wave 2
Validation: Match

Connector notes

Dataset query read from the RDL.
Report parameters bound to their default values for validation: Agency=3, DateFrom=2025-01-01, DateTo=2025-12-31.