I've tried to use an aggregation to count the data in a grouped table with a filter of the information "date".
I counted the number of data in a month with this filter expression: BirtDateTime.month(row["date"]) == 1
The version of the BIRT I used is 2.3.2 .
My problem is that if there's no data for the month (data that verifies the filter condition expression), the table shows nothing instead of 0.
Is this something configurable and how to configure it?
If else, is this a bug known of the version I used? (I've done some reaserch but I don't find a similar topic.) In this case, is there any possible script solution for my problem?
The solution works well in my local environnement, when I imported my report on the server. The script doesn't work any more.
Do you have any idea what could be the cause of the problem? It this possibly configuable somehow?
It's the application Maximo 7 with the server Webshpere which runs the reports.
I think that it calls a applet java to run the reports, but I'm not sure.
I don't have the error in the log of the server.
Thanks again, it works on the two sides when i move the script to the "onRender" event.
It's although strange to have a different behavior for the "onCreate" event in the viewer and in the server.
The point is that it works now.