FieldStatistic Tag

Purpose

The GEN:FieldStatistic tag is used within 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 displayed on the current page.  Configure the desired action in the Property Sheet.

The FieldStatistic tag sums columns in a table.

To display a count of records returned by the current query, you can use GEN:Pagination tag.  See Pagination Tag for details.

Formatting page and grand totals

Specify the formatting of a page or grand total via the Databases tab.  This formatting is global across all pages and cannot be set on an individual field within a panel.  Customizing display formatting for an individual field (displayed in a table) does not control the formatting of the page or grand total.

Application Generation Properties (Iron Speed Designer)

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

Property

Description

Database field

Field

Specifies the database  field for which the statistic is calculated, in the format:

<TABLE>.<FIELD>

Note that you can sort on any field you like – even one that is not displayed within the table.

Scope

The portion of data included in the calculation.

All Pages

The statistic is calculated for the entire database table, after taking into account any filters and other limiting criteria applied to the table.

Current Page

The statistic is calculated for only those rows displayed on the current page.

ASP.NET Properties

See ASP.NET Control Properties for details.

See Also

Code Generation Tags

Code Generation Tag Properties