In many reports it is necessary to calculate totals – sums of a page, number of strings, average value etc. For this you can use aggregate functions in StimulReport.Net. Using aggregate functions you can calculate a sum, number of strings, average values, maximal values, minimal values, to get first values from the list, to get last values from the list, to get a string by the specified range. The ranges of strings can be strings of a list, strings on one page, strings from a group, strings from a container etc.
StimulReport.Net supports seven aggregate functions as follows:
| • | Sum - returns the sum of the specified expression; |
| • | Count - returns the number of rows in the specified range; |
| • | Avg - returns the average value of the specified expression; |
| • | Min - returns the minimal value of the specified expression; |
| • | Max - returns the maximal value of the specified expression; |
| • | First - returns the first value in the specified range; |
| • | Last - returns the last value in the specified range. |
