TableStatistic Tag

Purpose

The GEN:TableStatistic tag is similar to the FieldStatistic tag, but can be used outside a GEN:Table tag to display summary information about a field from a database. For example, this tag can be used to display the total amount of all of the items in an order. The tag can also display the total just for the records based on a query. This tag is typically used on a dashboard page to display the number of records or the total number of records.

The TableStatistic tag sums columns in a table.

Specify the table and field to sum in the Property Sheet.

Examples

<GEN:TableStatistic Name=“QuotesSent” />

[Application Generation] properties (Iron Speed Designer)

These properties control specific types of controls created by Iron Speed Designer.

Property

Description

Query function

QueryFunction

The statistic to calculate.

Count	Counts the number of records in the result set.
Sum	Sums the field values of the records in the result set.

Database field

TableName

Specifies the database field for which the calculation is performed in the format:

ASP.NET Properties

See ASP.NET Control Properties for details.