Agg property editor

Use the Agg property editor to specify data aggregation properties from within the JBuilder UI Designer. Properties specified in this dialog are stored in an instance of an AggDescriptor object.

To display this dialog, select the agg property in the Inspector when a Column of a DataSet component is selected in the Component Tree.

Grouping Columns

The columns of the DataSet by which the aggregation should be grouped. Only non-calculated, non-aggregate column names are allowed in this list.

Available Columns

The list of columns from the DataSet that you can select from when choosing columns for grouping the data. Column names displayed in Grouping Columns are excluded from this list. Double-click or highlight a column name then select Add To Group to add a column to the grouping. When you do this, the column name disappears from this list and is added to the Grouping Columns list.

Remove From Group

Removes the currently selected column name from the Grouping Columns list and displays it in the Available Columns list.

Add To Group

Removes the currently selected column name from the Available Columns list and adds it to the Grouping Columns list.

Custom Aggregate/Calculation On Aggregate

Select this if you want to perform a custom aggregation, for example, a calculation on the aggregated values could involve the sum of line items multiplied by a constant "markup" amount. Selecting this field assigns a null value to the Aggregate Column and Aggregate Operation fields (which indicates a calculated aggregate operation), and disables both fields.

To specify a custom aggregate, select this option and

  1. Set the column type of the aggregate column to CalcType.AGGREGATE
  2. A CalcAggFieldsListener must be registered with the Aggregate Column's DataSet

Aggregate Column

Select the column from the DataSet whose values will be aggregated.

Aggregate Operation

Select the class that provides the functionality for the aggregation operation you are performing. This list displays all JBCL AggOperators as well as user-defined ones within the same class context as the Aggregate Column value.