Release 10.1A: OpenEdge Reporting:
Query/Results for UNIX

> ## Hiding repeating values and changing field formats and labels

> Table 3–5 briefly identify some of the report-related tasks you can perform, and identifies where you can find specific procedures in this section to perform these tasks.

> Table 3–5: Altering and changing report display data
> To... | See...
> --- | ---
> Access the information you need to change... | "Access the details you need to change" section.
> Hide repeating values, change field formats, and change field labels... | "Hide repeating values, and change field formats and labels" section.

> To perform the tasks noted in Table 3–5, you can use the Formats and Labels option on the Settings submenu.

> ##### Access the details you need to change

> Use the following procedure to access the information that you need to change.

> | To access the information you need to change:

> 1. Select Settings in the Report module.

> 2. Select Formats and Labels.

> 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.

> 3. Select the Name field.

> The Formats and Labels window appears.

> Continue with the procedure detailed in the "Hide repeating values, and change field formats and labels" section.

> ##### Hide repeating values, and change field formats and labels

> In the following procedure, you:

> - Change the label and format of the field.

> - Hide the repeating values. The purpose of hiding values that are repeated is so that the report displays each customer name and each order number once.

> | To hide repeating values, and change field formats and labels:

> 1. Type Customer Name in the Label field.

> Note: 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.

> 2. Change the value of the Hide Repeating Values option to yes, then press RETURN or GO:

> 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.

> 3. 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.

> 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 (!!).

> 4. Select the Line-num field, and change its label to Line!Num.

> 5. Select the Price field, and change its format to >>>9.99.

> 6. When the list of fields to pick appears again, press END to return to the Report Layout window:

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

> 7. Run this report on your terminal. 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.

> 8. Press END to return to the Report Layout window.

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