Hello Sugar lovers,
We're regularly confronted to the limitations of the standard Sugar Reports module: No HAVING, no DISTINCT, no ability to make calculations...
Currently our customers do not want to invest in third pary solutions (Discover and the other reporting plugins), so that's out of the equation.
We do know of the Enterprise / Advanced / SQL reports, but that is not usable for day to day users. Also, we'd love to have the results in dashboard dashlets.
Has any of you ever built a dashlet that allows a user to pick an advanced report and simply present the results in a table? A graph would be nice, but a table would be a start. In all honesty, I've asked an AI bot to generate the module for me but my trust level is quite low on code generation at the moment (but that's another debate ;) ).
How do you approach that kind of need?
Thanks in advance!
Cheers,
Damien