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

> ## Reports module main menu

> Horizontal menu options appear at the top of each window throughout your reports process, as shown in Figure 5–1.

> Figure 5–1: Horizontal menu for the Reports module

> In some cases you see a subset of these options. For example, you only see the options that are available when you do not have any files defined for a report in the Report Info window.

> The following list provides brief descriptions of all the options and submenu options available in the Reports module. For complete descriptions, see Appendix B "Option Descriptions." If you do not have all of the options listed here, see your database administrator.

> Get

> Retrieves an existing report definition into the Reports writer. You can get a report definition you have defined, or if you have permission, you can get a copy of a report definition from someone else’s directory.

> Put

> Saves an existing file definition under a descriptive name.

> Run

> Runs the report as it is currently laid out in the Report Layout window. You can preview the report on the screen, print it to a file, or route it directly to a printer.

> Define

> Defines files and fields to include in the report.

> Settings

> Controls general report settings, such as headers and spacing. Settings has these options:

> - Formats and labels — Changes field labels and formats for any field or defined column in the current report. This option also enables you to hide repeating values for fields, including calculated fields. However, you cannot hide repeating values for a Total field since all the values must appear in the report for Results to total them.
> - Page ejects — Starts a new page (inserts page breaks) for each new section of a report. For example, you can use page eject to start a new page each time the customer name changes in your report. Select the Page Ejects option and define a page eject on the Name field. You can only define page ejects on fields you use in an order definition. Therefore, you must define order criteria before you use this option to create page ejects.
> - Totals only report — Summarizes the report so it displays only summary information about groups of records.
> - Formats and labels — Changes field labels and formats for any field or defined column in the current report. This option also enables you to hide repeating values for fields, including calculated fields. However, you cannot hide repeating values for a Total field since all the values must appear in the report for Results to total them.
> - Page ejects — Starts a new page (inserts page breaks) for each new section of a report. For example, you can use page eject to start a new page each time the customer name changes in your report. Select the Page Ejects option and define a page eject on the Name field. You can only define page ejects on fields you use in an order definition. Therefore, you must define order criteria before you use this option to create page ejects.
> - Totals only report — Summarizes the report so it displays only summary information about groups of records.

> For example, if you create a report that lists customer records and puts the records in order by sales region, you can define this report as a Totals Only Report that shows a summary of sales regions. Thus, the report shows one line of information for each sales region, and the line contains the total of all the record information in the region. A dollar sign ($) marks the summary fields.

> To use this option, you must have an order definition for the report. Once you enable the Totals Only Report option, you pick the fields you want to summarize. When you summarize character, date, or logical fields, the system counts them. For all fields that are not summarized (not marked or Totals Only), the last record in that group appears.

> - Spacing — Specifies spacing for the report. This option enables you to spread out information to make it more readable.

> The Spacing option enables you to set the following values:

> —The width (in spaces) of the left margin.

> —The number of spaces to insert between columns.

> —The line to start on.

> —The number of lines to allow on each page.

> —The type of line spacing to use (in whole numbers).

> —The number of lines to leave between the header and the body of the report.

> —The number of lines to leave between the body of the report and the footer.

> - Left header — Defines up to three lines of left header information. A header is text, function, and field information that forms a title at the top of each page on a report.
> - Center header — Specifies up to three lines of centered header information.
> - Right header — Defines up to three lines of right header information.
> - Left footer — Specifies up to three lines of left footer information. A footer is text, such as a page number, that appears at the bottom of the page on a report.
> - Center footer — Inserts up to three lines of centered footer information. You can insert the same values as in the Left Header option.
> - Right footer — Inserts up to three lines of right footer information. You can insert the same values as in the Left Header option.
> Note: The special functions you can use in headers and footers are described in Appendix B "Option Descriptions." Also, when you define three types of headers (or footers) for a report, they print differently depending on the available header space. If there is enough room to fit all three values across, they print three across. Otherwise, the center header prints first, then the left and right headers appear on the next two lines.

> - First-page-only header — Defines a centered header that appears only on the first page of the report. If you have defined another type of header, the first-page-only header appears after it. The first-page-only header does not appear in the Report Layout window, but does appear when you print or display the report.
> - Last-page-only footer — Defines a centered footer that appears only on the last page of the report. If you have defined another type of footer, the last-page-only footer appears before it on the last page of the report. The last-page-only footer does not appear in the Report Layout window, but does appear when you print or display the report.

> Where

> Builds a `WHERE` clause enabling you to select a subset of records based on specific criteria. For example, you can select records where sales region equals central or east.

> Order

> Orders the information in the report by up to five fields. For example, you can define the records to print in order by sales region and by customer number within each sales region.

> You can use this option in conjunction with the Totals and Subtotals option to create totals for break groups (sections). For example, if you order customer records by region, you can provide a total line for each region. This total line divides the records for each region.

> Clear

> Clears the settings in the information and layout windows. Or, if there are no files or fields defined in the report, Results displays a list of defined reports. You can delete as many reports as you want.

> Info

> Displays more information about the current active report, such as the names of the current active files, how they are related, and any `WHERE` clauses and order criteria defined for the active report. It might also display the name of the report (if it has been saved), and how long it took to run the report the last time (if it has been run).

> User

> Transfers to a customized option. You only see this option if an application developer has included an option program to perform a task. If you have this option, see the documentation provided by the application developer.

> Module

> Switches to any other Results module (except Data Administration) without returning to the main menu.

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