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.
Prerequisites: Crystal Reports 2011: Level 1. A knowledge of programming
and/or SQL would also be helpful.
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
Appendix
A: Managing Reports
Appendix
B: Processing Data on the Server
Appendix
C: Detecting and Fixing Problems