Macros

Macro is a special string that will be converted to exact value at the execution time. There is detailed information about available macros:

Macro Definition Available at
$DATE$ Current date. The presentation format can be changed via settings. SQL script, title, header, footer and report file name.
$DATE.YYYY$ Current year, 4 digits format. SQL script, title, header, footer and report file name.
$DATE.YY$ Current year, 2 digits format. SQL script, title, header, footer and report file name.
$DATE.MM$ Current month, 1 to 12. SQL script, title, header, footer and report file name.
$DATE.DD$ Current day, 1 to 31. SQL script, title, header, footer and report file name.
$TIME$ Current time. The presentation format can be changed via settings. SQL script, title, header, footer and report file name.
$TIME.HH$ Current hour, 0 to 23. SQL script, title, header, footer and report file name.
$FILE$ The report file name. All macros are resolved. Title, header and footer.
$FORMAT$ The report format: HTML, XML, Text, etc. Title, header, footer and report file name.
$QUERY$ The complete text of the SQL script. Title, header and footer.
$QUERYn$ Current SQL statement for multi-statements script or equals $QUERY$ for single statement. Header and footer
$NAME$ The first SQL statement name defined as a special comment. Header and footer
$NAMEn$ Current SQL statement name defined as a special comment. Header and footer
$ROWS$ Number of rows fetched by current SQL statement. For the preview it shows up to 50 preview rows, not an actual number. Footer
$STATEMENT$ Total SQL statements in the script Header and footer
parameter name Value of the parameter SQL script, title, header, footer and report file name.