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. |
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. |
