Difference between revisions of "Module Pivot Reports (Cross Tables for Dolibarr)"
m Tag: 2017 source edit |
m Tag: 2017 source edit |
||
| Line 2: | Line 2: | ||
<!-- You can edit this section but do NOT remove these comments | <!-- You can edit this section but do NOT remove these comments | ||
Links below will be automatically replicated on translated pages by PolyglotBot --> | Links below will be automatically replicated on translated pages by PolyglotBot --> | ||
| − | [[fr: | + | [[fr:Module Pivot Reports (Tableaux croisés dynamiques pour Dolibarr)]] |
<!-- END interlang links --> | <!-- END interlang links --> | ||
Latest revision as of 16:45, 16 August 2019
Informations
| Module name | Module Pivot Reports (Cross Tables for Dolibarr) |
| Editor / Editeur | |
| Download or buy page / Page achat ou téléchargement | External module - www.dolistore.com |
| Status / Statut / Estado | Stable |
| Prerequisites / Prérequis |
Dolibarr max version: See on Dolistore |
| 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