Crystal Reports 2011: Level 2

Course Specifications

Course number: CRY-201
Course length: 1.0 day(s)

Performance-Based Objectives:

Upon successful completion of this course, students will be able to:

  • 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.

Course Content

Lesson 1: Creating Running Totals

  • Topic 1A: Create a Running Total Field
  • Topic 1B: Modify a Running Total Field
  • Topic 1C: Create a Manual Running Total

Lesson 2: Working with Cross-Tabs

  • Topic 2A: Create a Cross-Tab Report
  • Topic 2B: Format a Cross-Tab Report
  • Topic 2C: Create Groups in Cross-Tab Reports

Lesson 3: Adding Subreports

  • Topic 3A: Insert a Subreport
  • Topic 3B: Edit a Subreport
  • Topic 3C: Share Variables

Lesson 4: Creating Drill-Downs in a Report

  • Topic 4A: Create a Drill-Down
  • Topic 4B: Create Headings for Drill-Down Data

Lesson 5: Using SQL Statements in Report Processing

  • Topic 5A: Create a Report Using SQL Queries
  • Topic 5B: Summarize Report Data
  • Topic 5C: Create Joins Using SQL
  • Topic 5D: Create Subqueries
  • Topic 5E: Create a SQL Expression Field

Lesson 6: Creating Complex Formulas

  • Topic 6A: Work with Loops
  • Topic 6B: Work with Arrays

Lesson 7: Adding Charts to Reports

  • Topic 7A: Create Charts
  • Topic 7B: Create a Chart with a Drill-Down
  • Topic 7C: Create a Top N Chart
  • Topic 7D: Create a Cross-Tab Chart
  • Topic 7E: Create Charts for Grouped Data
  • Topic 7F: Format a Chart
  • Topic 7G: Create a Chart Template

Lesson 8: Enhancing Report Functionality

  • Topic 8A: Organize Data Based on a Hierarchy
  • Topic 8B: Create a Dynamic Image
  • Topic 8C: Create a Report Alert
  • Topic 8D: Create a Geographic Map