•  Preface
  • Purpose
  • Audience
  • Organization
  • Using this manual
  • Typographical conventions
  • OpenEdge messages
•  Results Overview
  • Results overview
  •  Database basics
    • The structure of a table
  • Indexes
  •  Table relationships
    •  Types of relationships
      • One‑to‑one relationship
      • One‑to‑many relationship
      • Many‑to‑many relationship
•  Results Basics
  • Before you begin
  • Putting your Results data to work for you
  •  Starting Results
    • Starting Results from a program group
    • Starting Results from the OpenEdge Desktop
  • Accessing the Results main window
  • Exiting Results
•  Query Basics
  • Before you begin
  •  Creating a query
    • Query creation overview
    • Details to create a query
    •  Record displays in multi-table queries
      • Sort order default
      • Relationship types default
  • Saving a query
  • Closing a query
  • Opening an existing query
  • Getting query information
  •  Printing queries
    •  Using print preview
      • Scroll bars
      • Navigation buttons
      • Keyboard
  • Deleting a query
•  Using Query Views
  • Query views overview
  •  Browse view
    • Navigating through records
    • Using frames
    • Modifying frame properties
  •  Form view
    • Navigating through records
    •  Modifying records
      • Updating records
      • Copying records
      • Creating records
      • Deleting records
    • Rearranging fields
    • Using frames
    • Modifying frame properties
  •  Report view
    • Adding cover and final pages, headers, and footers
    • Selecting page sizes
    • Adjusting report dimensions
    • Printing reports
  •  Label view
    • Selecting label types
    • Modifying label formats
    • Printing labels
  •  Export view
    •  Generating an ASCII file
      • Selecting an export type
      • Creating an ASCII file
    •  Modifying export types
      • Modifying strings
•  Changing the Query Selection Criteria
  • Adding and removing tables from a query
  •  Changing table relationships in multi-table queries
    • Types of table relationships
  •  Sorting records
    • Sort order and break groups
    • Specifying the sort order
  •  Creating filters
    • Data Selection
    • Query by example
    •  Using Data Selection to refine a query
      • Using Data Selection to create a WHERE clause automatically
      • Using Data Selection to create a WHERE clause manually
      • Setting Data Selection at run time
      • Removing a WHERE clause created using Data Selection
    • Using Query by Example to refine a query
    • Removing a WHERE clause created using Query by Example
  • Using the Data Governor
•  Analyzing Data
  • Overview
  •  Using Master and Detail sections to display records
    • Displaying composite records in one section
  •  Calculated fields
    •  Creating calculated fields
      • Adding a Percent of Total field
      • Adding a Running Total field
      • Adding a Counter
      • Adding a Stacked Array field
      • Adding a Lookup field
      • Adding a Math expression
      • Adding a String Function
      • Adding a Numeric Function
      • Adding a Date Function
      • Adding a Logical Function
    • Renaming calculated fields
    • Removing calculated fields
  •  Aggregate fields
    • Totals
    • Subtotals
    • Creating aggregate totals and subtotals
  • Using a Totals-Only Summary
•  Modifying Display Fields
  • Adding and removing display fields
  •  Changing display field properties
    •  Changing the format for a display field
      • Changing the format for a character field
      • Changing the format for a date field
      • Changing the format for a decimal or integer field
      • Changing the format for a logical field
•  Results Menus
  • Query menu
  • Table menu
  • Field menu
  • Data menu
  • Options menu
  • View menu
  • Help menu
•  Comparison Operators
  • Before you begin
  • Comparison operator details