Displays a list of field names from the selected data source.

Click the Define (calculator) icon to select: New define field, Edit define field, or Delete define field. If you select the New define field or Edit define field, the Define Field Creator dialog box opens where you can create or edit a defined field.

Displays a tree structure of field names by segment with segment, alias, title, description, and format information below the tree. Individual field information appears when you click on the field.

Displays a list of all field names with information that you select from the adjacent arrow that opens a list box: name, alias, title, format, description, segment, and file name. You can also choose to sort by file order.

Lists the following field display options:

The Add grand totals drop-down list provides two options. The Totals option displays the totals for each column. The Recompute Totals option recalculates computed fields before displaying the totals for each column.

Displays the total for each row.

Lists the vertical field that you have selected from the Available Fields window.

Indicates a report that aggregates data by the horizontal field.

Prints each value on a record-by-record basis.

Select the Master File attribute for which you want to search. The following table lists the pattern attributes and a description of each.

Type your search string. You can use an asterisk (*) as a wildcard. For example, type c* to find all fields that begin with the letter "c". The character string is not case sensitive.

Is the name of the application object.

Is the type of application object. For example, if the Type is BY it is a vertical sort field.

Check to hide the display of a Sort By field.

Opens the conditional styling dialog box where you use to add conditional styling in a report.

Is grayed out and unavailable.

Is grayed out and unavailable.

Inserts '.' when no field value exists.

Is the name of the field in the Sort By list box.

Click to arrange fields in ascending order.

Click to arrange fields in descending order.

Select:

• Create a page break (on value change).
• Separate (from next) with underline.
• Subtotal numeric sum/print fields.

Note:

This check box is unselected by default and enables a user to add a Ranking column.

This check box is grayed out by default and activated only if the Add Ranking column check box is selected. It enables a user to enter an integer value to select the number of ranked values to display in the report (5 is the default value).

The title of the ranking column can be changed from the default of RANK.

Specify the font, font size, font style, text alignment, text color, and background color of the subhead or subfoot.

Enter a subhead/subfoot in the text box.

Enter text to display for the subtotal.

Note: This sub tab appears when you select the Subtotal numeric sum/print fields option on the Sorting sub tab.

Check to hide the display of a Sort Across field.

Is grayed out and unavailable.

Is grayed out and unavailable.

Is grayed out and unavailable.

Is grayed out and unavailable.

Is the name of the field in the Sort Across list box.

Click to arrange fields in ascending order.

Click to arrange fields in descending order.

Check to temporarily hide the display of a Column field.

Opens the conditional styling dialog box where you use to add conditional styling in a report.

Make a selection from the drop-down list.

Inserts '.' when no field value exists.

Is the name of the field in the Columns list box.

Lists the domains and procedures that are available as drill-down reports. Click the procedure you want to execute.

Is the default.

The procedure you selected appears in this text box.

Enter the URL of a Web page that will open when a user drills down.

Once a parameter is created using the Add button, it is automatically added to this area.

You can place comments here.

Opens the drill-down parameter dialog shown in the following image.

Select from the list box.

Select from normal or bold, italic, underline, and various combinations.

Select a font size from the list box.

Set the style for Title & Data, Title only, or Data only.

Select a color from the color palette.

Select a color from the color palette.

Select left, right, or center from the list box.

Apply these styling conditions to all report fields.

Enter a name for the temporary field. Note that field names cannot exceed 66 characters.

Opens the field list in either tree or list mode.

Displays a list of predefined functions grouped into categories that include Character, Data Source and Decoding, Date and Time, Format Conversion, Numeric, and System. If you hover your cursor over a function, a brief description appears. The following image shows the list of predefined functions that populate the Field Creator dialog box when you select the Functions button.

Double-click the desired function to add it to the expression box in the Field Creator dialog box. In the expression box, replace each of the function’s arguments with the desired value or field name. Note that each of the available functions is a program that returns a value. For more information about functions, see the Using Functions manual.

To create an expression, double-click fields or functions, select items (operators, numbers, characters) from the Field Creator keypad, or type directly in the expression box.

Concatenates two or more alphanumeric constants and/or fields into a single character string. The concatenation operator has two forms: | (weak concatenation, which preserves trailing blanks) and || (strong concatenation, which moves trailing blanks to the end of a concatenated string).

Creates a conditional expression. A conditional expression assigns a value based on the result of a logical expression. The assigned value can be numeric or alphanumeric. IF, THEN, ELSE logic expressions take this form:

IF expression1 THEN expression2  ELSE expression3

ELSE is an optional operator. All alphanumeric values in conditional expressions must be enclosed in single quotation marks. For example, IF REGION EQ 'West'.

Used to create relational and Boolean expressions. A relational expression returns a value based on a comparison of two individual values (either field values or constants) and a Boolean expression returns a value based on the outcome of two or more relational expressions.

The following logical operators are available:

• adds the less than (LT) operator to the expression. This operator returns a value if the value on the left is less than the value on the right.
• adds the greater than (GT) operator to the expression. This operator returns a value if the value on the left is greater than the value on the right.
• adds the less than or equal to (LE) operator to the expression. This operator returns a value if the value on the left is less than or equal to the value on the right.
• adds the greater than or equal to (GE) operator to the expression. This operator returns a value if the value on the left is greater than or equal to the value on the right.
• adds the equal (EQ) operator to the expression. This operator returns a value if the value on the left is equal to the value on the right.
• adds the not equal to (NE) operator to the expression. This operator returns a value if the value on the left is not equal to the value on the right.
• AND returns a value if both operands are true.
• OR returns a value if either operand is true.
• NOT returns a value if the operand is false.

Click any of the arithmetic operators to use them in your expression: + (addition), - (subtraction), * (multiplication), / (division), ** (exponentiation).

Two operators cannot appear consecutively. The following expression is invalid:

a* -1

To make it valid, you must add parentheses:

a* (-1)

Adds quotation marks to the expression box. Use single quotation marks to enclose alphanumeric and date literals.

Converts entries in the expression box to uppercase. Note that field names are case-sensitive.

Choose:

• Alphanumeric
• Floating point
• Integer
• Decimal
• Packed
• Date
• Date-Time

Choose an available number based on the format type you chose.

Choose options based on the format type you chose.