Totals
In many reports, we may need to show some total information: sum of the group, number of rows in the list, and many others. FastReport uses totals to perform this task. For the total, you need to indicate the following parameters:
- the total function type;
- the expression, which is supposed to be calculated. For the
Count
function, you do not need to indicate the expression; - the condition. The function will be calculated if the condition is met. It's not obligatory to set up the condition.
- the data band, for which the function will be processed;
- the band, in which the total value will be printed.
The list of total functions is given below:
Function | Description |
---|---|
Sum | Calculates the sum of the expression. |
Min | Calculates the minimum value of the expression. |
Max | Calculates the maximum value of the expression. |
Average | Calculates the average value of the expression. |
Count | Returns the number of rows. |
CountDistinct | Returns the number of distinct values. |