Operators and functions in report

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

• Data tables 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