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

> ## Putting your Results data to work for you

> Results is a software tool that allows you to create queries to search for specific data in one or more databases. Once the query accesses the data, you can use a variety of query views to display and update the data, generate reports and mailing labels, or export the data to other applications. Table 2–1 lists the available query views.

> Table 2–1: Query views
> View | Purpose
> --- | ---
> Browse | Lists records online in a tabular form similar to a spreadsheet. You can scroll forward and backward through the data.
> Report | Creates multi-line and master-detail reports for printing. Provides calculated values and totals for thorough data analysis. You can control the formatting of the headers, footers, and page breaks.
> Form | Allows you to view, update, add, and delete individual records in the database.
> Label | Formats and prints records in a variety of label formats, including mailing and inventory labels.
> Export | Formats records to export to other applications.

> Results is flexible. Instead of presenting you with a predetermined set of queries, Results lets you define and save queries that suit your particular needs. You can query all the records in a particular table or you can query any number of fields in one or more related tables. If, for example, your database contains Customer and Order tables and these tables are related, you can instruct Results to find all the orders for each customer in the database.

> Results provides you with a filter to refine the contents of your queries. For example, you can use a filter to refine the previous query to find all the orders for each customer in Massachusetts.

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