Manage

The Manage tab enables you to save query or report definitions, run (execute) and print defined queries or reports, and delete query or report definitions. To access this tab, you must be authorized to use the Query/Report Generator.

From the Manage tab, you can:

Save Report: Save new reports, save changes to existing reports, and save changes to an existing report under a new name (and retain the previous version)
Run Report: Run a report: Execute the report and send the output to a printer or file. You cannot close the Query/Report Generator screen while the system retrieves the data. The data is organized according to the format specified on the Layout tab.

Quick View Query: Perform a quick-view query: Display the data included in a report. Quick-view queries use the FASuite default format: one blank column between data items and default titles for the columns. Layout instructions are ignored and report titles, page breaks, subtotals, and section breaks are omitted for defined groups. Column names are used for column headings and column heading length is limited to the width of the data in each column.

Data is sent only to the screen; quick-view queries cannot send data to a printer or a file. Use quick-view queries when you are more interested in the data values rather than how the data is formatted on the screen.

Once you perform a quick-view query of a report, the report definition information appears on all the tabs of the screen and you can view or update it.
Delete Report: Delete a report: In addition to the Query/Report Generator, you can use Web Modules or any other reporting tool sold separately (such as Microsoft Access) that can attach to the database. Refer to the related documentation for these products.

Data in the fields on the bottom section of this tab enable you to perform management tasks for the report. Unless otherwise indicated, these fields are required.

Report name

The name of the report currently selected in the grid’s list box or that you are designing.

Description

Description of the report in the Report name field. This field is optional.

Lines per page

Number of lines this report prints on each page. Defaults to 50.

Stored procedure

Name of the stored procedure to run to produce data for the report. You must specify the parameters necessary to run the procedure in the Stored procedure information field on the Queries/Reports -> Report Preparation/Management screen.

Stored procedures must follow specific conventions. For example, to run cost analysis reports, type EQ_COST_REPORTS_PREPARE. To delete cost analysis reports, type EQ_COST_REPORTS_DELETE. Contact Technical Support for more information.
See also Oracle stored procedure-dependent reports.

Output destination

Name of the print queue or path and file name to which the query or report output is sent. If this field is blank, the output displays in the bottom window.

_______________

Manage

See Also