Migration Workbench | Workspace: CJIS environment Sample data
MFA RE
Report inventory › Incident Listing
RS

Incident Listing

ConsolidateCJI
SQL Server Reporting Services report  ·  /Shared/Incidents/Incident Listing
Definition
Source
SSRS 2016 (Records)
Object
Report
Owner
Shared
Data access
SQL query
Layout
List
Parameters
Agency, DateFrom, DateTo
Tables
incident, offense_code
Columns
i.agency_id, i.beat, i.disposition, i.incident_id, i.occurred_date, i.offense_code, o.offense_code, o.offense_desc
Complexity
Simple
Formatting
Standard
Usage (12 months)
Runs
8
Users
8
Last run
6/20/2026 9:18 AM
Failures
0
Migration
Family
F003 Incident Listing
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.