Burglary by Beat

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="RJDW">
<DataSourceReference>/Data Sources/RJDW</DataSourceReference>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="DataSet1">
<Query>
<DataSourceName>RJDW</DataSourceName>
<QueryParameters>
<QueryParameter Name="@Agency">
<Value>=Parameters!Agency.Value</Value>
</QueryParameter>
<QueryParameter Name="@DateFrom">
<Value>=Parameters!DateFrom.Value</Value>
</QueryParameter>
<QueryParameter Name="@DateTo">
<Value>=Parameters!DateTo.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>SELECT i.beat, substr(i.occurred_date,1,7) 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, substr(i.occurred_date,1,7)</CommandText>
</Query>
<Fields>
<Field Name="beat">
<DataField>beat</DataField>
</Field>
<Field Name="month">
<DataField>month</DataField>
</Field>
<Field Name="incidents">
<DataField>incidents</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<ReportSections>
<ReportSection>
<Body>
<ReportItems>
<Tablix Name="Tablix1">
<TablixBody>
<TablixRows>
<TablixRow>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="tb_beat">
<Value>=Fields!beat.Value</Value>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="tb_month">
<Value>=Fields!month.Value</Value>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="tb_incidents">
<Value>=Fields!incidents.Value</Value>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember>
<Group Name="ColGroup">
<GroupExpressions>
<GroupExpression>=Fields!month.Value</GroupExpression>
</GroupExpressions>
</Group>
</TablixMember>
</TablixMembers>
</TablixColumnHierarchy>
<DataSetName>DataSet1</DataSetName>
</Tablix>
</ReportItems>
<Height>2in</Height>
</Body>
<Width>8in</Width>
<Page/>
</ReportSection>
</ReportSections>
<ReportParameters>
<ReportParameter Name="Agency">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>3</Value>
</Values>
</DefaultValue>
<Prompt>Agency</Prompt>
</ReportParameter>
<ReportParameter Name="DateFrom">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>2025-01-01</Value>
</Values>
</DefaultValue>
<Prompt>DateFrom</Prompt>
</ReportParameter>
<ReportParameter Name="DateTo">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>2025-12-31</Value>
</Values>
</DefaultValue>
<Prompt>DateTo</Prompt>
</ReportParameter>
</ReportParameters>
</Report>