Skip to content

pyvelm v0.4.0

Release date: 2026-05-22

User-defined reports with a visual builder, secure SQL compilation, and Excel/CSV/PDF export.

Highlights

Report Builder

  • Sidebar → Reports — create and edit reports on any installed model.
  • Odoo-style field drill-down — browse relations level by level; pick deep paths (e.g. company_id.currency_id.symbol).
  • Columns — drag-reorder, per-column format (number, integer, currency with record or fixed currency), alignment.
  • Order by — multi-field sort rules with priority; sort by fields not shown as columns.
  • Filters & runtime parameters — fixed filters plus prompts when running.
  • Preview in the browser; export to Excel, CSV, or PDF.
  • Scheduled runs — daily cron with attachment output and audit log.

Security: no user SQL; definitions validated and compiled with ACL, record rules, and company scope. See docs/report-builder.md.

UI components

  • pvCombo — searchable combobox (report builder, selection fields).
  • List record_href / create_href — custom row click and New button URLs.

Upgrade

Install or sync the reports module. Requires openpyxl and fpdf2 (listed in package dependencies).

pip install -U pyvelm

Then Apps → Reports → Install (or Sync if already present).