Progress
Results User’s Guide
for UNIX


Hiding Repeating Values and Changing Field Formats and Labels

This section describes how to:

You can perform the above by using the Formats and Labels option on the Settings submenu.

  1. Select Settings in the Report module.
  2. Select Formats and Labels.
  3. A list of the fields in the report appears:



    This list shows the field labels in order as they appear in the report. Results lists the new field by the label you assigned to it. You can press MODE (F9) to toggle to the field names. Remember, the labels print in the reports, so you might recognize them more easily than the field names.

    It does not matter if you select the field from this label list or the field name list. They list the same fields, just under different names.

  4. Select the Name field.
  5. The Formats and Labels window appears.

    In the following steps, you change the label and format of the field. You also hide the repeating values.

    You can hide repeating values for most types of fields, including calculated fields. You cannot hide repeating values for a Totals field because all the values must appear in the report so that Results can total them.

  6. Type Customer Name in the Label field.
  7. Change the value of the Hide Repeating Values option to yes, then press RETURN or GO.
  8. The list of fields reappears, and you can select another field to edit.

    If the fields are listed by label, you see the field label you just changed in the list. However, the field names do not change because they are stored in the database. You can change the label, not the field name. The label displays on the report; the field name is the name the field is stored under in the database. Also, the labels in the Report Layout window do not change until you leave the option.

  9. Select the Order-num field, and enter Ord!Num as its label. Also, hide its repeating values by entering yes in the Hide Repeating Values? field.
  10. By entering the exclamation point (!) in this label, you stack the label on two lines. When you run this report again, Ord will be on the top line, and Num will be below it on the next line. If you want an exclamation point to show in your label, use two exclamation points (!!).

  11. Select the Line-num field, and change its label to Line!Num.
  12. Select the Price field, and change its format to >>>9.99.
  13. When the list of fields to pick appears again, press END to return to the Report Layout window.


  14. An ampersand (&) marks each field where you set Hide Repeating Values to yes.

  15. Run this report on your terminal.
  16. The first page of the report appears:



    In this report, you do not see repeating values for the Customer Name and Order-num fields. This makes it easier to see where the information changes for each order number and for each customer.

  17. Press END to return to the Report Layout window.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095