Actions Report Fields
The Report Fields page of the Actions Report Designer allows you to select which fields you want to include in your report, and how they are to be formatted.
Actions report fields are divided into action fields, non-cost fields, and cost fields.
Action fields are fields directly related to actions, such as the action description field.
Non-cost fields are fields, other than action fields, which are associated with cost items and are not cost-related, such as the cost item number or name fields
Cost fields are fields associated with cost items, and which contain a cost value or some quantity that can be directly related to a cost value, such as labor hours.
Adding an Action Field
Use the Action Field button to add an action field.
Adding a Non-Cost Fields
Use the Non-Cost Fields button to add a non-cost field. These are selected in a two-part process. In step one you select the general field category, in step two you select a specific field within that category.
Adding a Cost Field
Use the Cost Field button to add a cost field. Fields are selected using the Cost Field Definition form.
Deleting a Field
Select the field to be deleted, then click on the Delete Field button.
The title at the top of the column occupied by each field in the final report will, by default, be the field name as shown in the main display box. You can alter the column title by selecting a field and typing a new title into the Column Title box above the main display box.
Changing Field Positions
The top-to-bottom order of the fields shown in the main display box is the same order as the fields will have left-to-right in the final report. Select a field and use the Move field up/down arrows to change its position.
Select the field you wish to be conditionally formatted, then click on the Conditional Format button. If a conditional format already exists for this field, this button will turn red when you select the field.
Each field has a software-defined default width. To change this width, enter a new value into the width box in the Column Width frame.
This frame also shows the overall report width and the scaling that will be required to fit the report into a single sheet width when printing it. For readability purposes you should not let the scaling factor go below about 80%.
Text Wrap and Alignment
You may control the text wrap and alignment of each field individually.
You may individually select the number of decimal places to be shown with each numeric field. This normally applies only to cost fields.
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.