Convert › F017
Citations by Violation
CJIWave 3| Name | Source | Folder | Runs | Last run | Mapping |
|---|---|---|---|---|---|
| Citations by Violation - Agency B (Last 90 Days) | RSSSRS | Citations | 12 | 9/28/2026 10:09 PM | Mapped |
| Citations by Violation - Agency F (2026 YTD) | RSSSRS | Citations | 10 | 8/8/2026 1:00 AM | Mapped |
| Citations by Violation - Agency J (2025) | RSSSRS | Citations | 0 | Never | Mapped |
| Citations by Violation - Agency E (2025) | RSSSRS | Citations | 0 | Never | Mapped |
| Citations by Violation - Agency A (2026 YTD) | RSSSRS | Citations | 0 | Never | Mapped |
| Citations by Violation - Agency D (2024) | RSSSRS | Citations | 0 | Never | Mapped |
| Citations by Violation - Agency C (2025) | RSSSRS | Citations | 0 | Never | Mapped |
7 of 7
Template
- Target
- Paginated report
- Parameters
- @Agency, @DateFrom, @DateTo
- Security
- Row-level, by agency
- Replaces
- 7 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)