This section lists the functions supported by OpenCReports in topics, and alphabetically in their topic.
Most functions below operate in this way, unless noted otherwise:
numeric and bitwise functions with more than two operands take their first operand and perform the same operation using the second, third, etc. operands repeatedly.
if any of the operands is an error (resulting from runtime processing of a subexpression), then the result will use the exact error of the first operand that is an error.
if any of the operands is NULL (e.g. the data source is SQL and the field value is SQL NULL) then the result will also be NULL.
Boolean logic functions treat their operands with 0 being false and anything else (even fractions less than 0.5) as true.
Bitwise functions treat their operands as 64-bit numeric values, with rounding if they are fractions.
String arithmetics operate on UTF-8 encoded strings and count in number of UTF-8 characters instead of byte length.