Module Pivot Reports (Cross Tables for Dolibarr)
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 because upload from this page has been locked by your web hosting provider, 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 then check that the directory with the nameof the module is inside the /custom directory. If into a subdirectory, just move it into /custom.
- Module should be 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 a cog icon appears 
on module thumb or at end of the line of the module, click on it to access the setup page specific to the module.
Usage
Main screen
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