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.
#4614 - No results are found using this Plugin
Hi, When creating a report, I choose some columns to be viewed. Report show results. When adding a simple SQL query, such as " When country_c <> ' ' or " select * from cases where name is not null " I do not get any results at all.
a year ago
Can you send screen shots of exactly what you have in the "Additional SQL" section please, also a screen shot of the "Analyse SQL" results. please note that the additional SQL should be additional parts of the where (so in your cases axample you would put "name is not NULL" in the box). Also note that it needs to be valid SQL so the fields need to be valid and correct as per the Analyse SQL section so in my Cases for example I would need to put
cases.name IS NOT NULL to avoid conflict with joins etc. (less important for simple non joined queries but a good habit to get into). I can tell you the cases example works for me hereRegards
Mark