Level 1
Course Introduction
1.0 Understanding Crystal Reports
Quiz
2.0 Before we Build Reports
2.1 Reviewing a sample report design
2.2 Previewing report data
2.3 Setting default options
2.4 Section Review
Exercises
Quiz
3.0 Building a Report
3.1 Creating a report
Simulation -~ How To Create A Report
3.2 Adding Fields
3.3 Re-sizing and moving fields
3.4 Adding Titles and other Special Fields
3.5 Saving The Report
Exercises
Quiz
4.0 Sorting and Filtering
4.1 Finding records
4.2 Sorting Records
4.3 Filtering records
Simulation -~ Create a Filter With One Criteria
Exercises
Quiz
5.0 Grouping
5.1 Building Groups
Simulation -~ Grouping: Navigation Shortcuts
5.2 Adding summaries
5.3 Formatting Groups
5.4 Adding groups and changing group order
5.5 Group Filtering
Exercises
Quiz
6.0 Working w/ Basic Formulas
6.1 Using the Formula Workshop
Simulation -~ Basic Formulas: Using the Formula Workshop
6.2 Building a Basic Math Formula
6.3 Using a Basic Text Formula
6.4 Using Formulas in Grouping
Exercises
Quiz
7.0 Help Section
7.1 Using the Help Features
7.2 Workbench
Quiz
Level 1 Conclusion
Post Course Exam
Level 2
Course Introduction
1.0 Advanced Formulas
1.1 Using Formulas in Record Selection
1.2 Using IF, THEN, ELSE Statements
Simulation -~ Using the If Statement
1.3 Conversion Functions
1.4 Using Select Case Statements
1.5 Section 1 Summary
Exercises
Quiz
2.0 Parameters
2.1 Building a Parameter
2.2 Using Dynamic Parameters
Simulation -~ Parameter Fields
2.3 Section 2 Summary
Exercises
Quiz
3.0 Formatting Sections
3.1 Adding a Watermark
3.2 Basic Formatting
3.3 Conditional Formatting
3.4 Conditional Data Display
3.5 Controlling Display Drill-Downs
3.6 Section 3 Summary
Exercises
Quiz
4.0 Working with Charts
4.1 Creating a Chart
4.2 Formatting Charts
4.3 Modifying Charts
4.4 Creating a Chart by Group
4.5 Section 4 Summary
Exercises
Quiz
5.0 Exporting Data
5.1 Exporting to Adobe PDF
Simulation -~ Adding Charts
5.2 Exporting to Excel
5.3 Exporting to the Web
5.4 Setting Report Definitions
5.5 Section 5 Summary
Exercises
Quiz
6.0 Using the Report Wizard
6.1 Building a Standard Report
Simulation -~ Standard Report Wizard
6.2 Building Mailing Labels
6.3 Formatting Labels
6.4 Section 6 Summary
Quiz
Level 2 Conclusion
Post Course Exam
Level 3
Course Introduction
1.0 Working with Running Totals
1.1 Creating
1.2 Creating Conditional Running Totals
1.3 Creating Running Totals by Group
1.4 Section 1 Summary
Exercise
Quiz
2.0 Utilizing Variables and Arrays
2.1 Using Variables
2.2 Project: Credit Rating
2.3 Project:Troubleshooting
Simulation -~ Credit Rating Formula Using Variables
2.4 Using Arrays
2.5 Section 2 Summary
Quiz
3.0 Report Processing
3.1 Building a Group Summary Report
3.2 Reviewing Report Processing
3.3 Section 3 Summary
Exercise
Quiz
4.0 Working with Cross-Tab Reports
4.1 Building Cross-Tab Reports
Simulation -~ Cross-Tab Report Wizard
4.2 Formatting Cross-Tab Reports
4.3 Cross-Tabs in Groups
4.4 Section 4 Summary
Exercise
Quiz
5.0 Utilizing Sub-Reports
5.1 Building an Unlinked Sub-Report
5.2 Building a Linked Sub-Report
Simulation -~ Sub Reports
5.3 Sharing Data b/w Main Report and Sub-Report
5.4 Building On-Demand Sub-Reports
5.5 Section 5 Summary
Exercise
Quiz
Custom Groups
5.1 Grouping by Formula
5.2 Combining Groups
5.3 Section 6 Summary
Exercise
Quiz
Level 3 Conclusion
Post Course Exam
Level 4
Course Introduction
1.0 ODBC Drivers
1.1 Creating a Connection
Quiz
2.0 Inner vs. Outer Joins
2.1 Changing the Join in a Report
Simulation -~ Changing the Table Join in a Report
2.2 Tip: Checklist for finding missing data in a report
2.3 Section 2 Summary
Exercise
Quiz
3.0 Intro to SQL w/ Crystal Reports
3.1 Reason for Using SQL
3.2 Building a Report Using SQL
Simulation -~ Building a Report Using SQL
3.3 Using the WHERE Clause
3.4 Using Aggregate Functions in SQL
3.5 Aliasing
3.6 Using a Subquery in a Report
3.7 SQL Expressions
3.8 Tip: Showing the SQL Used to Build a Report
3.9 Section 3 Summary
Exercise
Quiz
4.0 Updating/Verifying Data Sources
4.1 Adding a Table to a Report
Simulation -~ Setting Up a Template
4.2 Setting a Datasource Location
4.3 Verifying a Database
4.4 Section 4 Summary
Quiz
5.0 Report Alerts
5.1 Setting and Using Alerts
5.2 Using Alerts with Parameters
5.3 Section 5 Summary
Exercise
Quiz
6.0 Templates
6.1 Using a Pre-Built Template on a Report
6.2 Setting up a Template
Simulation -~ Using Templates
6.3 Setting up a Chart Template
6.4 Bonus: Creating a Custom Function
6.5 Section 6 Summary
Quiz
7.0 Tips and Tricks
Level 4 Conclusion
Post Course Exam
| 