Perform Column and Row Aggregate on a grid.

dbQP Abbr: agg
Version: Gold

Namespace:  Tornado
Assembly:  Tornado (in Tornado.dll) Version: 12.6.0.9 (1.0.0.0)

Syntax

C#
public string dbAggregate { get; set; }
Visual Basic (Declaration)
Public Property dbAggregate As String

Field 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.

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