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
|
