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