Accountants Enterprise in Australia only
Heading variables can be used when you want a cell in a format to be able to display different values in the different columns generated by a column template.
When you add a heading variable to one column in a column template, it will automatically be added to all other columns in the template.
Click or .
Enter the Name by which the heading variable will be referenced in a format. By default, the heading variables will be named %HEADING1%, %HEADING2%, %HEADING3% and so on. These names can be edited if required.The name of a heading variable must begin and end with percentage signs (%). If you enter a name that does not begin and end with percentage signs, they will be inserted automatically.
Enter the Value/Formula that will be shown in the cell on the format or the formula used to derive the value. The contents of the Value/Formula field will be inserted into any cell in which the heading variable is referenced when this column is generated as part of a previewed report or format.
If the contents of the Value/Formula field are preceded by an equal sign (=), they will be evaluated as a formula and the results of the formula will be displayed in the preview.
If the contents of the Value/Formula field are not preceded by an equal sign (=), they will be displayed in the preview as text.
Enter the Style to apply to the heading. Style changes can be applied to a heading variable if you require the heading variable to be displayed with different formatting from the rest of the column.
To apply specific style formatting to a heading variable, click and make the required changes in the Column style dialog. The changes made here will override any style settings that have been specified for the column. When you click OK in the Column style dialog, the will change to to indicate that style changes have been made.
To undo the style changes and revert to the formatting of the column, right-click on and select Remove style. See Working with styles.
Style changes can be applied to a particular column within a column template, if you require the column to be displayed with different formatting than what might be specified in the Format Editor.
- Click . The Column style dialog opens.
Make the required changes.
The changes made here will override any style settings that have been specified in the Format Editor.
- Click OK. The contents of the Style field will change from Specified by cell to Altered for current column.
- Right click on the Style field and select Remove style.
The Repeat Lefthand columns item is visible if the Lefthand format columns item is selected in the Column Definition listing.
- Select the checkbox to have the contents of the Lefthand format columns appear on multiple pages, if the columns generated by the column template exceed one page.
- Click . When you remove a heading variable from one column in a column template, it will automatically be removed from all other columns in the template.
- Enter the name of the variable into a cell. Make sure that you precede the heading variable name by an equal sign (=). For example, =%HEADING1%.F1.