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

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Tag: 2017 source edit
Line 18: Line 18:
 
<br />
 
<br />
  
== Main screen ==
+
==Main screen==
 +
[[File:Pivot Reports - Main-view-annotated.png|alt=Pivot Reports - Main view with legend|thumb|502x502px|Pivot Reports - Main view with legend]]
 
The main screen of the Pivot Reports module allows you to manage Pivot reports, so you can:
 
The main screen of the Pivot Reports module allows you to manage Pivot reports, so you can:
  
* Select a data source (eg Customer Orders)
+
*Select a data source (eg Customer Orders)
* View reports already defined for this data source
+
*View reports already defined for this data source
* Create new reports associated with this data source
+
*Create new reports associated with this data source
* Edit a report
+
*Edit a report
* Delete a report
+
*Delete a report
* Rename a report
+
*Rename a report
* Filter report data
+
*Filter report data
 +
 
 +
 
 +
<small>Documentation: [https://doc.progsi.ma/en/pivotreports Doc Pivot Reports]</small>
 +
 
 +
<small>Demo site: [https://pivot.progsi.ma/ Pivot Reports demo]</small>
 +
 
 +
<small>DoliStore card : [https://www.dolistore.com/en/modules/1132-Pivot-Reports--Cross-tables-for-Dolibarr-.html Pivot Reports]</small>

Revision as of 20:05, 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

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