(212) 684-5151

Crystal Reports 2016: Level 2
Crystal Reports 2016: Level 2

Crystal Reports Training Overview: Level 2

You will create complex reports using Crystal Reports' tools.

What You'll Learn in this Class:

  • Create automatic and manual running totals
  • Work with cross-tab reports
  • Add subreports
  • Create drill-downs in a report
  • Use SQL statements in report processing
  • Create complex formulas
  • Add charts to reports
  • Enhance report functionality


Students should have a basic understanding of Windows, including how to use files and folders.

Related Classes:

See Also:

Crystal Reports Training Class Outline - Level 2

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: Create a Chart with Drill-Down
• 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

• Topic 8A: Create a Static Prompt
• Topic 8B: Create a Dynamic Prompt

Lesson 9: Enhancing Report Functionality

• Topic 9A: Group Data Hierarchically
• Topic 9B: Create a Dynamic Image
• Topic 9C: Create a Report Alert
• Topic 9D: Create a Geographic Map