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