Switch to: V11V10V9V8V7V6V5

Report Editor - Expression : Macros Help

Starting with version 9.6 the text expressions with macros are deprecated and should be replaced with JavaScript expressions.

You can use values, defined by macros, in the expression. To do this - just do double click on needed macro in the list. As result, in the text area of the expression, in the position of the cursor will be added a macro, instead of which will be substituted the corresponding value.

Report Editor - Expression : Macroses Help

  • date – defines the current date.
  • datetime – defines the current date and time.
  • day – defines the the current day of the month (01-31)
  • dbname – defines the name of datasource.
  • hour – defines the current hour in 24h format (00-23).
  • minute – defines the current minute (00-59);
  • month – defines the month as a decimal number (01-12)
  • monthname – defines the full name of current month.
  • page – defines the index of current page.
  • pagetotal – defines the total page count.
  • record – defines the index of current record.
  • recordtotal – defines the total record count of source cursor.
  • time – defines the current time.
  • weekday – defines the full name of the current weekday.
  • year – defines the current year.

EXAMPLES

Output
$(date) 09/16/2012
$(datetime) 09/16/2012 13:49:29:911
$(day) 16
$(dbname) VNorth
$(hour) 13
$(minute) 49
$(month) 09
$(monthname) September
$(page) 1
$(pagetotal) 29
$(record) 1
$(recordtotal) 29
$(time) 13:49:29:914
$(weekday) Sunday
$(year) 12