Kbase 16539: Report Builder - Aggregate field - Reset & Accumulation
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Report Builder - Aggregate field - Reset & Accumulation
What happens when you specify different Reset & Accumulation values
-------------------------------------------------------------------
on an aggregate field?
---------------------
The following example was created using the sports database:
Customer table joined to order;
sort by cust-num
filter cust-num < 3
Report layout:
Record band line: Cust-Num Order-Num calc1 calc2 calc3
Cust-Num Group Footer band line: aggr1 aggr2 aggr3
Where calc1 and calc2 are calculated fields and calc3 = calc1 + calc2
Aggr1 is total of calc1, aggr2 is total of calc2 and
aggr3 is total of calc3.
Using aggr3 made the following changes to the aggregate expression:
=====
1. Reset = No-Reset
Accumulation Frequency = Every Composite.
Result = Running Total for all Cust-Num.
============ ===
2. Reset = Cust-Num
Accumulation Frequency = Every Composite
Result = Total per Cust-Num.
===== ===
3. Reset = Cust-Num
Accumulation Frequency = Cust-Num
Result = Total for the last Cust-Num.
===== ==== ========
The Accumulation frequency of Cust-Num will make the Aggregate reset
for each Cust-Num if the Reset is Cust-Num.
4. Reset = No-reset
Accumulation = Cust-Num
Result = Total for the set of Cust-Num
===== ===============
The Accumulation frequency of Cust-Num will make the Aggregate reset
for Group Cust-Num if the Reset is No-reset.
The processing was done on FINAL pass for all of the above.
More information on this can be found in the Report Builder User's
Guide, Chapter 5.
Progress Software Technical Support Note # 16539