Use a text object to add a title to the report. Text objects let you place text in the workspace. As well as fixed text, you can also insert the contents of fields (variables) from the database (e.g. company name), or you can use functions (page number, date etc.).
1. In the "Objects" toolbar, choose the "Text" object type.
Figure 2.7: "Objects" toolbar
2. In the workspace, hold down the left mouse button and pull the object to the required size.
3. The formula wizard will now appear which you can use to define the contents of the text object.
This dialog consists of a series of tabs each containing different elements to be edited. The following chapters explain the meanings of these elements in more detail.
§ Variables and Functions: the available variables, fields and functions.
§ Condition: for defining IF-THEN-ELSE conditions.
§ Text: for entering fixed text and tabs.
§ Date Format: different date formats.
§ Number Format: different number formats.
§ Operators: available conjunction operators.
You can also enter the expression that you want directly in the edit box or modify the text that is there (e.g. put something in brackets).
Therefore, enter our title "List of products" directly. Fixed text must be enclosed in quotation marks. Enter names of variables and functions without brackets.
Figure 2.8: Text in the formula wizard
Note: Please note that there are two ways of writing expressions, depending on their use. You will find more information about this in the chapter Variables, Formulae and Expressions.
4. The title will be displayed when you close the dialog with OK.
5. Enlarge the letters by changing the font size in the mini toolbar that appears automatically.
Figure 2.9: Formatting menu in mini toolbar
6. You have now added the title:
Figure 2.10: Report with text object