The formatting options available are different depending on whether you do a Group (Down the page) or Field (Across the page) report.

You can access all of these settings by from the Edit section of Reporting, by clicking the Format button. They will be either in the Page Settings tab, or the Layout tab.

Font settings

You can change the font settings for both listing report types. Click the Format button in the reporting window. In the Page Settings tab, there is a Report Font field. Click into this field and then click the Font button that appears in the right of the field. A new window will open with a variety of font style and size options for you to choose from.

Background

You can change the background colour for reports. Click the Format button, and then click the Shade button .

Header and Footer

Header and Footer options are available for both listing report types. Press the Format button in the Reporting window. In the Page Settings tab there are two fields labeled Header and Footer.

Make sure the Header/Footer checkbox is ticked, and then type the header and footer content into the fields.  Choose the font settings for the header and footer by clicking into the Font field below each text field.

Printer and Page setup

Click the Printer and Page setup button to change the printer settings, such as which printer the report is sent to, the paper size, orientation, and margins.

Column Proportions

To adjust the amount of space allocated to field labels, data and images, click and drag the column borders to the desired width.

If you are doing a Down the Page report, there are two checkboxes in this section for formatting images. By default images are to the side, clicking Images underneath will place images under field labels and data. Full Scale will include the full size image, as stored externally in your default images folder.

Separators (Group down the page reports only)

A separator is a horizontal line you can add between groups, rows and fields. For example, if are including the location history in a report, you can have a separating line between each row of the location history table in the report.

Extra blank line between data

Tick this checkbox to add extra spacing between fields.

Lines between columns

Tick this checkbox to add vertical lines between each column.

Page Breaks between records

Tick this checkbox to start each record on a new page.

Split records across page boundaries

By default, if a record is too large to fit on the remainder of the page, it will start on the next page. Tick this check-box if you are happy for records to be split across pages.

Sequentially numbered records

Tick this checkbox to number records down the left hand side of the page.

Grand Total (Field Across the Page reports only)

If you have added a Total or Average to a field/column in the report, the Grand Total box can add a description for the end value, e.g. "Grand Total" or just "Total". You may also like to bold or italicise the grand total, or start it on a new page.

Suppress Report Detail (Field Across the Page reports only)

If you add a Break-on with a Total, Average or Record Count to a report, this setting will hide individual record fields, and just display statistical data. For example, you may want to run a report on valuation by department, but do not require a list of all the objects and their individual valuations.

Record Count

Tick this checkbox to add a record total at the end of the report, or at the end of each section (when used in conjunction with a Break-on).

Group and Field Formatting in Listing Reports

The Group and Field Options window allows you to format a group of fields differently to the rest of the report. You can override the group heading, suppress field labels and row numbers, and set different fonts for the group. You can access these settings by pressing the Field Selection button in the Reporting window. Select the field you want and double click on it. Press the display button to the right of the window.

Group Option

The checkboxes in the Group Option section allow you to exclude/include the Group Name, Field Name, Field Row Numbers or all Labels (even where there is no data).

Row numbers are included when a multi-value field has more than one row of data.

Group Name Override (Group down the page reports only)

To override the Group Name, enter text in the Group Name Override Label box. This override will apply to the current report and will not have an impact anywhere else in the system.

Font (Group down the page reports only)

In the Font section, you can change the font of the Group Heading, Field Labels and Field Data. You can also specify different justifications for each of these aspects.

Alignment (Group down the page reports only)

In the Alignment section, you can change the alignment of the Group Name, Field Name, and Field Data. The default alignment is left.
 
Field Data Settings (Group down the page reports only)

In the Field Data Settings, you can override the field name/label and specify an alternative conversion. You can also divide fields in a group into subgroups, using the Aligned field.

To override the name of a field, enter text in the Override Label field. To apply an alternative conversion, enter the conversion in the Override Conversion field.

All fields to be grouped together should have the same number in the Aligned field, e.g. all '1's will be grouped together and all '2's will be grouped together.