I'm running BIRT 3.7.2 32 bit with JRE7u11 32 bit on Windows 7 64 bit. When creating a table aggregation for rowcount, it works fine in preview, but then gives me 0 in web viewer. This is happening with several other types of aggregation as well, but this is the simplest. I took the same report and ran it (and recreated it from scratch) in BIRT 4.2.1 64 bit with JRE7u11 64 bit, also with JRE6u38 64 bit, all giving me the same results. I think this is a bug with BIRT, but can't determine what the problem is or how to even work around it. I don't see this listed in the bug tracker. Any ideas?
Take the row.__rownum expression out of the aggregation binding. It doesn't mind you using one of the options from the drop down, but it doesn't like that one. With the COUNT aggregation, no expression is necessary.
That's not intuitive to me, but it works! Thanks!
Any idea why web viewer also ignores filter conditions on my aggregations although it works in preview? I don't have a working example using the sample database, but I can try to whip one up if you want to see an example of how I'm doing it. I'm doing subtotals where a specific String field matches a static string. Maybe there's a problem with string comparisons in web viewer?
Hah, right before reading your last comment I actually figured out that I was using dataSetRow["element"], and changing it to row["element"] worked. I feel like I'm making progress, but I'm not sure why I never saw any errors. I happened to be in XML Source view when I ran in web viewer, and saw that there actually WERE errors in the XML source stating that dataSetRow was undefined. However, those errors never appeared on the actual report (and it actually works as expected in preview as I said before).
In any case, I think this is the solution to all my aggregation issues! Ah, the subtleties of BIRT!
Thanks again for all the help!
Yeah, there should probably be something that notifies you if you use dataSetRow or just take that option out of the expression builder. Either way, glad it's working now! Let us know whenever you have questions! Good luck!