Report inventory › Analysis 27
OA
Analysis 27
Migrateshared/Justice/Analyses/Analysis 27.xml
<?xml version="1.0" encoding="utf-8"?> <saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlVersion="201201160"> <saw:criteria xsi:type="saw:simpleCriteria" subjectArea=""Justice Reporting""> <saw:columns> <saw:column columnID="c0"> <saw:columnFormula> <sawx:expr xsi:type="sawx:sqlExpression">"Incident"."Occurred Date"</sawx:expr> </saw:columnFormula> </saw:column> <saw:column columnID="c1"> <saw:columnFormula> <sawx:expr xsi:type="sawx:sqlExpression">"Incident"."Incident ID"</sawx:expr> </saw:columnFormula> </saw:column> <saw:column columnID="c2"> <saw:columnFormula> <sawx:expr xsi:type="sawx:sqlExpression">"Offense"."Offense Description"</sawx:expr> </saw:columnFormula> </saw:column> <saw:column columnID="c3"> <saw:columnFormula> <sawx:expr xsi:type="sawx:sqlExpression">"Incident"."Disposition"</sawx:expr> </saw:columnFormula> </saw:column> <saw:column columnID="c4"> <saw:columnFormula> <sawx:expr xsi:type="sawx:sqlExpression">"Incident"."Beat"</sawx:expr> </saw:columnFormula> </saw:column> </saw:columns> <saw:filter> <sawx:expr xsi:type="sawx:comparison" op="equal"> <sawx:expr xsi:type="sawx:sqlExpression">"Agency"."Agency Name"</sawx:expr> <sawx:expr xsi:type="sawx:presentationVariable" name="pAgency" promptedName="Agency"/> </sawx:expr> </saw:filter> </saw:criteria> <saw:views> <saw:view xsi:type="saw:pivotTableView" name="view0"/> </saw:views> <saw:conditionalFormat/> </saw:report>