Module Pivot Reports (Cross Tables for Dolibarr)

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search


Return to developer
documentation index

File Doc dev.png

Return to user
documentation index

File Doc user.png

Informations

Module name Module Pivot Reports (Cross Tables for Dolibarr)
Editor / Editeur
Download or buy page / Page achat ou téléchargement www.dolistore.com
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.

Installation

  • Download archive file of module (.zip file) from web site www.dolistore.com 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 modulefile.zip
  • Module is ready to be activated and used.

Setup

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 an icon appears at end of the line for the module, click on it to access the setup page specific to the module.



Usage

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