Bookshelf Home | Contents | Index | PDF     

Siebel Medical Handheld Guide > Print Tagging Language > Get and Set Tags >

GetTotal Tag

The GetTotal tag calculates the total for a specified column (or for all selected rows) and assigns the value to a variable.

Usage

Use the GetTotal tag to calculate a column total and display the total in your report.

Syntax

To use this tag, use the following syntax:

<TAG:GetTotal appletname="APPLET NAME" fieldName="FIELD NAME" query="QUERY STRING" variable="VARIABLE NAME">

Parameter
Description

TAG:GetTotal

(Required) Required tag indicator.

appletname

(Required) Name of the applet.

fieldname

(Required) Name of the field or column. Specify a field or column with numeric data. If you specify a field with non-numeric data, a 0 is assigned to the variable.

query

(Optional) Search specification for the rows to be included in the total. If not specified, the current search specification is used.

The syntax for the query string is: Field Name|Query Statement. You can specify one or more query strings separated by a vertical bar (|).

For example, Query="Name|LIKE 'Sieb*'"|"Location|LIKE 'H*'"

variable

(Required) Name of variable where the value is stored.
Example

<TAG:GetTotal appletname="CS HH Product Bucket List Applet" fieldname="Quantity" variable="ProdBucketListTotal">

    
Siebel Medical Handheld Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.