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  
     

Add Feedback