Project: Birt
Bug 146967 Total fuction with result of the aggregate on group-Level should be enhanced
Reported: 2006-06-13 22:45:35 | Status: closed fixed

Description: Now if we want to do total fuction with the Aggregate result on the group level, it cant be fulfilled. For example, we set a total.sum() aggregate on a group level first, and then we sum the result of total.sum() again. The expected result should simply equal to sum over all rows. But the actual result is not as our requirement. I attached the design file as the example. Expected result: The aggregation on the group total should be enhanced, or we cant get expected result such as the requirement that total.rank() with the average result on the group level and so on.

Files changed in fix:
data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/expression/AbstractExpressionCompiler.java data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/expression/AggregateExpression.java data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/expression/AggregateObject.java data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/expression/AggregationTablePopulator.java data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/expression/BytecodeExpression.java data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/expression/ComplexExpression.java data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/expression/ExpressionCompiler.java data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/expression/MultiPassExpressionCompiler.java data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/i18n/ResourceConstants.java data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/impl/PreparedQuery.java data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/impl/QueryExecutor.java data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/impl/aggregation/AggrExprInfo.java data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/impl/aggregation/AggrRegistry.java data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/impl/aggregation/AggregateCalculator.java data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/impl/aggregation/AggregateTable.java data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/impl/aggregation/JSAggrValueObject.java