When using a redshift database and have time stored in a integer such as seconds. To get the results in a SQL you have to use a query on the database like:
"seconds" * interval '1 sec' as "time"
But when you group them and aggregate as a summary calculation, you have to use the Sum() function BUT JasperServer only allows you to select a Count() function against a Time Java Type.
so when the Query runs for summary it runs with:
Count("seconds" * interval '1 sec') as "time"
Sum("seconds" * interval '1 sec') as "time"
There needs to be a change so that Time can be done as a Sum() on the SQL as well as option for Count()
This can be achieved by allowing in the domain designer on the server having Sum option on the summary calculation dropdown
This is important so that customers can see time in correct format rather than integer or decimal for hours
|Components||JasperReports Server, AdHoc, Domains|