Skip to Content

Reports editor document types

2116  Reports Editor, Reports Editor

Two document types are available in the Reports Editor : List and Pivot table. Use the buttons at top right to select the type you require.

List

When you choose the List type, the editing area presents three rows named Title, Format and Grand Total. The fields you place in this area appear as columns.

The available fields depend on the base file. They appear in the lower part of the window. To place a field, simply double-click on its name or drag it into the editing area.

Title

This line is repeated in the header of each report page. By default, the program places the field names here, but you can modify them.

Above this line, field names (preceded by the name of the file to which they belong) are displayed but cannot be modified. This allows you to identify them even if you have modified their name in the Title line.
Format

This line contains information taken from the records, and is repeated in the report for each record in the selection. It can be assigned a display format according to the type of data represented.
Grand Total This line is intended for summary calculations of column values.

For each field for which you request sorting (by entering it in the Sorting order field), an additional line is displayed in the report:

Subtotal A subtotal line is used to display intermediate calculation results for the set of records determined by sorting a field (or a calculated column).

Pivot table

A pivot table is useful when you want to display data divided into categories, themselves a function of two other data sources.

The table that is displayed can be understood as follows:

  Data source (horizontal) Last column label
Data source (vertical) Field, calculation Grand total cell
Last row label Grand total cell Grand total cell
Data source

These two cells contain the fields used for the two pivot table categories.

The available fields depend on the base file. They appear in the lower part of the window. To place a field, simply double-click on its name.
Field, calculation The central cell, located at the intersection of the two cells above, can accommodate a field reference and calculations.
Grand total cells These cells are used for summary calculations of column values.
Labels

These cells contain the titles of the last column and row in the table. These labels can be modified.

 

 
Reports editor document types