Migration Workbench | Workspace: Sample data
RE
Convert › F008

Arrest Detail with Incident

Wave 2
5 reports  ·  640 runs (12 mo)  ·  Complex  ·  Target: Paginated report
Download RDLView outputRefresh
Member reportsTemplatePower BI outputValidation (5)
NameSourceFolderRunsLast runMapping
Arrest Detail with Incident - Agency J (2024)WIWeb Intelligence Arrests6029/29/2026 8:39 PMMapped
Arrest Detail with Incident - Agency C (2024)WIWeb Intelligence Arrests169/26/2026 8:46 PMMapped
Arrest Detail with Incident - Agency L (2025)WIWeb Intelligence Arrests99/15/2026 6:16 PMMapped
Arrest Detail with Incident - Agency H (Last 90 Days)WIWeb Intelligence Arrests74/9/2026 6:44 AMMapped
Arrest Detail with Incident - Agency A (2026 YTD)WIWeb Intelligence Arrests69/10/2026 9:04 PMMapped
5 of 5
Template
Target
Paginated report
Parameters
@Agency, @DateFrom, @DateTo
Security
Row-level, by agency
Replaces
5 reports
Layout
Rebuild formatting
SELECT r.arrest_id,
       r.arrest_date,
       i.incident_id,
       i.occurred_date,
       i.beat
FROM arrest r
JOIN incident i ON i.incident_id = r.incident_id
WHERE r.agency_id = @Agency
  AND r.arrest_date BETWEEN @DateFrom AND @DateTo