Hello, I have to make some simple reports, that still seems to extend the capabilities of SC grids.
So 1st problem:
It seems that you can’t use union in SQL for grid, in example this
SELECT
count(p.ID) as Mcount,
p.month as month
FROM
progress p
GROUP BY p.month
union
select 0 as Mcount, DATE_ADD(max(pr.month), INTERVAL 1 MONTH) as month
from progress pr
will end up with error on execution. I didn’t find any way to add new row to grid, therefore my current workaround is before execution adding pointless record to table and removing it after, but that’s really dirty way how to gain so simple result.
2nd problem:
I use your own “group by” in sql, cause I really dislike the way, how SC represents grouping, but without using the SC grouping it isn’t possible to add charting to that report. I haven’t found way to disable the nasty visual representation of grouping in SC and there seems to be no options to enable charting w/o that. Any ideas?