As you probably know, Report Builder allows to use values from source wpDataTables as variables, and also values provided by users in front-end users. Additionally, there is a number of ‘fixed’ predefined variables.
You can use these variables in any report template, and they will be replaced with actual values:
- ${today} – Current date in the format that’s chosen in your WordPress settings.
- ${time} – Current time in the format that’s chosen in your WordPress settings.
- ${creator} or ${generatorname} – Currently logged in user’s “Display name”. Empty for non-logged-in users.
- ${sitename} – Name of the site, as defined in WordPress’ settings.
- ${reportname} – Name of current report.
- ${wdtrowindex.all} – Creates an index column in Word or Excel templates. An index column is a sequential numbering column that helps to identify the position of each row in the table. However, this feature is only available when a wpDataTables is selected as the data source. By choosing a wpDataTable, the index column will be automatically filled with the correct index values, ensuring that each row is properly numbered and inserted into the templates.
To see the list of rules on preparing templates click here.