Report Editor - Expression : Fields Help
You can use values from the field of the source cursor in the expression. To do this – just double click the necessary field in the list.
- For the JavaScript expression, $F('field_name') global function call will be inserted at the position of the cursor.
- For the SQL expression, the name of the clicked field will be inserted.
EXAMPLES
JavaScript Expression | Output |
---|---|
`Field A = ${ $F('f_numA') }; Field B = ${ $F('f_numB') }; Field C = ${ $F('f_numC') }; | Field A = 5; Field B = 10; Field C = 25; |
$F('f_numA') + $F('f_numB') + $F('f_numC') | 40 |
$F('f_vcahrA') + $F('f_vcahrB') | HelloWorld |
$F('f_vcahrA) + ' ' + $F('f_vcahrB') | Hello World |
$F('f_vcahrB').length() | 5 |
SQL Expression | Output |
---|---|
f_numA + f_numB + f_numC | 40 |
concat( f_vcahrA, ' ', f_vcahrB ) | Hello World |
hex( f_numC ) | 0x19 |
length( f_vcahrB ) | 5 |