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.
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 . |