MODULES / FINANCE

Excel Report Designer

Save personal Excel column layouts for registered ASKERP reports.

Overview

Module idask_excel_report_designer
Version1.0.0
Who uses itAnyone who uses the screens listed below.
InstalledOn demand, from Settings → Modules. Anything it needs is installed with it.

Where to find it

Reports / ToolsExcel report designer

The menu entries appear once the module is installed and your role allows them.

How it links to other modules

A module that is needed cannot be turned off while the module that needs it is on.

Details

Excel Report Designer

Optional adaptation of D:/Odoo18/sparkosol/addons.odoo18/excel_report_designer. Install Excel Report Designer in Settings → Modules. Open any permitted report and choose Design Excel, or use Reports → Excel report designer.

Choose columns and their order from the selected ASKERP report, then save a private layout for your own account. XLSX output uses that report's current filters, rows, money precision and source data. Layouts are company and user isolated. Owners can update or remove their layouts; disabling the addon hides and refuses designer and custom export actions while preserving layouts for reinstall.

Only columns declared by the registered report are accepted. Export checks the full source report's control rows before omitting columns, so hiding a check column cannot bypass a mismatch block. Custom exports use the usual report permissions, module gates and report-export audit event.

This is intentionally not an arbitrary model/field query builder. The Odoo source can select arbitrary ORM models and includes executable server-action choices; ASKERP exposes neither capability. It also does not add formulas, SQL filters, shared/public layouts or PDF layout editing. No accounting or source documents are changed.

Migrations 0107_excel_report_layouts.sql and 0108_excel_layout_user_rls.sql store ordered column keys under company RLS and an authenticated-user policy. Validation: npx vitest run addons/ask_excel_report_designer lib/modules.test.ts lib/nav.test.ts server/reports/registry.test.ts.

Excel Report Designer | ASKERP Docs