Difference between revisions of "Module Pivot Reports (Cross Tables for Dolibarr)"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
(Created page with "== Presentation == 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...")
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
== Presentation ==
+
<!-- BEGIN origin interlang links -->
 +
<!-- You can edit this section but do NOT remove these comments
 +
    Links below will be automatically replicated on translated pages by PolyglotBot -->
 +
[[fr:Module_Pivot_Reports_(Tableaux_croisés_dynamiques_pour_Dolibarr)]]
 +
<!-- END interlang links -->
 +
 
 +
[[Category:Complementary modules]]
 +
 
 +
==Presentation==
 
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.
 
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.
  
Line 7: Line 15:
  
 
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.
 
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.
 +
 +
<br />
 +
 +
== 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

Revision as of 19:55, 15 August 2019


Presentation

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.


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