The selected fields will be represented as columns in the actual report. The column width, column title and other settings can be adjusted in the Settings section of the Report definitions and settings window.

Depending on the field type and the report type there are several variants of the Settings section. The different field settings are described in the following sections.

The column text indicates the name given to the column in the Selected fields section. In addition, the column text is also printed above the respective column in the report itself.

The field description is specified as the default. By enabling the Alternative column text option, you can type a different text in the Column text box, if required.

This read-only field displays the complete name of the selected field.

This is the column width, measured in centimeters. Specify the required value in the Width text box.

By selecting the relevant option in the Align field, you can specify whether to left align, right align, or to center the text in a report.

For date/time fields, numeric fields, dimension fields and money fields a mask can be specified. Masks help you to specify the way in which field values are displayed in a report. For example, a date can be shown in various formats, such as 01‑05-2017, 1-5-17 or 1 May 2017.

Depending on the field type, different mask pick lists are available from which you can select an example. The mask pick list can be opened by clicking the pick list button in the Mask field. However, the contents of the Mask field can also be entered or modified manually.

By using a mask you can determine how a number in a numeric field is displayed in a report. You can select an example from the Select a numeric mask pick list.

You can also enter or modify a mask manually in the Mask field. For a description of these fields, refer to Numeric fields.

You can use a mask to determine how a value in a dimension field is displayed in a report. Select the required mask from the pick list to display the unit of measurement (for length, area, volume or amount/area) after the value.

By using a mask you can determine how an amount in a money field is displayed in a report. You can select an example from the Select a mask for amounts pick list.

You can also enter or modify a mask manually in the Mask field.

You can specify the way the date and time is included in a report in the date and time fields. In some cases this depends on the Regional settings specified in your Microsoft Windows operating system. For more information, refer to your Windows documentation.

You can select an example from the Select a mask for dates pick list.

You can also enter or modify a mask manually in the Mask field. For a description of these fields, refer to Date-time fields.

This option can be used to group and sort data according to a specific field. If you select this option, the data will automatically be grouped. A heading is created for each new group.

This function can be used to sort (alpha) numerical data. You can set the sorting of data in ascending or descending order.

This option is only available if the Group by this column option is enabled. If this option is enabled, each group is started on a new page.

If this option is enabled a subtotal per group is placed at the end of a column. This applies to numeric fields and money fields.

To enable grouping totals, the following conditions must be met:

If this option is enabled, a grand total is placed at the bottom of a column. This applies to numeric fields and money fields.

To enable grouping under this column, the following conditions must be met:

This option can be used to specify whether to print a column. Under certain circumstances you may not want to print a column.

You have created an expression for a name. The expression is as follows: Initials + Prefix + Surname. You decide to sort by Surname. You can add an additional column for the surname, which you do not want to print.

For more information on expressions, refer to Working with Expressions.