Promociones

  • INTERVENCIÓN PLUS: Gestión Completa de Intervenciones

    El módulo “Intervención Plus” es una herramienta revolucionaria que simplifica y optimiza la gestión de las intervenciones, desde la planificación hasta la facturación. Diseñado para equipos técnicos y comerciales, ofrece un conjunto completo de funciones para garantizar un seguimiento transparente y eficiente de cada intervención.

    250,00 €  (500€)
  • Training Management — Gestione su organismo de formación en Dolibarr

    Training Management es la aplicación de negocio integrada en Dolibarr para organismos de formación profesional. Gestiona su catálogo, sesiones, formadores y alumnos, elabora sus documentos reglamentarios y hace seguimiento comercial y de calidad, todo desde una interfaz moderna pensada para el día a día de los equipos pedagógicos y administrativos.

    350,00 €  (700€)

Nuevos productos

  • Dolibarr The Book 24.0 (french version)

    The twenty-eighth edition of this book is being published at a time when the reputation of Dolibarr™ is already well established. Twenty-four years after the first lines of code were written by Rodolphe Quiédeville, under the leadership of Laurent Destailleur and with the help of many contributors, the Dolibarr™ ERP/CRM has become an essential name in the world of Open Source software.

    16,67 €
  • DocFinder

    Find any quote or invoice in seconds: one search box that looks through document numbers, customers, line items, products and notes, plus an amount filter. Each result shows the matching lines with your keyword highlighted, and one click takes you to the document.

    49,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 €
Sin IVA

Previous Next
  • Autor ProgSI
  • Versión del módulo 2.15
  • Fecha de lanzamiento 02/06/2019
  • Acceso a actualizaciones y descargas Acceso de por vida
  • Cómo contactar al soporte contact@progsi.ma
  • Compatibilidad Dolibarr V7 - V22
  • Última actualización 22/05/2026 14:32

Más información...

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

Creador/Licencia: ProgSI / AGPL
Idioma interfaz usuario: English / French
Ayuda/Soporte: Mail a contact@progsi.ma

Demo: https://pivot.progsi.ma

Doc: PivotReports

Prerrequisitos:

  • PostgreSQL not supported

Para instalar este módulo:

  • Descargar el archivo del módulo (archivo .zip) desde la web DoliStore.com
  • Ponga el archivo en el directorio custom de Dolibarr.
  • Descomprima el zip archivo, por ejamplo usando el comando
unzip module_pivotreports-auto.zip
  • El módulo o tema está listo para ser activado.

 

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