|
 Overview
This one-day course is designed to further increase report design skills by concentrating on advanced topics. The course covers Crystal architecture, report design and Structured Query Language, advanced formula creation such as arrays and custom functions, subreports, and a hands-on report design workshop. In the Report Design Workshop, you will build upon topics you've learned throughout the Report Design courses. Each activity in the workshop presents a different business scenario in which to apply your report design skills. The reports you develop in this workshop can also be used as a guide for your own reporting needs.
Prerequisites Learners must have taken Report Design I and II courses, or have a minimum of six months of report design experience with Crystal Reports and understand advanced report design concepts such as formulas, parameters, sections, cross-tabs, and exporting. Relational database knowledge is recommended. Learners who have not completed Report Design I and II courses should complete the prerequisite exercise and bring it to class. Download CR_9_rd3_prerequisite.pdf Report Design III Prerequisite Exercise (PDF - 136 KB).
What you will learn
Architecture
- Understanding
the core components
- Understanding
multi-pass reporting
- Understanding
key dynamic link libriaries
Working
with Databases
- Accessing
data sources
- Using
SQL to process reports
- Applying
database options
- Adjusting
to database changes
- Saving
data indexes
Formulas
- Understanding
formula sizing limitations
- Using
arrays
- Using
advanced control structures
- Using
custom functions
Subreports
- Defining
subreports
- Creating
an unlinked subreport
- Creating
a linked subreport
- Creating
an on-demand subreport
- Adding
captions to subreports
- Updating
subreports
- Using
shared variables
Report
Design Workshop
- Understanding
the workshop objectives
- Setting
up your system for the worlshop
- Choosing
your Workshop scenarios and activities
- Building
your Workshop reports
Who
should attend
Learners who want to further develop their intermediate report design skills using Crystal Reports 9.
Class Schedule
Registration
|
