TRAINING
    Overview
    Delphi
Object Pascal
CBuilder
C programming
C++ programming
ReportPrinter
ReportSmith

CONSULTING
Overview

GTSIZER
Overview
Trial Versions
Ordering
Tips/FAQs
Users
Patches
Upgrades
 
 
 
 
 
 

Our three-day hands-on ReportSmith/SQL course is designed for users who want to create their own reports and selection statements. No prior knowledge of SQL required. Call 800-GENOTEX or to find out about scheduling this training for your group.
 

Overview of Relational Databases Relational Database Systems The ReportSmith Environment Workplace Window  ReportSmith Capabilities  Reports Description  Default Report Types  Columnar Report  Crosstab Report  Form Report  Label Report Custom Report Types Connecting to Data Sources Data Sources  The Connection Dialog Box  The Get Connection Dialog Box SQL Overview The SQL Language  Basic Concepts of SQL Defining and Populating SQL Tables Create Table Command  Null Values  Adding Rows to the Table Select, the Basic SQL Query Statement The Select Command Syntax  Retrieving the Entire Table  Sorting the Result  Rearranging the Order of Columns  Restricting Certain Columns  Removing Duplicate Rows Selecting Rows from a Table The WHERE Clause  Comparison Operators  Multiple Search Conditions  Alternate Search Conditions  Negative Search Conditions  Comparisons with Sets of Data  Range Searches  Matching Character Patterns

SQL Built in Functions Built-in Function Syntax  More on Built-in Functions SQL Calculations Calculations used in the WHERE Clause SQL Subqueries Grouping Rows with SQL Having Clause  Using the WHERE Clause Joining Tables with SQL Use of the Joining Feature  Joins for Multiple Row Results Enhancing Default Reports Modifying an Existing Report  Entering and Formatting Text  Selecting, Moving, and Resizing Page Setup Settings  Margins  Size and Orientation  Labels Report Background  Wallpaper Option  Object or Picture Option Using the Grid  The Align Toolbox  Customizing Numeric Fields  Borders Building Custom Reports Adding Tables  Selecting Table Columns  Sorting Fields  Column Alias  Building a Columnar Report  Building a Form Report  Building Mailing Labels  Building a Crosstab Report  Merging Two Reports  Creating a Graph Queries using Selections Dialog Box Selection Criteria Creating Report Variables