Insert static or dynamic texts on the print page. Selecting the entry Text [..] opens a dialog for entering text.
Input of any one or more lines of text.
Text from query result based on a table
If objects have been selected in the map window, database attributes for an object can be inserted as text on the print page. The matching SQL statement is entered in the text field for this purpose.
Example: Parcels are selected in the map window. In a text field, a SQL statement (SELECT ...) is entered. As soon as the layout is created, the SQL statement is executed and the values are determined from the table - per selected object, so it also works in the case of several previously selected objects in the merge. The values will be inserted as text on the print page to the chosen text position (1 - 12).
The condition for the SQL statement is that only one column is returned per text. So no comma may be included as a column separator. Multiple columns can be connected with "+" or "&".
The FROM clause at the end of the SQL statement is optional. If a table is specified, a corresponding message appears before execution, unless the selected objects are from this table. If no FROM clause is specified, it checks to see if the SQL statement contains consistent columns.
SQL statements may also be more complex and produce a multi-line result.
Result on the print page
Font type and font size
The default font is set with the button in the middle of the Options dialog box. On the input dialog of each text, the font can be set to very small, small, normal (default), large or very large.
A new line in the input field is obtained by pressing the key combination Ctrl + Enter. This also works with a SQL text (see example). Alternatively, instead of the line break, the well-known ASCII code + str$(10) can be used in the SQL text.