Migration Workbench | Workspace: CJIS environment Sample data MFA RE

Report inventory › Burglary by Beat

RS

Burglary by Beat

ConsolidateCJI

SQL Server Reporting Services report · /Shared/Incidents/Burglary by Beat

Open family F009 Validation result

Overview Query Source definition

Definition

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

Usage (12 months)

Runs: 10
Users: 10
Last run: 7/10/2026 1:14 PM
Failures: 0

Migration

Family: F009 Burglary by Beat
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.