Aggregates Calculations

In This Topic

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 field 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:

expr ? expr : expr – ternary conditional
|| - conditional or
| - bitwise or
^ - xor
& - bitwise and
&& - conditional and
== - conditional equal
!= - conditional not equal
< - less
<= - less or equal
> - greater
>= - greater or equal
Is – type testing
As- type casting
<< - bitwise shift left
>> - bitwise shift right
+ - plus
- - Minus
* - Multiply
/ - Divide
% - Mod
~ - Complement
. - Period
! - negation
(…) and [..] brackets

The ReportInfo control also supports aggregation. For example, you can display page numbers and page count at the group level:

From the ActiveReports 18 Section report tab in the toolbox, drag the ReportInfo control to the GroupHeader or GroupFooter section of the report and set the FormatString property as above. See Display Page Numbers and Report Dates.
With the ReportInfo control still selected in the Properties Panel, drop down the SummaryGroup property and select the group for which you want to display a page count.
Drop down the SummaryRunning property and select Group.