Tip :
This button is called an Ellipsis . It provides a search facility. Click on the button to search for the information that you require.
The most normal use of a letter style output such as provided by this facility is to produce a standard form letter and have specific information inserted from a data table.
In this way it would be possible to produce a credit chase letter for example, which would have a standard text content and then include specific account or balance information for each selected account.
In order to insert a column, position the cursor at the insertion point and click the Insert column button.
This will invoke an Insert column form into which a specific column can either be typed or, by clicking the Ellipsis button search facility, inserted automatically from familiar search windows.
When the search facility is used, you first select the table in which the required column resides, or select derived fields if either a standard derived field or user defined derived field is required.
This then presents an alphabetic list of the available columns within the selected table and individual entries can be selected as required.
Should you elect to type the column name directly into the window, then the normal convention of !Table id followed by the underscore character - and then the column name must be followed. For example if the column required was the account number and this was table number one on the Title tab, then the syntax !1_ACCOUNT would be used.
It is also possible to type in the column names directly onto the Format tab, as long as you follows the conventions regarding brackets and column naming.
In this instance, the column used in the above example would be typed into the format tab in the form {{!1_ACCOUNT}}.
Columns may be deleted from the format simply by positioning the cursor as appropriate and then using the delete key.
Many of you will find the Ellipsis button search facility convenient as it prevents minor typing mistakes that can cause compilation errors.
Once the format has been constructed, the report can be compiled saved and run as normal.
