Expression Field

1.	Right-click a DB text field and select Expression from the speed menu. The Expression dialog box appears.

_img877

2.	The expression field assumes that a math procedure is going to be entered.

3.	Fields are noted with the use of the colon (:) character. All standard mathematical symbols apply.

a.	+ Addition

b.	- Subtraction

c.	* Multiplication

d.	/ Division

Report ‘DBCalc’ Control Math: Values within DBCalc fields can also be added together. Simply use the Report Tree to name the controls that you wish to add together. Controls are noted with the use of the at (@) character. All standard mathematical symbols apply. Controls will be located regardless of their location within the report.

String Concatenation and Manipulation: If the first character in the expression is a dollar sign ($), all text in the expression will be printed and only the fields will be converted to values. No math will be done and other characters are printed as literals. Thus: $:CusCity, :CusState :CusZipCode becomes Beverly Hills, CA 90210. If the $ is there, any field can be formatted using the following characters: :~xxField (where xx is one of the Format Codes listed below).

a.	Format Codes:

i.	tt - time format

ii.	dd - short date format with long time format

iii.	dt -date and time format

iv.	dl - long date format

v.	ds - short date format

vi.	tt - long time format

vii.	nm - a regular number

viii.

cu - currency

ix.	in - integer value (no decimals)

x.	fx - float format with x decimals

6.	If the expression has not been formatted as a string, the formatting is handled by the PSIDbText control’s DisplayFormat property.

a.	PSIDbText Priority

i.	Pipeline and Data Field

ii.	DisplayText

iii.	Expression

iv.	System Variable

b.	TextWhenEmpty, Mapping, TextPrefix and TextSuffix are applied afterwards.

Help URL: http://www.eventpro.net/Manual/HTML/index.html?ch15_expression_field.htm

Expression Field						CH15_Expression_Field Dear EventPro Documentation Department,
Expression Field