Report Builder (MVP)

Reportable

Reportable now connects to MariaDB through environment variables and supports table discovery, column discovery, and one-click Excel export for selected fields.

Connection details

Uses DB_HOST, DB_PORT, DB_USER, and DB_PASSWORD; defaults to cstaffing_live (override with REPORTABLE_DB_NAME, REPORTABLE_DB_HOST, and REPORTABLE_DB_PORT when needed). If shared DB_HOST is localhost but no tunnel is active, Reportable will fall back to RDS_HOST when available.
Discovers schema with backend metadata endpoints.
Exports selected records to .xlsx using pandas + openpyxl.
Optional date filtering is supported when you choose a date/time column.

Default report: Timesheet Verification

Exports the standard Timesheet Verification report by event date range.

Default report: Employee List

Exports all employees including candidates with full details.

Default report: Scheduled and Worked Hours

Combined shift schedule and payroll hours report by event date range.

Default report: Unconfirmed Requests

Exports all employee shift requests that have not yet been confirmed by event date range.

Default report: Maps Report

Exports shift and event data including coordinates for mapping by event date range.

Default report: Global Shift Report

Detailed line item for every shift slot to compare client cancellations vs filled shifts by event date range.

FIFA - Nowsta Requests

Pulls all employees in request or confirmed status for a shift by event date range for client 1079.

Build a report

Loading tables…