Step 9 - Add Evaluated Field Criteria

An evaluated field (selected as a display field from the Evaluated Field Table) is a way for the report to display user-defined literal text or display a specified field based on data held in another field.

Examples:

• The report should display "Full-Time" if FTE is 1.0 and "Part-Time" if FTE is less than 1.0:

• Report Output:

• The report should display the actual FTE if it is less than 1.0; otherwise, "full-time" should display.

• Report Output:

Note: the field being evaluated must be included in the report as a selection or sort field (if as a selection field, the selection criteria can be left blank).

Adding Masks to Evaluated Fields:

Masking can be added to evaluated fields. An example of this would be creating a birthday report but wanting to show just the birth month. Entering a mask will alter the resulting value of this evaluated field. A mask will display just a portion of the resulting value.

For example, if a date is formatted to Wednesday 01-Jan-2010, a mask of +++ to display just Wed could be used. 

There are two special characters that can be put in a mask. They are: + (plus sign) and - (minus sign): 

A plus sign will display (add) the character in the matching position, while a minus sign will remove the character in the matching position. A space (or lack of any character) will act as a minus. 

If the resulting value of the evaluated field is the word TEST, a mask of ++ (in the first two characters of the mask) would display TE, while a mask of --++ would display ST. 

Additionally, three KEY PHRASES can be used. They are: LEFT OF, RIGHT OF, or RIGHT OF LAST. 

Each of these phrases expects a character after the phrase, i.e. LEFT OF - will display everything to the left of the hyphen. RIGHT OF, will display everything to the right of the period. RIGHT OF LAST, will display everything to the right of the last period. Any other character in the mask will be treated as a literal and will be added to the resulting value.

Examples:

Adding Font Types and Colour to Evaluated Fields:

Keywords can be added to the Evaluated Field Mask field to allow the font type and/or font colour to be altered. All Keywords must be wrapped in curly brackets {} e.g. {BOLD} or {ALICE BLUE}.