The Report Enhancer add-on goes beyond the existing SuiteCRM reporting module, enabling users to add custom SQL to reports and view the formatted SQL statement.
FAQ
[Who is this for?]
This module is intended for people with some level of SQL knowledge to tweak the existing reports results
[What about AND or OR]
You can use AND and OR in the Additional SQL box, however it will all be AND'ed to the statements contained in the Conditionals section of the report
[Do you provide support?]
We can help you with installing and getting the module working, however should you require help creating your reports do contact us for our hourly rates.
[How does it Work?]
The module Overrides/Redirects the Reports (AOR_Reports) Bean, it IS upgrade safe however if you have any custom overrides already in place this will need to be considered prior to installing. Do contact us for help if you require us to verify this.
[Older SuiteCRM]
We have added a version specifically for SuiteCRM7.3, this is tested and working based on a few very simple tests that we can do here, the download file is called extendedreports73.zip, you should purchase the relevant plan and download and install this if you are still using SuiteCRM7.3.x
[Removal]
When removing the module, we do not remove the Additional Where field, nor the Associated Tab, to remove this visit the Admin area, Studio. Select Reports then Layouts, Edit View. Drag the entire Edit Additional Where grey panel to the red Delete button. The click Save and Deploy. This will remove the tab from your view.
Saving Comment...
