Previous Topic
Add Aggregation Dialog Box Properties
You can use the Add Aggregation dialog box to create a dynamic aggregation object in a report. This topic describes the properties in the dialog box.
Aggregation Name
Specify the display name of the aggregation object.
Mapping Name
Select the ellipsis button 
to open the Select Resource dialog box. Then, select a field or a formula which the aggregation object is based on. Server displays the field with its parent node in the text box.
Aggregate Function
Select the aggregate function of the aggregation object. Server applies the function to the group where the aggregation is or to the entire report if the aggregation is in the report header or footer.
Distinct On
Server enables this property when you have selected DistinctSum as the aggregate function. Select the ellipsis button to open the Select Fields dialog box. Then, select the required fields according to whose unique values you want to calculate the DistinctSum function.
OK
Select to create the aggregation object and exit the dialog box.
Cancel
Select to close the dialog box without creating an aggregation object.
Help
Select to view information about the dialog box.