Back to navigation bar   Aggregate

Properties
dbAggSQL, dbAggNameTag, dbAggMagicCell, dbAggColumns

The Aggregate activity involves the following properties -

Fields
Aggregate functions work son numeric fields as well as text fields as long as the text are all numbers. 

Aggregate SQL
This SQL should have the same field sequence like the dbSQL. The insignificant fields on the left should be called ('#skip#') while the insignificant fields between aggregate fields should be blanks (''). insignificant fields on the right can be omitted. This complex SQL is automatically generated when the aggregate fields are selected. 

Criteria
While the Aggregate SQL provides the correct positioning, the criteria is appended to provide the matching of the dbSQL.

SQL / Columns
Choice of constructing dbSQL or dbColumns property when the fields are selected. The dbColumn's fields will be constructed as the fields are selected. dbAggColumns fields are field index and is used when the user has no control of the SQL source like  a Store Procedure. The Aggregate function is carried out dynamically when the cells are displayed. This is the hard way and should be used when there is no other choice. Columns convert the cell contents to numeric to conduct the aggregate function. Therefore, it'll work on the text field also.

AggColumns / Type
dbAggColumn is the column number of the Aggregate columns.  Avoid entering this manually. There are only 3 types of aggregate functions supported at this time - SUM, MIN and MAX.

Label / Label Tag
This is the label placed on the leftmost of the aggregate values. The tag is usually a combination of COLSPAN and ALIGN. The Designer will automatically provide the correct COLSPAN value to position the Label.

AggMagicCell
Just like the Grid and Form MagicCell. AggMagic Cell provide Magic treatment to the various aggregate values. Only field index should be used. Refer to the MagicCell form. Choose the AggMagicCell option , build the magic properties and send the value to this box by clicking the button.

Reset
Left click clears all the entries and restores they defaults.