Cost Register Report Body Fields
The Cost Register report body contains data which relates to individual cost items rather than general data such as unit prices or tax rates. The report body can contain cost fields and non-cost fields. A cost field is a field containing a cost value, or some quantity that can be directly related to a cost value, such as labor hours. A non-cost field is any field, such as the Cost Item Name field, which does not contain cost values.
The Cost Register Designer Report Fields page allows you to controls all aspects of the fields included in the report. This page has two operating modes - Report Body and Header Block. Ensure the Report Body button at top left of the page is depressed in order to work on the fields in the main body of the report.
Field control is the process of specifying which fields are to be included in your report and in what order.
Adding a New Cost Field
Use the Add Cost Field button to add a new cost field.
Modifying an Existing Cost Field
Select the cost field in the main display box, then click on the Change Cost Field button.
Click on the Non-Cost Fields button to add non-cost fields. Non-cost fields are selected in a two-part process. In step one you select the general field category, in step two you select the specific field within that category.
Deleting a Field
Select the field to be deleted, then click on the Delete Field button.
Changing Field Positions
The left-to-right order of the fields in the report will be the same as the top-to-bottom order of the fields shown in the main display area. Select a field and use the Move field up/down arrows to change its position.
The title at the top of the column occupied by each field in the report will, by default, be the field name as shown in the main display box. However, you can change this to a title of your own choice by typing that title into the Column Title box above the main display area.
Each field has a software-defined default width. Enter a new value into the box in the Column Width frame to change this for the current report configuration. You may enter widths in centimeters or inches by selecting the appropriate value in the Units frame at top left of the form. The width of each column can be shown in the main display area by clicking on the Show column width box in the Field Control frame.
This frame also shows the overall report width, which will be either the header block width or the report body width, whichever is greater, and the scaling that will be required to fit the report into a single sheet width when printing it. (Cost register reports are always compressed on printing into a the width of a single sheet, although they may occupy multiple sheets lengthwise.) To maintain readability it is recommended that you keep the scaling factor at not less than about 80%.
Field formatting involves specifying how a particular field is to look in the report.
Text wrap is the process whereby a long text entry is wrapped onto a new line if it cannot all fit onto a single line. You may control the text wrap property of each field individually. It is recommended that you do not use text wrap for cost or date fields. If data does not fit into a single line in these cases, increase the field width or reduce the font size.
You may control the horizontal alignment (left, center, or right) of each field individually. You can show field alignments in the main display area by clicking on the Show alignment box in the Field Control frame.
You may select the number of decimal places to be shown with each numeric field individually.
You may select the text color, background color, font size and bold/italic/underline characteristics of each field individually. Note that conditional formatting will override normal field formatting.
Select the field you wish to be conditionally formatted, then click on the Conditional Format button in the Field Control frame. If a conditional format already exists for this field, this button will turn red when you select the field.