Advance Report Studio — Custom Report Builder, Pivot, Graph, Kanban & Drill-Down Reports for Odoo
by WebbyCrown Solutions https://www.webbycrown.com$ 174.72
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 7718 |
| Technical Name |
advance_report_studio |
| License | LGPL-3 |
| Website | https://www.webbycrown.com |
| Versions | 14.0 15.0 16.0 17.0 18.0 19.0 |
+91 (942) 867-7503
Advance Report Studio
Saved report templates on any allowed model — list, pivot, graph, kanban, CSV / Excel / PDF exports, optional scheduled and test email, JSON import/export, and cross-model drills.
Hero image: swap main_screenshot.png for your own capture of this module in use.
Advance Report Studio — Overview
Define domains (safe eval, rolling dates via datetime / dateutil), view modes, pivot and graph group-bys, export columns, and drills — then open templates like normal window actions.
Reporting toolkit for consultants
Advance Report Studio persists definitions under the advance.report.* namespace (separate from core report.*). Whitelist models in configuration, ship presets and optional [Studio demo] catalog entries when companion apps are installed, use xlsxwriter for Excel export, standard QWeb / wkhtmltopdf for PDF tabular export, and the mail app for outbound report delivery.
Core capabilities
Templates on ir.model with domain widget |
JSON action context & import/export |
| Pivot / graph / kanban group-bys (stored fields) | CSV, XLSX & PDF export with row cap |
Drills to related models with {field} placeholders |
PDF export (tabular) + compact paper format |
| Email: send now, test mail, daily / weekly / monthly schedule | Depends: base, base_setup, mail — Odoo 14–19 |
Technical highlights
- Safe-eval domains
- External Python:
xlsxwriter - PDF via QWeb + wkhtmltopdf (server)
- Scheduled job for automatic report emails
- Post-install hook for demo data
- Security: dedicated access rules
Key benefits
- Reusable definitions: One template, many users — consistent domains and layouts.
- Advanced views: Pivot, graph, and kanban with explicit group-bys and measures.
- Portable: JSON import/export for staging and backups.
- Drills: Jump from a row to another model using templated domains.
- Controlled scope: Optional model whitelist in configuration.
- Share results: Download PDF with branded header and meta strip, or email exports (PDF, Excel, or CSV) — including automatic sends on a schedule and a one-click test message to yourself.
Screenshots
Templates & configuration
Pivot / list runtime
Drills & related data
Configuration & behaviour
Report templates
Each template selects a model, domain, allowed view modes, optional JSON context, export column lines, and optional drill definitions. Managers use import/export JSON for bulk moves between databases.
- Domain — Evaluated safely; supports rolling windows with standard libraries.
- Exports — CSV, XLSX, and PDF use the same dataset, columns, domain, and row cap. PDF uses a dedicated report layout (company header, title band, model / record count, table).
- Email report — Choose attachment format; add recipients and optional subject/body. Use Send test email to deliver only to your user, Send by email for full recipient lists, or enable Automatic email (daily / weekly / monthly) via the module’s scheduled action.
- Drills — Target model and domain template with field placeholders from the active row.
FAQs
What is Advance Report Studio?
An Odoo application module (maintained for several recent versions) that stores reusable “report template” definitions (domain, views, pivot/graph settings, CSV/XLSX/PDF exports, optional email delivery, drills) and opens them like standard window actions.
How do PDF export and email work?
PDF uses the same rows and columns as CSV/Excel, rendered through a QWeb report; your server should have a supported wkhtmltopdf stack like other Odoo PDF reports. Outgoing mail uses the standard mail dependency: configure company mail / SMTP as usual. A compact paperformat avoids excess top margin on the first page.
Which Python packages are required?
The manifest declares xlsxwriter as an external dependency for Excel export. The mail module is required for report delivery by email. Install dependencies on the Odoo server and configure outgoing mail.
How do drills work?
You define a target model and a domain string that can include {field_name} tokens. At runtime, values are taken from the selected row to build the child action’s domain.
Where is persisted data stored?
Models use the advance.report.* prefix so they do not collide with Odoo core report.* models. See security CSV and XML in the module for access groups.
Explore Our Other Addons
Advance Export Pro
Advanced export with API integration, field mapping, scheduled exports, and batch processing.
View Addon
Advanced Import Pro
Multi-format import with API integration, mapping, scheduled imports, and batch processing.
View AddonContact & Support
Have a question?
Sales: +91 (942) 867-7503
Please log in to comment on this module