Customization Report SuitCRM from SQL sub query

This package allows you to create subqueries for each column. Greatly expands the functionality of standard reports. Allows to display several columns from related modules with different conditions in one report.

This package will allow you to compose various reports in the system, not limited to the standard functionality, one condition for the selection. For example, it will be possible to draw up a report in which the amount of contracts at each stage will be calculated for each counterparty.

Install

  1. Download the package from the repository (build / Build.zip) or follow the link (latest version)
  2. Go to Administration -> Module Loader.
  3. Install the package in the CRM following the prompts.
  4. After installation go to admin -> Repair -> Quick Repair and Rebuild
  5. Reset the browser cache on the reports page (mandatory condition).

Leave a Reply

Your email address will not be published. Required fields are marked *