Working with Fields

Field Types

There are nine field types that you can add to a report section. Fields are added using the Available Fields Palette, which is accessible by clicking the Field Palette icon on the top toolbar while on the section.

You can select three icons available at the top of this form:

	Label: Click this icon and drag it into the section to add a label to the report. This is used primarily to add report titles and general header/footer text, and to add column headings in the report body.
	Image: Click this icon and drag it into the section to add an image to the report. Images are typically used to add company logos, or similar to a report.
	Shape: Click this icon and drag it into the section to add a shape to the report. Shapes are useful if you want to highlight certain portions of the report, or put a border around a block of information (for example, a customer name & address block for an invoice report).

The remaining six field types are added using the tabs in the Available Fields Palette form. They are:

Database Fields

These are fields available in the database. When the report runs, database fields display the real-time system value for the field. They display in a class list and you can drill down and make selections to add fields of this type to your report.

When you are creating a new report, the database field list always open with the Company class as you can always build up your requirements using this as the source class.

Parameters

Parameters are set up using the Report Parameters form. If a field of this type is added to a report, the value of the parameter entered at runtime, or determined internally, prints on the report.

Calculations

Calculations are set up and edited using the tab on the Available Fields Palette form. Calculations enable you to determine values that are not actually stored in the database, and add these to the report.

Methods

Methods are used to retrieve a database value or collection that is not actually stored in the database. General report methods as well as those specific to the selected section display on the Methods tab and you can drag and drop a version of the method into the report section.

Others

Other field types are pre-defined based on standard information that is often required to display on reports, such as page numbers and a date/time stamp. These fields display in the Others tab and you can drag and drop the field into the report section.

Other fields available to add to a report include:

Company address fields
Company name
Company phone number
Date
Item count
Page number
Security mode
Time Stamp
Tree Branch Name (applicable if the report uses trees)

Totals

You can only select total fields using the Totals tab if you are positioned on a totals section, which is created when totalling options are selected for a section using the Section Properties form.

Field Manipulation

To resize a field, select it by clicking on it, and use the floating arrows to resize.

To move a field, select and drag it.

To remove/delete a field, highlight the field, click the arrow button at the bottom right side of the field, and select Remove this field.

To format a field:

Use alignment icons situated on the baseline toolbar.
Use formatting icons situated on the baseline toolbar.
Use formatting options accessible using the Field Properties form.

You can select a single field, or multiple fields by pressing the Shift key before applying a format.

Each field type has properties for it. To view field properties, double click the field or click the hand icon icon on the toolbar while on the field.