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
- Set the column type of the aggregate column to
CalcType.AGGREGATE
- 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.