Delivery Method: Instructor-led Classroom Learning

Duration: 16 hours

Lesson 1: Overview

Examining the Capabilities of Crystal Reports
Planning Your Report
Reviewing the Class Database Files and ReportTypes
Modifying the Program Default Settings
Using Help

Lesson 2: Creating Basic Reports

Report Sections
Generating a New Report
Viewing Your Report
Changing the Size and Position of Your Fields
Formatting Your Report
Adding the Finishing Touches to Your Report
Saving Your Report

Lesson 3: Sorting and Selecting Data

Using Sort Options
Using the Select Expert
Using Multiple Criteria in the Selection Formula
Changing the Record Selection Formula

Lesson 4: Grouping and Summarizing

Understanding Group Components
Defining Multiple-level Groups
Working with Grouping Options
Inserting Subtotals and Grand Totals
Working with Summary Fields
Calculating the Percentage of the Group to theGrand Total Functions
Using Grand Total Summary Function
Using the Top N/Sort Group Expert

Lesson 5: Using the Report Expert

Creating a New Report Using the Standard ReportExpert
Creating a New Report Using the Mail Label ReportExpert
Editing Reports Using the Report Expert

Lesson 6: Cross-tab Reports

Using Cross-tab Reports
Using the Cross-Tab Expert
Working with Existing Cross-tabs
Understand Cross-tab Layout Features
Formatting Options

Lesson 7: Linking

Understanding Relational Database Basics
Using the Visual Linking Expert
Understanding Link Options
Understanding Link Options for PC and SQL Databases

Lesson 8: Creating Formulas

Understanding Formula Components
Using the Formula Editor to Create Formulas
Modifying Your Formulas
Using String Functions
Using Date/Time Functions
Using If-Then-Else Statements in Formulas
Calculating Your Own Summary Fields

Lesson 9: Formatting Sections

Reviewing Sections
Resizing Sections in Design View
Formatting Sections with the Section Expert
Creating Summary and Drill-down Reports

Lesson 10: Distributing Data

Exporting a Report to Another File Format
Integrating Your Information with Office SuiteSoftware
Creating a Report from Excel Data
Using Crystal Enterprise for Web Reporting

Delivery Method: Instructor-led Classroom Learning

Duration: 16 hours

Lesson 1: Overview

Examining the Capabilities of Crystal Reports
Planning Your Report
Reviewing the Class Database Files and ReportTypes
Modifying the Program Default Settings
Using Help

Lesson 2: Creating Basic Reports

Report Sections
Generating a New Report
Viewing Your Report
Changing the Size and Position of Your Fields
Formatting Your Report
Adding the Finishing Touches to Your Report
Saving Your Report

Lesson 3: Sorting and Selecting Data

Using Sort Options
Using the Select Expert
Using Multiple Criteria in the Selection Formula
Changing the Record Selection Formula

Lesson 4: Grouping and Summarizing

Understanding Group Components
Defining Multiple-level Groups
Working with Grouping Options
Inserting Subtotals and Grand Totals
Working with Summary Fields
Calculating the Percentage of the Group to theGrand Total Functions
Using Grand Total Summary Function
Using the Top N/Sort Group Expert

Lesson 5: Using the Report Expert

Creating a New Report Using the Standard ReportExpert
Creating a New Report Using the Mail Label ReportExpert
Editing Reports Using the Report Expert

Lesson 6: Cross-tab Reports

Using Cross-tab Reports
Using the Cross-Tab Expert
Working with Existing Cross-tabs
Understand Cross-tab Layout Features
Formatting Options

Lesson 7: Linking

Understanding Relational Database Basics
Using the Visual Linking Expert
Understanding Link Options
Understanding Link Options for PC and SQL Databases

Lesson 8: Creating Formulas

Understanding Formula Components
Using the Formula Editor to Create Formulas
Modifying Your Formulas
Using String Functions
Using Date/Time Functions
Using If-Then-Else Statements in Formulas
Calculating Your Own Summary Fields

Lesson 9: Formatting Sections

Reviewing Sections
Resizing Sections in Design View
Formatting Sections with the Section Expert
Creating Summary and Drill-down Reports

Lesson 10: Distributing Data

Exporting a Report to Another File Format
Integrating Your Information with Office SuiteSoftware
Creating a Report from Excel Data
Using Crystal Enterprise for Web Reporting v