View source for Module Pivot Reports (Cross Tables for Dolibarr)

<!-- 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]]

{{TemplateDocDevEn}}
{{TemplateDocUser}}
= Informations =
{{TemplateModuleInfo
|modulename=Module Pivot Reports (Cross Tables for Dolibarr)
|editor=
|web=
|webbuy={{LinkToPluginDownloadDoliStore|keyword=}}
|status=stable
|minversion=
|note=
}}



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 =
{{InstallModuleDoliStoreEn}}

= Setup =
{{ActivationModuleEn}}




=Usage=

==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:

*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


<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>