You will find an overview of the available functions on the "Data and Functions" tab. You will also see an explanation of the currently selected function. The explanation informs you of the nature of the function and the type of the arguments that it expects (parameters).

If no arguments are given for a function, this means that the function does not expect any (apart from the empty brackets). Otherwise, the function expects exactly the number of arguments as shown. Arguments that appear in square brackets ([ ]) are optional, i.e. they can be omitted.

The argument "All" means that the argument can be any of the following types (Boolean, string, date, number, picture, barcode, RTF).

You will find a more detailed explanation of all functions and parameters under Overview of Properties.

 

The functions available on the "Data and Functions" tab are sorted alphabetically or shown by function group. There are the following function groups:

§ Numerical functions

§ Mathematic functions

§ Date functions

§ Character functions

§ Miscellaneous functions

§ Aggregate functions

§ Barcode functions

§ Conversion functions

§ Binary functions

§ Drawing functions

§ Project and print-dependent functions

§ Logical functions

§ Currency functions

 

You can filter the functions by means of the input field above the list of functions.

When you select a function, you are shown a short explanation in the information pane at the bottom. To add the function to the editing line, double-click the function that you want or use the "Insert" button.

Figure 10.10: List of functions with help text and tooltip