Burglary by Beat. Generated by Migration Workbench from family F001; replaces 4 source reports. /Data Sources/RJDW RJDW=Parameters!Agency.Value=Parameters!DateFrom.Value=Parameters!DateTo.Value SELECT i.beat, CONVERT(char(7), i.occurred_date, 126) AS month, COUNT(*) AS incidents FROM incident i WHERE i.offense_code = '220' AND i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo GROUP BY i.beat, CONVERT(char(7), i.occurred_date, 126)beatmonthincidents RJDWSELECT a.agency_id, a.agency_name FROM dbo.agency a JOIN sec.user_agency u ON u.agency_id = a.agency_id WHERE u.user_name = SUSER_SNAME() ORDER BY a.agency_nameagency_idagency_name truetrueBurglary by Beat0in0in0.38in7.50in truetrue=Lookup(Parameters!Agency.Value, Fields!agency_id.Value, Fields!agency_name.Value, "Agencies") & " | " & Format(Parameters!DateFrom.Value, "MM/dd/yyyy") & " to " & Format(Parameters!DateTo.Value, "MM/dd/yyyy")0.38in0in0.24in7.50in 0.7in0.8in1.1in 0.28intruetrueBeattruetrueMonthtruetrueIncidents 0.22intruetrue=Fields!beat.Value0.5ptMiddle4pt4pt2pt2pttruetrue=Fields!month.Value0.5ptMiddle4pt4pt2pt2pttruetrue=Fields!incidents.Value0.5ptMiddle4pt4pt2pt2pt Aftertrue Main0.75in0in0.5in2.60in truetrue=Format(CountRows("Main"), "N0") & " records"1.33in0in0.22in3.00in 1.6in7.50in 0.3intruetrue truetrueCJI: authorized users only0in0in0.22in3.00in 0.3intruetrue truetrue="Page " & Globals!PageNumber & " of " & Globals!TotalPages & " | Run " & Format(Globals!ExecutionTime, "MM/dd/yyyy h:mm tt")0.05in0in0.22in7.50in 11in8.5in0.5in0.5in0.4in0.4in IntegerAgencyAgenciesagency_idagency_nameDateTimeDate fromDateTimeDate to Inch