|
Advanced Report Design
Overview
By the end of this
two-day class, participants will be able to use a variety of Crystal
Reports’ advanced features to create meaningful analytical reports using
multiple tables and complex formula fields.
Prerequisites
Participants must have
completed our Level 1 course or successfully completed our Level 1
proficiency test (available on request). Additionally, participants should
have experience with and be comfortable with formula writing in programs
such as Excel and Access.
Topics Covered
Advanced
Formulas
q
IF ... THEN … ELSE
(cont’d)
q
Select function
q
Evaluation time functions
q
For … Next Loops
q
Handling nulls
q
String functions
q
Date functions
q
Converting data types
Parameter
Fields
q
Selecting records based on
user-provided values
q
Sorting records based on
user-provided values
q
Formulas based on
user-provided values
q
Suppressing sections on
user-provided value
Cross-Tabs
q
The Cross-Tab Expert
q
Formatting a Cross-Tab
report
Advanced
Grouping
q
Customized groups
q
Hierarchical groups
q
Grouping on a formula field
Pre-processed
and Running Totals
q
Multi-pass processing
q
Running total fields
q
Conditional running totals
q
Accumulation options
Top “N”
Reports
q
Sorting on a subtotal
q
Selecting the top or bottom
groups
Linking
Tables
q
Visual Linking Expert
q
Direct vs. ODBC linking
q
Types of links
Sub-reports
q
Unlinked sub-reports
q
Linked sub-reports
q
On-Demand vs. In-Place
sub-reports
q
Linking based on a formula
Variables and
Arrays
q
Declaring and using
variables
q
Using variable scope
q
Using Arrays
Advanced
Formatting
q
Adding pictures, lines and
boxes
q
Vertical orientation
q
Grid options
Charts and
Maps
q
Crystal Charts
q
Crystal Maps
Do you want to: Receive
information on our Crystal Reports Public Training sessions? Receive
information on our Crystal Reports Corporate Training? Subscribe
to our Crystal Reports Newsletter? Join our Crystal Reports E-Mail List?
|
