One can use aggregated lists when it is necessary to count the totals of the list. The list of the aggregate functions for the data output in the DataBand can be specified in the Totals property with the help of Collection Editor.

AggregateFunction property specifies the aggregated function. The aggregated expression is set by the Expression property. The name of the function is to be specified in the Name property. GetTotal("<aggregate name>") script is used for calling the function and getting the sum; GetRunningTotal("<aggregate name>") is used in order to get current cumulative value. One can get arrogated data before the output of the aggregated values. GetTotal result does not depend on the location of the caller element: before or after. It is recommended to output GetRunningTotal value in the Detail; calling from the Header is useless because there are no accumulated values; GetRunningTotal value called from the Footer will coincide with GetTotal value.
Report generator supports 12 built-in aggregate functions.
Example of the aggregate functions operating:
Report Template

dataBand.DataSource = Numbers; textBox1.Value = dataBand["Value"]; textBox.Value = GetTotal("Func");
Total:
Property |
Report |
|
|
Arithmetic mean:
Property |
Report |
|
|
Minimal element:
Property |
Report |
|
|
Maximal element:
Property |
Report |
|
|
Elements amount:
Property |
Report |
|
|
Standard Deviation:
Property |
Report |
|
|
Estimate of Standard Deviation:
Property |
Report |
|
|
Variance:
Property |
Report |
|
|
Estimate of variance:
Property |
Report |
|
|
Median:
Property |
Report |
|
|
Skewness:
Property |
Report |
|
|
Kurtosis:
Property |
Report |
|
|
Article ID: 178, Created: September 8, 2010 at 1:37 PM, Modified: September 8, 2010 at 1:57 PM