|
In many reports it is
necessary to calculate totals: totals by a page, number of rows in
a group, average value etc. For all these calculations it is
possible to use aggregate functions. Using aggregate functions, it
is possible to calculate a sum, number of rows, average values,
maximal values, minimal values, to get first values from the list,
to get last values from the list etc. The ranges of rows can be all
rows of a list, rows on one page, rows from one group, rows from
one container etc.
Stimulsoft
Reports supports the following aggregate functions:
|
·
|
Avg
-
returns the
average value of the specified expression; |
|
·
|
Count
-
returns the
number of rows in the specified range; |
|
·
|
CountDistinct
- returns the
number of unique rows in the specified range; |
|
·
|
First
-
returns the
first value in the specified range; |
|
·
|
Last
-
returns the
last value in the specified range; |
|
·
|
Max
-
returns the
maximal value of the specified expression; |
|
·
|
Median
-
returns the
median of all values of the specified range; |
|
·
|
Min
-
returns the
minimal value of the specified expression; |
|
·
|
Mode
- returns the greatest value
of the specified range; |
|
·
|
Sum
-
returns the
sum of the specified expression. |
|