Citations by Violation

Target

Paginated report

Parameters

@Agency, @DateFrom, @DateTo

Security

Row-level, by agency

Replaces

22 reports

Layout

Standard

SELECT c.violation,
       CONVERT(char(7),
       c.issued_date, 126) AS month,
       COUNT(*) AS citations,
       SUM(c.fine) AS fines
FROM citation c
WHERE c.agency_id = @Agency
  AND c.issued_date BETWEEN @DateFrom AND @DateTo
GROUP BY c.violation, CONVERT(char(7), c.issued_date, 126)