Generate military-standard reports in seconds with AI assistance. 9-Line CAS, MEDEVAC, SITREP, SPOTREP, and more — with powerful DuckDB pivot table analysis for after-action review and intelligence synthesis.
The Tactical Reporting Service includes professionally designed templates for the most common military and emergency response reports. Each template follows established doctrine and can be customized for organizational requirements.
| Report Type | Use Case | Key Fields |
|---|---|---|
| 9-Line CAS | Close Air Support requests | IP/BP, Target, Egress, Ordnance |
| 9-Line MEDEVAC | Medical evacuation requests | Location, Urgency, Patient Status, Security |
| SITREP | Situation Reports | Current Status, Disposition, Logistics |
| SPOTREP | Spot Reports | Size, Activity, Location, Unit, Time, Equipment |
| INTREP | Intelligence Reports | Assessment, Sources, Reliability |
| SALUTE | Enemy Activity Reports | Size, Activity, Location, Unit, Time, Equipment |
A JTAC under time pressure needs to call in close air support. With AI assistance, they select the 9-Line CAS template and the system pre-fills known data from the current map state: their location from GPS, target position from the selected marker, and current weather from connected sensors. The report is ready in under 30 seconds.
Integrated AI accelerates report creation by extracting relevant information from available data sources. The system can pre-populate fields from map markers, sensor feeds, and previous reports, reducing manual entry and human error.
Beyond report creation, the Tactical Reporting Service provides powerful analytics through DuckDB pivot tables. Aggregate, filter, and analyze historical reports to identify patterns, trends, and insights that inform future operations.
| Pivot Template | Analysis Focus | Dimensions |
|---|---|---|
| Incident by Type | Frequency analysis | Type, Time Period, Location |
| Response Time | Performance metrics | Unit, Priority, Time to Completion |
| Geographic Distribution | Spatial patterns | AOI, Density, Cluster Analysis |
| Resource Utilization | Asset tracking | Asset Type, Duration, Availability |
| Threat Assessment | Intelligence synthesis | Threat Level, Type, Trend |
Following a multi-day operation, the operations officer uses pivot analysis to review all MEDEVAC requests. By filtering by urgency and location, they identify a cluster of injuries in a specific sector, prompting a review of patrol routes and protective measures for future missions.
Each report has a complete lifecycle from creation through archival. Status tracking ensures accountability, while version history preserves the audit trail. Reports can be exported in multiple formats for integration with external systems.
Reports can be exported in formats suitable for different dissemination channels. Structured formats enable system integration, while human-readable formats support briefing and documentation needs.
The reporting service is built on DuckDB for high-performance local analytics. Reports are stored in SQLite for reliable persistence. The service runs entirely on-device with no external dependencies, ensuring functionality in disconnected environments.