I’m back to sharing tools I create for myself with the community.
I could not find a reporting module that was powerful enough for advanced SQL users that want to use any SQL to build reports, so I have started building one. If I may say so myself I think it is pretty powerful and yet very easy to use.
It also allows admins to link reports directly to modules or even records inside the CRM that make it super friendly for users that need to use the reports. It also uses caching to make pagination and exporting more lightweight and can export as PDF, CSV or HTML.
If you can write a SQL query to fetch the data you want, you can now add it as a report inside your CRM using this module.
I am attaching the full README file FYI. I would really appreciate it if you would give it a spin and let me have some feedback. You can download it from my SuiteCRM Tools page.