# Aggregates Calculations

Section reports have a limited support for expressions and aggregates, which are supported in TextBox and ReportInfo controls. These expressions are DistinctField, SummaryFunc, SummaryGroup, SummaryRunning, and SummaryType.

## Content



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](/activereportsnet/api/v19.2/MESCIUS.ActiveReports/GrapeCity.ActiveReports.SectionReportModel.TextBox.html#DISTINCTFIELD) | Gets or sets the name of the data field used in a distinct summary function. |
| [SummaryFunc](/activereportsnet/api/v19.2/MESCIUS.ActiveReports/GrapeCity.ActiveReports.SectionReportModel.TextBox.html#SUMMARYFUNC) | Determines the summary calculation function performed on the DataField value. |
| [SummaryGroup](/activereportsnet/api/v19.2/MESCIUS.ActiveReports/GrapeCity.ActiveReports.SectionReportModel.TextBox.html#SUMMARYGROUP) | Gets or sets the name of the group header section that is used to reset the summary value when calculating subtotals. |
| [SummaryRunning](/activereportsnet/api/v19.2/MESCIUS.ActiveReports/GrapeCity.ActiveReports.SectionReportModel.TextBox.html#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](/activereportsnet/api/v19.2/MESCIUS.ActiveReports/GrapeCity.ActiveReports.SectionReportModel.TextBox.html#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. |