Turn any SQL query into a report worth sending.
A self-hosted reporting studio for the garment & manufacturing floor — drag, drop, theme, schedule, share. No add-ons. No cloud lock-in. No per-seat tax.
The daily grind
Reporting shouldn't hurt.
- Exporting to Excel, then hand-formatting the same sheet every week.
- A developer queue for every "can you add one more column?"
- Heavyweight BI suites priced per seat, per server, per quarter.
- Reports that look fine on screen and fall apart when printed.
- No clean way to share a number with a buyer outside the company.
The idea
Design it once. Theme it. Let it run itself.
Efficient BI sits on your database and turns queries into polished, branded, interactive reports — built by the people who actually need them.
3 report types
6 themes
Charts & KPIs
Public sharing
Scheduled email
Print-perfect
Report type 01
Banded reports
Grouped, sub-totalled tables — the everyday workhorse. Drag fields onto bands, set group headers and footers, drop in summary formulas.
Sales Order SummaryWINTER-27
| Style | Color | Qty | FOB |
|---|
| Buyer: ENCORE |
| Heavy Jacket | Red | 12,000 | $12.00 |
| Heavy Trouser | Black | 12,000 | $8.00 |
| Subtotal (2 rows) | 24,000 | $240k |
Report type 02
Master-detail
A parent record with its own child tables beneath — orders and their lines, shipments and their cartons. Each detail block keeps its own columns and subtotals.
Order PO-447 · NorthStar16,000 pcs
| Style | Color | Qty | FOB |
|---|
| TS-100-Top | Black | 6,000 | $4.50 |
| TS-100-Bottom | All | 5,000 | $5.20 |
| Lines subtotal | 11,000 | — |
Report type 03 · new
Pivot / cross-tab
Rows down the side, values spread across the top, multiple measures at once. Sum, average, count, min, max — with row and column totals.
| Buyer | Summer | Winter |
|---|
| Qty | Value | Qty | Value |
|---|
| H&M | 800 | $2,480 | 1,800 | $4,500 |
| Zara | 2,400 | $9,600 | 2,000 | $8,000 |
| Total | 3,200 | $12,080 | 4,900 | $15,150 |
Beyond the login
Share a report with anyone
Flip one switch and a report gets a public link — no sign-in, no branding, nothing else exposed. Embed it in an intranet page, or let a buyer subscribe themselves to a scheduled email of just their numbers.
🔗Public link & embed
Token-based URL or an <iframe> snippet. SQL and credentials never leave the server.
🔒Scoped & safe
Viewers see only their own schedules; public users only the one report shared with them.
Set it and forget it
Scheduled, printed, exported
📧Email on a schedule
Daily, weekly or monthly delivery with HTML + CSV/Excel attachments, via your SMTP.
🖨️Print-perfect
Page numbers in any corner, clean page breaks, no stray browser headers.
📊CSV & Excel
One click from the runner or the public view — every report type.
🎨Six themes + your logo
Custom band colours, footer terms & conditions, your brand on top.
Why IT will say yes
Lightweight by design
Pure PHP + PDO
Runs on PHP 7.0–8.3. No Composer, no framework, no build step.
Any SQL database
MySQL/MariaDB, PostgreSQL, SQL Server, SQLite, Oracle.
Self-hosted
Your server, your data. Drop the folder in and go.
Injection-safe
SELECT-only, fully parameter-bound. No eval, no macros.
// the whole stack
db.php → api.php → engine.php → index.php
// drop in, point at a database, done.
Built for the floor
Made for RMG & manufacturing
Production planning, line capacity, order costing, shipment tracking, materials & SCM — the reports a garment ERP actually needs, speaking your language: BU/SBU, SMV, SAH, CM, FOB, PCD.
Planners
Merchandisers
Costing teams
Management
Efficient BI
From raw query to a report worth sending — in minutes, on your own terms.
Let's build your first report →