Enroll in both levels of our instructor-led Crystal Reports classes and save $200. This course package includes:
Crystal Reports - Level 1 (Days 1 & 2)
Lesson 1: Exploring the Crystal Reports Interface
Topic A: Explore Crystal Reports
Topic B: Use Crystal Reports Help
Topic C: Customize Report Settings
Lesson 2: Working with Reports
Topic A: Create a Report
Topic B: Modify a Report
Topic C: Display Specific Report Data
Topic D: Work with Report Sections
Lesson 3: Using Formulas in Reports
Topic A: Create a Formula
Topic B: Edit a Formula
Topic C: Filter Data by Using a Formula
Topic D: Work with Advanced Formulas and Functions
Topic E: Handle Null Values
Lesson 4: Building Parameterized Reports
Topic A: Create a Parameter Field
Topic B: Use a Range Parameter in a Report
Topic C: Create a Prompt
Lesson 5: Grouping Report Data
Topic A: Group Report Data
Topic B: Modify a Group Report
Topic C: Group by Using Parameters
Topic D: Create a Parameterized Top N Report
Lesson 6: Enhancing a Report
Topic A: Format a Report
Topic B: Insert Objects in a Report
Topic C: Suppress Report Sections
Topic D: Use Report Templates
Lesson 7: Creating a Report from Excel Data
Topic A: Create a Report Based on Excel Data
Topic B: Modify a Report Generated from Excel Data
Topic C: Update Data in a Report Based on Excel Data
Lesson 8: Distributing Data
Topic A: Export Data
Topic B: Create Mailing Labels
Appendix A: Setting Up and Configuring Data Sources
Appendix B: Using Report Processing Techniques
Appendix C: Using Functions in Formulas
Crystal Reports - Level 2 (Days 3 & 4)
Lesson 1: Creating Running Totals
Topic A: Create a Running Total Field
Topic B: Modify a Running Total Field
Topic C: Create a Manual Running Total
Lesson 2: Working with Cross-Tabs
Topic A: Create a Cross-Tab Report
Topic B: Format a Cross-Tab Report
Topic C: Create Groups in Cross-Tab Reports
Lesson 3: Adding Subreports
Topic A: Insert a Subreport
Topic B: Edit a Subreport
Topic C: Share Variables
Lesson 4: Creating Drill-Downs in a Report
Topic A: Create a Drill-Down
Topic B: Create Headings for Drill-Down Data
Lesson 5: Using SQL Statements in Report Processing
Topic A: Create a Report Using SQL Queries
Topic B: Summarize Report Data
Topic C: Create Joins Using SQL
Topic D: Create Subqueries
Topic E: Create an SQL Expression Field
Lesson 6: Creating Complex Formulas
Topic A: Work with Loops
Topic B: Work with Arrays
Lesson 7: Adding Charts to Reports
Topic A: Create Charts
Topic B: Drill Down to Chart Data
Topic C: Create a Top N Chart
Topic D: Create a Cross-Tab Chart
Topic E: Create Charts for Grouped Data
Topic F: Format a Chart
Topic G: Create a Chart Template
Lesson 8: Enhancing Report Functionality
Topic A: Organize Data Based on a Hierarchy
Topic B: Create a Dynamic Image
Topic C: Create a Report Alert
Topic D: Create a Geographic Map
Appendix A: Managing Reports
Appendix B: Processing Data on the Server
Appendix C: Detecting and Fixing Problems