multiply, divide

i * j / k

Arithmetic operators for numeric types only.

percent

i % j

Calculates i as a percent of j; numeric types only.

add, subtract

i + j - k

Arithmetic operators for numeric types only.

equal

i == j

Comparison operators for string, numeric, and date types.

not equal

i != j

less than

i < j

Comparison operators for numeric and date types only.

less than or equal

i <= j

greater than

i > j

greater than or equal

i >= j

IN set

i IN ('apples','oranges')

Sets can be of any type.

IN range

i IN (j:k)

Ranges must be numeric or date types.

NOT

NOT( i )

Boolean operators. Parentheses are required for NOT.

AND

i AND j AND k

OR

i OR j OR k

parentheses

()

Used for grouping.

startsWith

startsWith(i, 'prefix')

Comparison operators for strings.

endsWith

endsWith(j, 'suffix')

contains

contains(k, 'substring')

concat

concat(i, ' and ', j, ...)

Returns the string of all parameters concatenated.

testProfileAttribute1Profile attributes are available in all editions of JasperReports Server, but the testProfileAttribute function is available only in JasperReports Server Professional and Enterprise editions. Contact Jaspersoft to obtain the software.

testProfileAttribute(table_ID.field_name,'profileAttribute')

table_ID.field_name is the table name and field name of the field you’re comparing to a profile attribute. This argument can also be an expression, such as a concatenation of fields. It cannot be a constant or a groovy call.

profileAttribute is the name of the user profile attribute.