Module Pivot Reports (Cross Tables for Dolibarr)

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search


Module name Module Pivot Reports (Cross Tables for Dolibarr)
Editor / Editeur
Download or buy page / Page achat ou téléchargement
Status / Statut / Estado Stable
Prerequisites / Prérequis
Last update date / Date mise à jour fiche / Fecha última actualización 2019-08-16
Note / Nota

The Pivot Reports module for Dolibarr allows you to define Data Sources (SQL SELECT queries) and to create Pivot reports by simply dragging and dropping the fields of the selected data source.

It provides as standard 17 predefined data sources and 40+ pre-defined reports covering almost all Dolibarr business objects (Quote, Orders, ...)

It gives you the ability to add as many data sources and reports as you want in a funny way.

You have the choice of 18 possible representations (tabular and graphical), 20+ possible calculation operations (Sum, Average, Median, Variance, ...), export of the calculated data in the TSV format, export graphics in image format.


  • Download archive file of module (.zip file) from web site or from any other source.
  • Install module into the custom folder of Dolibarr:
    • Go to Home - Setup - Modules - Deploy/install external app/module
    • Upload the file. Note: If it fails, you can manually unzip the file into the custom directory from command line: Go into the *custom* directory and uncompress file with command unzip
  • Module is ready to be activated and used.


To use this module, you must first enable it using an administrator account, via the menu option "Home - Setup - Modules".

Choose the tab where the module is listed. Then click on "Activate".

The module is now activated.

If a cog icon appears Cog circle.svg on module thumb or at end of the line of the module, click on it to access the setup page specific to the module.


Main screen

Pivot Reports - Main view with legend
Pivot Reports - Main view with legend

The main screen of the Pivot Reports module allows you to manage Pivot reports, so you can:

  • Select a data source (eg Customer Orders)
  • View reports already defined for this data source
  • Create new reports associated with this data source
  • Edit a report
  • Delete a report
  • Rename a report
  • Filter report data

Documentation: Doc Pivot Reports

Demo site: Pivot Reports demo

DoliStore card : Pivot Reports