Defining Report Field Attributes

Use this procedure to define report field attributes.

To define report field attributes

  1. On the Report Format form, select or define a field.
  2. In the Report Field Definition window, change the desired field attributes.

    The fields displayed depend on the type of report field you are defining.

    In this field Type or Select (F4)
    Print

    Value to print the value of the field.

    Translation to print the translation, or meaning, of the value of a field. This is an option only if you defined a translation for the field in the database.

    Subscript to print the occurs value of an array field. This option is for array fields only. On array fields, the number of times an array field occurs displays in the upper right corner of the Report Field Definition window. To display this value on the report, select Subscript in the Print field. The field type changes to Subscript.

    Note: If there is only one print option for the selected field, you cannot access the Print field.
    KeyDups

    KeyDups to print the value of the key field on every line, if the value of a key field repeats itself on consecutive lines of a report.

    NoKeyDups to print the value of the key field only the first time it appears.

    Size

    The field size, if desired.

    The value of this field comes from the database definition of the field. You can change the value for the report.

    If you decrease a field size, the report truncates the value. For an explanation of how the field truncates values, see the Size definition in Report Field Attributes.

    # Decimals

    The number of decimal places (applies only to signed, percent, and currency fields).

    The default from the database definition of the field can be changed for the report.

    If you decrease a field size, the report truncates the value. For an explanation of truncated values, see the Size definition in Report Field Attributes.

    Commas Commas or No Commas, specifying whether to print commas on a numeric field.
    Dollars Dollars or No Dollars, specifying whether to print a floating dollar sign on a numeric field.
    Percent Percent or No Percent, specifying whether to print a percent sign after a numeric field.
    Zeroes

    One of the following options for displaying zeroes in a numeric field.

    • Sup Lead 0 to not display leading zeroes. If the field is blank, this option displays a single zero.

    • Dsp Lead 0 to display leading zeroes.

    • Blank When 0 to display blanks if the value of the field is zero and to not display leading zeroes.

    Sign

    -Sign to display a negative sign (-) after negative values.

    CR Sign to display CR (for credit) after negative values.

    Paren Sign to display negative values in parentheses.

    No Sign does not differentiate between positive and negative values.

    Picture Display only. A picture of how the field looks on the report. Changing any of the field definition items also changes the appearance of the Picture field.
  3. Press Define (F6) and choose the desired option from the Print Condition window. You can define a print condition on a field, making the report print the field only when it satisfies the condition.
    • To add a new condition or select an existing condition, choose Select.

    • To replace a condition with a different condition, choose Select Replacement.

    • To change a condition, choose Modify Current.

    • To delete a condition, choose Delete Current.

    When you define a condition on a field, the condition name appears in the Under Print Condition field, and the condition appears under the Report Field Definition window.

    For further instructions, see Defining Conditions for Objects.

  4. Press OK.

    The field appears on the Report Format form.

    To label or move the field, see Labeling, Moving, and Deleting Fields.

  5. Press OK twice to save the report form.

    The system saves the form and returns to the Database Structure-Program Structure form.