Expression Builder Functions in TAM Reports

Most of the following information was compiled using FoxPro for Windows Developer's Guide by Jeb Long, Sams Publishing, and FoxPro Commands & Functions Including Examples, Fox Software by Fox Holdings, Inc. as a reference. The examples of each function were created by Applied Systems, Inc. for use with TAM Reports.

This section introduces commonly used Expression Builder functions for modifying output in TAM Reports. Functions in Expression Builder are accessed through Extra Criteria, Filter Result, or Edit Report Format.

The following table contains definitions of common codes used in Expression Builder.

ExpC

Character expression

ExpN

Numeric expression

ExpD

Date expression

ExpT

Date Time expression

ExpL

Logic expression

( )

Follow the function name and indicates the proper use of the function. If commas or spaces are necessary they are included in the function.

[ ]

If brackets are inside parentheses, the area inside is optional.

.T.

Logical True

.F.

Logical False

For specific definitions and examples of string, logical, math and date functions, click the links below.

Note: The TAM Functions document discusses the use of functions that were not created by FoxPro but were specifically installed for TAM.