Request 082

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://developer.cognos.com/schemas/report/16.0/" expressionLocale="en-us">
<modelPath>/content/folder[@name='Regional']/package[@name='Justice Reporting']/model[@name='model']</modelPath>
<queries>
<query name="Query1">
<source>
<sqlQuery name="SQL1" dataSource="RJDW">
<sqlText>SELECT o.offense_desc, i.cleared, i.incident_id, i.disposition, i.beat, i.reported_date FROM incident i JOIN offense_code o ON o.offense_code = i.offense_code WHERE i.offense_code IN ('240') AND i.agency_id = 2 AND i.occurred_date BETWEEN '2025-01-01' AND '2025-12-31'</sqlText>
</sqlQuery>
</source>
<detailFilters>
</detailFilters>
</query>
</queries>
<layouts>
<layout>
<reportPages>
<page name="Page1">
<pageBody>
<contents>
<crosstab refQuery="Query1"/>
<conditionalStyle name="cs0"/>
<conditionalStyle name="cs1"/>
<conditionalStyle name="cs2"/>
<conditionalStyle name="cs3"/>
<conditionalStyle name="cs4"/>
<conditionalStyle name="cs5"/>
<masterDetailLinks/>
</contents>
</pageBody>
</page>
</reportPages>
</layout>
</layouts>
</report>