Crystal Reports XI Essentials Course Outline
Crystal Reports XI Essentials: Level 1
1.0 The Basics
1.1 Launching Crystal Reports
1.2 The Application Window
1.3 Start Page
1.4 Workbench
1.5 Setting Options
1.6 Exploring Sample Reports
1.7 Report Explorer
1.8 Design Mode
1.9 Preview Mode
1.10 Field Explorer
2.0 Creating a Simple Report
2.1 The Standard Report Creation Wizardv
2.2 Designing a Report from Scratch
2.3 Inserting Fields
2.4 Browsing Field Datav
2.5 Moving & Sizing Report Objects
2.6 Placing Text Objects on the Report
3.0 Managing Reports 3.1 Saving a Report
3.2 Closing a Report
3.3 Modifying a Report Description
3.4 Opening an Existing Report
3.5 Switching Between Open Reports
4.0 Getting Help
4.1 On-line Help & Searching for a Help Topic
4.2 Context-Sensitive Help
4.3 Printing a Help Topic
4.4 Business Objects Web Resources
5.0 Selecting Records
5.1 The Select Expert
5.2 Using Saved versus Refreshed Data
5.3 Expert Options
5.4 Criteria Based on More than One Field
5.5 Removing a Report Selection
6.0 Sorting, Grouping, & Summarizing
6.1 Sorting Records
6.2 Grouping Records
6.3 Working with Group Trees
6.4 Deleting & Changing Groups
6.5 Inserting Summary Calculation
6.6 Defining Other Summary Calculations
Level Review
Crystal Reports XI Essentials: Level 2
1.0 Reports Based on More than One Table
1.1 Using the Create Report Expertv
1.2 Modifying a Report Created with the Expert
1.3 Building a Multi-table Report without the Expert
2.0 Enhancing Your Report with Formatting
2.1 Changing the Font of a Text or Field Object
2.2 Adding Borders & Drop Shadows
2.3 Formatting Numeric Data
2.4 Changing Object Alignment
3.0 Utilizing Conditional Formatting
3.1 Absolute Formatting
3.2 Conditional Formatting
3.3 The Highlighting Expert
3.4 Modifying & Deleting a Conditional Format
4.0 Creating Formulas with Crystal Syntax
4.1 The Formula Editor & Inserting Formulas
4.2 Changing Numbers to Words
4.3 String Manipulation and Formatting
4.4 Date Calculations
4.5 Creating Summary Calculations & Totaling By Group
4.6 If-Then-Else Formulas
5.0 Creating Formulas with Basic Syntaxv
5.1 Creating Formulas & Entering Code
5.2 Adding Comments
Level Review
Crystal Reports XI Essentials: Level 3
1.0 Parameter Fields
1.1 Creating Parameters Fields
1.2 Working with Multiple Parameter Fields
1.3 Adding a Parameter Field to a Printed Report
1.4 Deleting Parameters
2.0 Formatting Report Sections
2.1 Changing the Size of a Section
2.2 Sizing a Section Automatically
2.3 Inserting & Deleting Lines
2.4 Using the Section Expert
3.0 Advanced Grouping Techniques
3.1 Grouping & Sort Direction & Custom Groups
3.2 Sorting within a Group
3.3 Grouping on Intervals
4.0 Finishing Touches
4.1 Special Fields
4.2 Special Text Object Features
4.3 Working with Lines & Boxes
4.4 Adding Pictures to Your Report
5.0 Including Cross-Tabulations in Your Reports
5.1 Using the Cross-Tab Report Wizard
5.2 Using the Cross-Tab Report Expert
5.3 Modifying the Data in a Cross-Tab Report
5.4 Formatting a Cross-Tab Report
Level Review
Crystal Reports XI Essentials: Level 4
1.0 Summary Reports
1.1 Building a Summary Report
1.2 Allowing or Disallowing Drill-downs
1.3 Running Totals Reports
1.4 Creating Running Totals Overall
1.5 Creating Running Totals for a Group
1.6 Creating Conditional Running Totals
1.7 Creating Running Totals with a One-to-Many Relationship
1.8 Creating Running Totals with the Formula Editor
2.0 Top N
2.1 Creating a Report with Nth Largest Values
2.2 Creating a Report with Nth Smallest Values
2.0 Top N
2.1 Creating a Report with Nth Largest Values
2.2 Creating a Report with Nth Smallest Values
3.0 Working with Sub-Reports
3.1 Creating an Unlinked-Sub Report
3.2 Creating a Linked Sub-Report
3.3 On-demand Sub-Reports
4.0 Advanced Record & Group Selection
4.1 Setting up Group Selection
4.2 Creating a Record or Group Selection Formula
5.0 The Mailing Labels Report Creation Wizard
5.1 Creating Mailing Labels
5.2 Modifying the Attributes of Mailing Labels
6.0 Form Letters
6.1 Creating a Form Letter
6.2 Modifying Attributes of a Form Letter
6.3 Customizing a Form Letter for Different Recipients
6.0 Form Letters
6.1 Creating a Form Letter
6.2 Modifying Attributes of a Form Letter
6.3 Customizing a Form Letter for Different Recipients
Level Review
Crystal Reports XI Essentials: Level 5
1.0 Working with Data
1.1 Databases Overview
1.2 The Database Expert
1.3 Set Datasource Location
1.4 Aliases
1.5 Indexes
1.6 Relationships
1.7 Server-side Processing
1.8 Working with Different Types of Data
1.9 Advanced Database Features
2.0 Creating Data Connections
2.1 Using an Access/Excel (DAO) Datasource
2.2 Using an ODBC (RDO) Datasource
2.3 Using an OLEDB (ADO) Datasource
3.0 SQL
3.1 SQL & SQL Databases
3.2 What is SQL?
4.0 Using SQL in Crystal Reports
4.1 The Crystal SQL Expression Editor
4.2 Creating a Report from a SQL Query/Command
Level Review
Crystal Reports XI Essentials: Level 6
1.0 Advanced Formula Techniques
1.1 Using a Variable
1.2 Assigning a Value to a Variable
1.3 Using Arrays in Formulas
1.4 Using Ranges in Formulas
1.5 Debugging Formulas
2.0 Charting Your Report Data
2.1 Using Automated Chartingv
2.2 Creating a Group Chart
2.3 Creating a Detail Formula Chart
2.4 Creating a Cross-tab Chart
2.5 Creating a Gauge Chart
2.6 Creating a Gantt Chart
2.7 Creating a Funnel Chart
2.8 Modifying Chart Options
2.9 Drilling Down on a Graph
2.10 Re-entering the Chart Expertv
2.11 Using a Graph Template
3.0 Mapping
3.1 Using the Map Expert
3.2 Mapping on Grouped Fields
3.3 Modifying Map Attributes
3.4 Mapping on Detail Fields
3.5 Mapping on Cross-tab Summaries
Level Review
Crystal Reports XI Essentials: Level 7
1.0 OLE
1.1 OLE Introduced
1.2 Adding OLE Objects to a Report
1.3 Working with Static OLE Objects
1.4 Embedded vs. Linked Objects
2.0 External Data Sources
2.1 Web/IIS logs
2.2 The File System
2.3 NT Event Log
2.4 Outlook
2.5 XML
3.0 Distributing Reports
3.1 Exporting a Report
3.2 PDF Exporting
3.3 RTF Exporting
3.4 XML Exporting
3.5 Saving Export Settings
3.6 Mailing a Report
4.0 Distributing Reports Over the Web
4.1 Saving a Report as HTML
4.2 Working with Web Folders
4.3 Building Active Web Sites
5.0 Development Usage/Integration
5.1 The Crystal Report Designer Component (RDC)
5.2 Embeddable ActiveX Viewer
5.3 Embeddable Java Plugin Viewer
Level Review
Course Review
