All I actually like to have is a DISTINCT COUNT on a String column field, but it seems to me that all the aggregate functions behave as if they are simulating the "FIRST" functionality.
I can't believe this is broken and it seems more likely I am missing something very strange here.
(I am quite experienced already with JasperReports and worked with BIRT and other reporting frameworks before as well.)
Looking at the docs I can't see where the problem should be: http://www.jasperassistant.com/docs/guide/ch06s08.html
Finally I created the attached simple sample report based on the sample db and updated to the latest 5.5.1.final release without any progress.
Please anybody tell me the secrets I am missing or to my big surprise assure it's a bug indeed
as you can see in the report there is just some page header and summary bands, containing the product id/name/cost labels, the name count, cost count, cost sum and all variations of name count increment types (report/column/page/none). the summary band holds the cost sum. the detail band contains just the details.
But none of the aggregate functions shows aggregated data, but only the first(xxx) result it seems. (so strange anyways that the count(name) shows the first rows name instead of a number :-( ).