I have to build a report based on 3 tables with an X/Y axis structure. The result is a series of SUM() and COUNT().
How can I build that? It is quite complex.
Build an html based report grabbing the data with getDatasetByQuery() is the only way?
For any reports try the Jasper reports.
Design them using the free iReports.
You can use the Servoy provided plugin (not free) or roll your own to invoke the design or compiled report.
I am in the midst of creating a simple interface for Jasper Reports. I will post results once I get it completed to my satisfaction, or contact me directly.
See: http://www.jaspersoft.com
and
http://www.jasperforge.org/jaspersoft/opensource/business_intelligence/ireport/
Regards,
Tom