The SuiteCRM Reporting module is pretty good at what it does, however, there are a few things that it doesn’t allow you to easily do. For example, say you hold regular events, you have added all your delegates and want to see how many events each of your contacts attended last year. Due to the way the Attendance information is stored you can’t currently filter only contacts marked as attended in the reporter.
Once installed the module provides a free text box that allows you to add manually crafted SQL to your report. This allows you to further filter by the fields that AOR Reports does not currently allow you to (for example the Events Invite/Acceptance status).
Additionally, the module provides an Analysis mode for the AOR Reports editor, allowing you to view the SQL that will be run. All SQL is cleanly formatted for ease of review.
Our recently released Suite CRM Reports Enhancer Plug-in allows you to add custom SQL to your SuiteCRM reports and view the formatted SQL statement.
Create tailored reports that are more useful for your business
While the Advanced Open Reports (AOR) module built into SuiteCRM works well for your basic reporting needs, it does not allow users to do certain functions very easily. For example, if your business hosts events on a regular basis, you would want to know how many events your contacts have attended in the last year, or another set timeframe. Due to the current way attendance information is stored in SuiteCRM, you can not filter by only contacts marked as attended in the reporter.
How it Works
Once Report Enhancer is installed, the module provides a text box where you can manually add your custom SQL to the report. This add-on allows you to further filter by fields that the current AOR module does not allow you to filter by (for example, the Events Invite/Acceptance status).
Additionally, the Report Enhancer add-on provides an analysis mode for the reporting editor, allowing you to view the SQL that will be run. All SQL is cleanly formatted for ease of review.