OT2 Query Maker User Guide

      Introduction

      Features of OT2 Query Maker

 

Getting Started

      A Few Important Definitions

      Using Buttons

      The Query List Manager

      The Relationships between OT2 Query Maker's dialog screens

 

To Run an Existing Query

 

To Create a New Query

 

To Modify a Query

      The Query Overview Dialog

      The Filter Building Dialog

            What is a Condition?

            AND / OR Connectors

            Making the Right Connections

      Selecting Fields to Show in Query

            Selecting Output Fields: An Example

            Changing the Order of Output Fields

            Selecting Output Fields When the Query has been Selected Previously

      Picking Group and Summary Fields

            How to Group and Summarize

                  An Example

            Multiple Levels Of Grouping

                  An Example

      Sorting the Output Records

      Selecting the Type of Output

 

Creating Reports 

      Using the Report Setup Dialog

      Modifying a Report Form

            The Report Controls Toolbar

            Adding and Modifying Report Objects

            Notes on Selecting Objects

            Report Band Types

      Using the Title/Summary Dialog

      Creating a Detail/Summary Report

 

APPENDIX A: Another AND/OR Example

APPENDIX B: OT2 Query Reports Variables

      Constituents
      Service/Contacts
      Tree
      Cross Connects
      Cross Connect inspections
      ABC-LEM Query Variables