Different arithmetical and logical expressions may be used in report template.
Arithmetical operations:
>, <, =, <=, >=, <>, != (not equal), +, -, *, /, % (mod)
Logical operations: && (and), || (or), ! (not)
For example:
\IF( (table1:field1>b+1) || (table1:field1=0) )\
............
\ENDIF\
The next built-in functions are supported by report language:
Variables and conditions: VAR, SET, IIF, :=
String functions: STR, VAL, UPPER, LOWER, COPY, MID, SUBSTR, POS, TRIM, FORMATFLOAT
Dataset navigation: EOF, BOF, LAST, FIRST, NEXT, PRIOR
Numeric functions: ROUND, INT, FRAC, POWER, INTPOWER
Date/time functions: NOW, DATE, TIME, DATETOSTR, DATETIMETOSTR, TIMETOSTR, STRTODATE, STRTODATETIME, STRTOTIME, YEAR, MONTH, DAY, SYEAR, SMONTH, SDAY, DTOS, STOD
Next topic: Report variables