Report Editor - Expression : Templates Help
The expression dialog offers a set of frequently used predefined code templates for the JavaSript expressions.
In order to insert it into the expression just double-click it in the list.
It has the following templates:
| Name | Template | Meaning |
|---|---|---|
| Column Number | report.columnNumber | Current column index |
| Column Count | report.columnCount | Total column count |
| Column Value | $F('column_name') | Value of a column from the source cursor |
| Database Name | report.datasource.databaseName | Used database name |
| Paper Format | report.designPaperFormat | Paper format for the report |
| Date | report.generationDate | Date representation |
| Date And Time | report.generationDateTime | Date and time representation |
| Day | report.generationDay | Day of the month (01-31) |
| Hour | report.generationHour | Hour in 24h format (00-23) |
| Minute | report.generationMinute | Minute (00-59) |
| Month | report.generationMonth | Month as a decimal number (01-12) |
| Month Name | report.generationMonthName | Full month name |
| Time | report.generationTime | Time representation |
| Week Day | report.generationWeekDay | Full weekday name |
| Year | report.generationYear | Year |
| Report Name | report.name | Name of the report |
| Page Count | report.pageCount | Total page count |
| Page Number | report.pageNumber | Current page index |
| Parameter Value | $P('parameter_name') | Value of a report's parameter |
| Record Number | report.cursor.position | Current record index |
| Record Count | report.cursor.recordCount | Total record count |
| SQL Expression | $E('ABS(column1 + column2)') | Value of a SQL expression (based on the source cursor) |