Convert › F003
Incident Listing
CJIWave 2| Name | Source | Folder | Runs | Last run | Mapping |
|---|---|---|---|---|---|
| Incident Listing - Agency H (2026 YTD) | RSSSRS | Incidents | 762 | 9/30/2026 9:23 AM | Mapped |
| Incident Listing - Agency L (Last 90 Days) | CRCrystal | Incidents | 135 | 9/30/2026 4:46 PM | Mapped |
| Incident Listing - Agency B (2026 YTD) | RSSSRS | Incidents | 43 | 9/28/2026 5:48 PM | Mapped |
| Incident Listing - Agency J (Last 90 Days) | CRCrystal | Incidents | 31 | 9/23/2026 6:43 AM | Mapped |
| Incident Listing - Agency I (2024) | RSSSRS | Incidents | 29 | 9/28/2026 8:36 PM | Mapped |
| Incident Listing - Agency D (Last 90 Days) | RSSSRS | Incidents | 16 | 9/10/2026 9:53 PM | Mapped |
| Incident Listing - Agency K (2025) | RSSSRS | Incidents | 11 | 9/12/2026 2:30 PM | Mapped |
| Incident Listing | RSSSRS | Incidents | 8 | 6/20/2026 9:18 AM | Mapped |
| Incident Listing - Agency G (2025) | CRCrystal | Incidents | 7 | 9/23/2026 8:24 PM | Mapped |
| Incident Listing - Agency H (Last 90 Days) | CRCrystal | Incidents | 7 | 7/21/2026 2:31 AM | Mapped |
| Incident Listing - Agency L (2024) | RSSSRS | Incidents | 6 | 9/11/2026 6:34 PM | Mapped |
| Incident Listing - Agency B (Last 90 Days) | CRCrystal | Incidents | 6 | 8/9/2026 8:19 PM | Mapped |
| Incident Listing - Agency E (Last 90 Days) | CRCrystal | Incidents | 6 | 9/29/2026 6:19 PM | Mapped |
| Incident Listing - Agency E (2025) | RSSSRS | Incidents | 0 | Never | Mapped |
| Incident Listing - Agency A (2024) | CRCrystal | Incidents | 0 | Never | Mapped |
15 of 15
Template
- Target
- Paginated report
- Parameters
- @Agency, @DateFrom, @DateTo
- Security
- Row-level, by agency
- Replaces
- 15 reports
- Layout
- Standard
SELECT i.incident_id, i.occurred_date, o.offense_desc, i.beat, i.disposition FROM incident i JOIN offense_code o ON o.offense_code = i.offense_code WHERE i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo ORDER BY i.occurred_date