Switch to: V11V10V9V8V7V6V5

Report Editor - Expression : Functions Help

In the SQL expressions, you can use values calculated by function in the expression. To do this – just double-click the necessary function in the list. As a result, in the text area of the expression, the function definition will be added at the position of the cursor. If function requires the parameters you should substitute them.

Report Editor - Expression : Functions Help

EXAMPLES

Output
bit_count( Address ) 6
cos( 15 ) -0.759688
current_userid() 0
exp( 10 ) 22026.465795
concat( “Country/Region”, Address ) USA123 1st Street
upper( Company ) COMPANY A
version() 9.6 .