Tornado API Library - V12.30.08

z.dbAggregate Property

Perform Column and Row Aggregate on a grid.

Product Version

Gold
[VisualBasic]
PublicPropertydbAggregateAsString
[C#]
publicstringdbAggregate{set;}

Property Value

dbAggregate = (~^:)Fields| AggType| BottomTemp| SumColHeader| HeaderTag| HeaderFormat| CellFormat ~ Repeat....

KeywordDescription
Delimiters (~^:)group; ^ = field; : = format of cell inside [[ ]].
FieldsFields or Cols of interest to perform Column and Row aggregate.
AggTypeAggregate type - SUM | AVG | MIN | MAX | COUNT.
BottomTempHTML template of bottom Row.
SumColHeaderHeader of the row aggregate (right side).
HeaderTag<TD> Tag of cell holding the aggregate.
HeaderFormatOnly one general format allowed in entire row aggregate.
CellFormatUse IsNumeric() or Val() to test the cell value. IsNumeric("10 boxes")=0 while Val("10 boxes")=10.
CellFormatUse IsNumeric() or Val() to test the cell value. IsNumeric("10 boxes")=0 while Val("10 boxes")=10.
[[GrandTotal:Format]]A special tag in which the total of the row is deposited.

QuickProp Keyword Abbreviation

agg

Remarks

The Super Aggregate function is simplified down to two properties. Note that a new parameter "Val" is implemented. This would take the Val(grid cell) instead of testing for IsNumeric. So, for a cell value of "10 boxes", user now have control whether to treat it as "10" (Val) or "0" (default - IsNumeric). That means all strings fields can be use in aggregate functions even if they come from a stored procedure! Super Aggregate functions include SUM, AVG, MIN, MAX, and Count (Excel style where blank=no count) in both Rows and Columns. The SUM aggregates of both rows and columns are exported for further processing - for instance, after the Aggregates produce the values for the grid, the same values could be used to produce a Chart. The dbAggregateExportTemplate property export these values in a 1D array which can then be retrieved using Tornado.GetData.CRSum(Unit) for further processing. For now, only SUM is supported.

See Also

z Class | Tornado Namespace | dbAggregateExportTemplate