Property Loss Report - Agency B (2025)

<?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>
</QueryParameters>
<CommandText>SELECT i.incident_id, i.occurred_date, i.offense_code, i.property_loss FROM incident i WHERE i.property_loss &gt; 0 AND i.agency_id = 2 AND i.occurred_date BETWEEN '2025-01-01' AND '2025-12-31'</CommandText>
</Query>
<Fields>
<Field Name="incident_id">
<DataField>incident_id</DataField>
</Field>
<Field Name="occurred_date">
<DataField>occurred_date</DataField>
</Field>
<Field Name="offense_code">
<DataField>offense_code</DataField>
</Field>
<Field Name="property_loss">
<DataField>property_loss</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<ReportSections>
<ReportSection>
<Body>
<ReportItems>
<Tablix Name="Tablix1">
<TablixBody>
<TablixRows>
<TablixRow>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="tb_incident_id">
<Value>=Fields!incident_id.Value</Value>
<Style>
<BackgroundColor>=IIF(Fields!incident_id.Value Is Nothing, "LightCoral", "White")</BackgroundColor>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="tb_occurred_date">
<Value>=Fields!occurred_date.Value</Value>
<Style>
<BackgroundColor>=IIF(Fields!occurred_date.Value Is Nothing, "LightCoral", "White")</BackgroundColor>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="tb_offense_code">
<Value>=Fields!offense_code.Value</Value>
<Style>
<BackgroundColor>=IIF(Fields!offense_code.Value Is Nothing, "LightCoral", "White")</BackgroundColor>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="tb_property_loss">
<Value>=Fields!property_loss.Value</Value>
<Style>
<BackgroundColor>=IIF(Fields!property_loss.Value Is Nothing, "LightCoral", "White")</BackgroundColor>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember/>
</TablixMembers>
</TablixColumnHierarchy>
<DataSetName>DataSet1</DataSetName>
</Tablix>
<Subreport Name="Detail">
<ReportName>Incident Detail</ReportName>
</Subreport>
</ReportItems>
<Height>2in</Height>
</Body>
<Width>8in</Width>
<Page/>
</ReportSection>
</ReportSections>
<ReportParameters>
</ReportParameters>
</Report>