Promozioni

  • Training Management — Gestite il vostro organismo di formazione in Dolibarr

    Training Management è l’applicazione metier integrata in Dolibarr per gli organismi di formazione professionale. Gestite catalogo, sessioni, formatori e partecipanti, producete i documenti regolamentari e monitorate commerciale e qualità, il tutto da un’interfaccia moderna pensata per il lavoro quotidiano dei team pedagogici e amministrativi.

    350,00 €  (700€)
  • INTERVENTO PLUS: Gestione Completa degli Interventi

    Il modulo “Intervento Plus” è uno strumento rivoluzionario che semplifica e ottimizza la gestione degli interventi, dalla pianificazione alla fatturazione. Pensato per team commerciali e tecnici, offre una suite completa di funzionalità per garantire un monitoraggio trasparente ed efficiente di ogni intervento.

    250,00 €  (500€)

Nuovi Prodotti

  • Spanish VAT Return for Dolibarr

    Generate the Spanish VAT self-assessment Model 303 (AEAT) directly from Dolibarr invoices: preview the form on screen, download the .303 file ready for electronic filing, and export a PDF summary.

    80,00 €
  • Ultimatepdf 24.0

    Un vero coltellino svizzero per personalizzare i vostri documenti (ordini, spedizioni, fatture con cambiali, interventi, progetti, proposte commerciali, ordini e fatture fornitori, contratti e molto altro). L’interfaccia di amministrazione del modulo consente di gestire la vostra identità visiva e di configurare un’ampia gamma di impostazioni.

    200,00 €

Pivot Reports (Cross tables for Dolibarr)

c10336d20190602132841

This module allows you to manage Pivot reports (Tables and Charts) from SQL queries. It is provided with 17 predefined SQL queries and 40+ predefined reports. You can add your own SQL queries. Then you can add your own Pivot reports (Tables and / or Charts) by simple settings (selections in lists for some parameters and Drag & Drop for others)

132,00 €
Al netto delle imposte

Previous Next
  • Autore ProgSI
  • Versione modulo 2.15
  • Rilascio data 02/06/2019
  • Accesso agli aggiornamenti e ai download Accesso a vita
  • Come contattare l'assistenza contact@progsi.ma
  • Compatibilità Dolibarr V7+
  • Ultimo aggiornamento 13/07/2026 20.07

Maggiori informazioni...

(IMPORTANT : please do the following if you are updating from an old version :

- deactivate the module

- remove the entire module directory

- upload the new version

- reactivate the module)

Publisher/Licence: ProgSI / AGPL
User interface language: English / French
Help/Support: Mail to contact@progsi.ma

Demo: https://pivot.progsi.ma

Doc: PivotReports

Prerequisites:

  • PostgreSQL not supported

Install:

  • Download the archive file of module (.zip file) from web site DoliStore.com
  • Put the file into the custom directory of Dolibarr.
  • Uncompress the zip file, for example with command
unzip module_pivotreports-auto.zip
  • Module or skin is then available and can be activated.

 

Features:

  • Provided with 17 predefined SQL queries covering the majority of Dolibarr business objects (Quote, Orders, Invoices, ...) (you can use them for your own queries)
  • Provided with 40+ predefined Pivot reports using the 17 predefined SQL queries
  • Infinitely expandable by creating your own Pivot reports (Tables and / or Charts) from your own simple SQL SELECT queries without aggregation operations, it's the module that does the calculations (no need to create complex queries and / or program to have beautiful charts)
  • Offers the choice of 10 types of Pivot tables (Simple table, Table with bars, Table with heat map, Table with subtotals, ...)
  • Offers the choice of 8 types of Pivot charts (Histogram, Camembert, Line, ...)
  • Offers the choice of 20+ calculation operations (Sum, Average, Counting, ...)
  • Choice of fields for row / column headers by drag & drop
  • Export computed data in Excel-compatible TSV format
  • Export charts in PNG image format
  • Zoom on the charts
  • In-depth analysis of your data (example: by Year / Quarter / Month)
  • Clean interface to focus on your data

 

FAQ:

Q. I do not know SQL, can I use the module?

A. Yes, the module comes with 40+ predefined reports that can be very useful to you

You can modify them or create variants for your needs without touching the underlying SQL code (see the doc).

If, despite everything, the report you need can not be created from what is provided as standard, contact us by describing what you are looking for.




If you think this module is a fork of another one (published after the first one) or violates some terms or conditions of use (for users or vendors), you can make a report at dolistore@dolibarr.org