Level 1

• The Basics
  • Launching Crystal Reports
  • The Application Window
  • Exploring Sample Reports

• Creating a Simple Report
  • Using the Create Report Expert
  • Previewing the Report
  • Designing a Report from Scratch
  • Inserting Fields
  • Browsing Field Data
  • Moving & Sizing Report Objects
  • Placing Text Objects on the Report

• Managing Reports
  • Saving a Report
  • Closing a Report
  • Modifying a Report Description
  • Opening an Existing Report
  • Switching Between Open Reports

• Getting Help
  • On-line Help & Searching for a Help Topic
  • Context-Sensitive Help
  • Printing a Help Topic
  • Seagate Software on the Web

• Selecting Records
  • The Select Expert
  • Using Saved versus Refreshed Data
  • Expert Options
  • Criteria Based on More than One Field
  • Removing a Report Selection

• Sorting, Grouping, & Summarizing
  • Sorting Records
  • Grouping Records
  • Working with Group Trees
  • Deleting & Changing Groups
  • Inserting Summary Calculation
  • Defining Other Summary Calculations

Level 2

• Reports Based on More than One Table
  • Using the Create Report Expert
  • Modifying a Report Created with the Expert
  • Building a Multi-table Report without the Expert

• Enhancing Your Report with Formatting
  • Changing the Font of a Text or Field Object
  • Adding Borders & Drop Shadows
  • Formatting Numeric Data
  • Changing Object Alignment

• Utilizing Conditional Formatting
  • Absolute Formatting
  • Conditional Formatting
  • The Highlighting Expert
  • Modifying & Deleting a Conditional Format

• Creating Formulas with Crystal Syntax
  • The Formula Editor & Inserting Formulas
  • Changing Numbers to Words
  • String Manipulation
  • Date Calculations
  • Creating Summary Calculations & Totaling By Group
  • Working with Running Totals
  • Running Sums
  • If-Then-Else Formulas

• Creating Formulas with Basic Syntax
  • Creating Formulas & Entering Code
  • Adding Comments

Level 3

• Parameter Fields
  • Creating Parameters Fields
  • Working with Multiple Parameter Fields
  • Adding a Parameter Field to a Printed Report
  • Deleting Parameters

• Formatting Report Sections
  • Changing the Size of a Section
  • Sizing a Section Automatically
  • Inserting & Deleting Lines
  • Using the Selection Expert

• Advanced Grouping Techniques
  • Grouping & Sort Direction & Custom Groups
  • Sorting within a Group
  • Grouping on Intervals

• Finishing Touches
  • Using the Style Expert
  • Creating Special Fields
  • Special Text Object Features
  • Working with Lines & Boxes
  • Adding Pictures to Your Report

• Including Cross-Tabulations in Your Reports
  • Creating a Cross-Tab Report Using the Cross-Tab Expert
  • Creating a Cross-Tab Report without an Expert
  • Modifying the Data included in a Cross-Tab Report
  • Formatting a Cross-Tab Report

Level 4

• Summary Reports
  • Building a Summary Report
  • Allowing or Disallowing Drill-downs

• Running Totals Reports
  • Creating Running Totals Overall
  • Creating Running Totals for a Group
  • Creating Conditional Running Totals
  • Creating Running Totals with a One-to-Many Relationship

• Top N
  • Creating a Report with the Top N Values
  • Creating a Report with the Bottom N Values

• Working with Subreports
  • Creating an Unlinked Subreport
  • Creating a Linked Subreport
  • On-demand Subreports

• Advanced Record & Group Selection
  • Setting up Group Selection
  • Creating a Record or Group Selection Formula

• Mailing Labels
  • Creating Mailing Labels
  • Modifying the Attributes of Mailing Labels

• Form Letters
  • Creating a Form Letter with the Expert
  • Modifying Attributes of a Form Letter
  • Creating a Form Letter without the Expert
  • Customizing a Form Letter for Different Recipients

Level 5

• Working with Data
  • Databases Overview
  • Aliases
  • Indexes
  • Relationships
  • SQL & SQL Databases
  • Server-side Processing
  • Mapping Database Fields
  • Working with Different Types of Data
  • Advanced Database Features
  • Reporting on the NT Event Log
  • Reporting on Exchange or Outlook Data

• Using SQL
  • What is SQL? & Creating a Report Based on an ODBC Datasource
  • Building a SQL Query
  • Modifying SQL Options

• The Crystal Query Designer
  • Why Use a Query
  • Creating a Query
  • Modifying the Query
  • Creating a Report from a Query
  • Basing a Query on a Query

• Creating a Data Dictionary
  • Why Use a Data Dictionary?
  • Creating a New Data Dictionary
  • Basing a Report on a Dictionary
  • Setting Dictionary Options

Level 6

• Advanced Formula Techniques
  • Creating a Complex Formula
  • Using a Variable
  • Assigning a Value to a Variable
  • Using Arrays in Formulas
  • Using Ranges in Formulas
  • Debugging Formulas

• Charting Your Report Data
  • Creating a Group Chart
  • Creating a Detail Formula Chart
  • Creating a Cross-tab Chart
  • Modifying Chart Options
  • Drilling Down on a Graph
  • Re-entering the Chart Expert
  • Using a Graph Template

Level 7

• Mapping
  • Mapping on Grouped Fields
  • Modifying Map Attributes
  • Mapping on Detail Fields
  • Mapping on Cross-tab Summaries
  • Using the Map Analyzer

• OLE
  • OLE Introduced
  • Adding OLE Objects to a Report
  • Working with Static OLE Objects
  • Embedded vs. Linked Objects

• External Data Sources
  • Dbase/FoxPro
  • The File System
  • NT Event Log
  • Exchange
  • Outlook

• Distributing Reports
  • Exporting a Report
  • Mailing a Report

• Distributing Reports Over the Web
  • Saving a Report as HTML
  • Crystal Web Report Server
  • Building Active Web Sites

• Integrating with Visual Basic
  • The Crystal Report Engine API
  • Crystal ActiveX Controls