![]() |
Compu-Tutor, Inc. www.compu-tutor.net (610) 260-0300 |
Crystal Reports 2011:
Level 2
Course 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
Compu-Tutor, Inc.
www.compu-tutor.net
(610)
260-0300
Compu-Tutor Home |
Back to Training Schedule