Aggregates Calculations

Section reports have a limited support for expressions and aggregates. To add an aggregation, you should specify any of these for TextBox controls in the Detail section:

Function	Description
DistinctField	Gets or sets the name of the data field used in a distinct summary function.
SummaryFunc	Determines the summary calculation function performed on the DataField value.
SummaryGroup	Gets or sets the name of the group header section that is used to reset the summary value when calculating subtotals.
SummaryRunning	Gets or sets a value that determines whether the data field summary value will be accumulated or reset for each level (detail, group or page). Possible options are None, Group, or All.
SummaryType	Determines the type of field summary. Possible options are None, GrandTotal, Sub Total, PageCount, or PageTotal.

Note: Section Report keeps decimal numbers exactly as they are throughout calculations. This means totals and averages for values like prices or money will be accurate, without small rounding differences. When you format results as currency, they will display correctly.
Example:
Imagine you have amounts: 0.1 + 0.2 + 0.3 + 0.4 + 0.5. Section Report calculates it exactly, so you see $1.50 — the correct total.

The field expressions support simple operators like the following:

Operator	Description
expr ? expr : expr	Ternary conditional operator.
\|\|	Conditional OR operator.
\|	Bitwise OR operator.
^	XOR (exclusive~ OR) operator
&	Bitwise AND operator.
&&	Conditional AND operator.
==	Conditional equal operator.
!=	Conditional not equal operator.
<	Less than operator.
<=	Less than or equal to operator.
>	Greater than operator.
>=	Greater than or equal to operator.
Is	Type testing operator.
As	Type casting operator.
<<	Bitwise shift left operator.
>>	Bitwise shift right operator.
+	Addition operator.
-	Subtraction operator.
*	Multiplication operator.
/	Division operator.
%	Modulo operator.
~	Bitwise complement.
.	Period operator.
!	Negation operator.
(…) and [..]	Brackets operator.