Switch to: V11V10V9V8V7V6V5

Report Editor - Expression : Fields Help

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