Footprint & Deployment
- Under 1 GB server footprint — one of the lightest enterprise reporting tools available
- Modest hardware — 2 cores / 4 GB RAM minimum (8 GB+ if also running Oracle locally)
- Browser-based — no client software to install or roll out
- Identical app on Windows and Linux — same features, same license, one build
- Self-hosted — your data and queries never leave your network
- Built on modern, actively-maintained web technology (React, Node.js, TypeScript)
Oracle-Native
- Purpose-built for Oracle Database — not a generic tool retrofitted for it
- Thin-mode Oracle connectivity — no Oracle Instant Client required
- Full PL/SQL support: functions, procedures, and report lifecycle triggers
- Built-in demo dataset — evaluate the product with zero database setup
API & Integration
- API-first architecture — every feature is a documented REST call, not just a UI action
- Native Oracle APEX integration via a trusted service key, no interactive login needed
- Headless/unattended callers supported out of the box
- Full, hand-written OpenAPI 3.0 spec, always public to read
Report Design
- Drag-and-drop visual designer — no coding required for standard reports
- Ten report styles: Tabular, Group Above, Group Left, Summary Only, Master-Detail, Form, Matrix, Mailing Labels, Multi-Column, and Statement / Ledger
- Links & drill-through: any element can link to another system or report, with values from the clicked row
- Table (tablix): a real grid with a repeating header, group subtotals, and a grand-total row
- Growing bands: long wrapped text pushes a real page break instead of overlapping the next band
- Bookmarks & Table of Contents: clickable jump links in HTML, real Acrobat sidebar bookmarks in PDF
- 16 element types including Chart, Crosstab, Barcode/QR, Map, and Subreport
- 16 native chart types rendered identically across canvas, HTML, and PDF
- Crosstab (pivot-table) reporting built directly into the designer
- Guided Report Wizard — generate a starting report from a query in minutes
- AI-assisted query and expression generation from plain-English descriptions
- Multi-select editing with align/distribute tools for fast layout work
- Full, remappable keyboard shortcuts — undo/redo, copy/cut/paste, duplicate, group, layer order, Open/Preview/Save — customize any of them from Administration
- Multi-select in Open Report — bulk move or delete several reports at once, like a native file manager
Export & Delivery
- Export to PDF, Excel, Word, PowerPoint, CSV, and JSON
- Designer-fidelity exports — formatting matches what you built
- Automated report scheduling with cron timing and full run history
- Delivery via Email or FTP/SFTP, configured once for the whole deployment
- One-click "Run Now" for on-demand execution outside a schedule
Security & Governance
- Role-based access control with six built-in roles for fine-grained permission design
- Per-user permission overrides — grant or restrict individual features per person
- Automatic account lockout after repeated failed logins, with admin unlock
- Full audit trail of every meaningful action across the system
- Connection passwords encrypted at rest, never exposed to the browser
- Per-report access restriction — control exactly who can see which report
Administration
- One unified Administration console — users, plug-ins, dashboard, sessions, and inbox in a single place
- See every signed-in user and end any session with one click
- Live usage dashboard: users, reports, connections, and scheduled-job health at a glance
- Version history on every save — nothing is ever silently lost
- Personal folders and secure report sharing between users
- Built-in visitor inbox for website contact and password-reset requests — one click to create a user and email their login from a "Request Access" message, with automatic archiving of old messages and an Archive you can purge
- Email & FTP delivery settings editable from Administration, with a one-click test email — no config-file editing required
Migration & Extensibility
- Import existing Oracle Reports Builder definitions
- Import existing JasperReports (.jrxml) definitions
- Export reports back out as JasperReports XML
- Connect to databases beyond localhost, via a dedicated key
- Plug-ins licensed independently — pay only for the capabilities you need
Oracle APEX guides
- Oracle APEX reporting guide — what's built into APEX vs. what to add
- Installation & setup — standing it up next to APEX/ORDS
- PDF reports — pagination, group headers, invoices
- Excel reports — designer-fidelity XLSX, streaming for large data
- Scheduled reports — cron scheduling, retry, run history
- Emailing reports — automatic and on-demand delivery
- Invoice reporting — line items, subtotals, barcodes
- Report server architecture — footprint, deployment, API-first design
- Choosing a reporting tool — a straight buyer's comparison
See it running before you decide anything
The full designer, core report types, and export formats — no install, no signup.
Try Live Demo → Download Trial