Feedback on: EventPro Planner Manual - Expression FieldExpression_Field_Chapter_18_Report_DesignerChapter 18: Reports > Modify Reports in Report Designer > Other Changes to Components > Expression Field /Dear EventPro Planner Documentation Department,
Expression Field
1.
Right-click a DB Text Field and select Expression from the speed menu.
2.
The Expression dialog appears.
3.
The expression field assumes that a math procedure is going to be entered.
4.
Fields are noted with the use of the colon (:) character. All standard mathematical symbols apply.
a.
+ Addition
b.
- Subtraction
c.
* Multiplication
d.
/ Division
5.
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.
a.
Thus: $:CusCity, :CusState :CusZipCode becomes Beverly Hills, CA 90213
b.
If the $ is there, any field can be formatted using the following characters: :~xxField (where xx is one of the Format Codes listed below).
6.
Format Codes:
a.
tt - time format
b.
dd - short date format with long time format
c.
dt -date and time format
d.
dl - long date format
e.
ds - short date format
f.
tt - long time format
g.
nm - a regular number
h.
cu - currency
i.
in - integer value (no decimals)
j.
fx - float format with x decimals
7.
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
8.
TextWhenEmpty, Mapping, TextPrefix and TextSuffix are applied afterwards.
