Using Table Data Field Functions

After you enable table data and select the source by using the table object's Table Data property page, special Table Data Field data sources become available to help you design your table. These Table Data Field data sources are listed in the Data Sources pane of the Toolbox, and you can drag them to table cells to create a text object that is linked to the data source. For more information about how to add a Table Data Field data source to an object, refer to Creating Tables that Use Dynamic Data.

After you link a Table Data Field data source to an object, you can configure its properties by using the object's Data Sources property page. The property page includes settings that you can specify to calculate sum or other aggregate functions in the Table Data Field data source. You can also specify the range for which the function is calculated.

The following types of functions are available:

The following range options are available:

You can use a Table Data Field data source outside of the table in which it is defined, but when you do this, only an aggregate function can be used for the data source. The function defaults to Sum, and for the range you can select All Records or Current Page (Current Group is not supported). A typical use for this configuration would be to place the total price in an object outside of the table in which it is defined.

Examples

Use the examples in this section to become familiar with the basic steps for calculating a sum or other aggregate function in the Table Data Field data source. For each example, you must first create a new table object that is connected to a sample database and then configure a Table Data Field data source, as described in the following procedure.

If you want to go through the steps for both examples, you must create a separate BarTender document for each example.