|
Crystal Reports 2008: Advanced Skills
Target Student:
This course is designed for
people who know how to create basic list and group reports and need to create
reports that include subreports, cross-tabs, advanced formulas, and charts based
on more than one data series. They may also need to build tools that make it
easier for other people to create reports. They may or may not have programming
and/or SQL experience.
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
|
|
|
|
 |