|
Basic
Report Design
Overview
By the end of this
two-day class, participants will be able to create a presentation quality
report. They will be able to select the records required in their reports,
create calculated fields, add totals and subtotals to their reports, and
understand how to link tables using the Crystal Reports Visual Linking
Expert.
Prerequisites
No specific knowledge of
Crystal Reports or database concepts is required. Participants should
review the “Quick start for new users” tutorial (found in Chapter 4 of
the Crystal Reports 8.x Users Guides) and have a thorough understanding of
Windows concepts and use.
Topics Covered
Introduction
q
Course objective
q
Database concepts &
field types
q
The Crystal environment
Creating
Simple Reports
q
Using Crystal Wizards
q
Entering, editing and
moving text and database fields
q
Layout options
q
Field attributes
q
Editing in preview mode
q
Using guidelines
Selecting
records
q
Selection rules
q
Using multiple fields
q
Date ranges
q
Using the ‘OR’
connector
q
Using wildcards
Totals and
Counts
q
Creating grand total sums,
counts and averages
q
Creating subtotals
q
Formatting numeric fields
q
Distinct counts, averages
q
Editing a text object
q
Using the highlighting
expert
q
Creating page breaks
q
Creating a Summary Report
Sorting and
Grouping
q
Creating sections
q
Formatting sections
q
Changing the sort order
q
Creating groups
q
Using group names
q
Exporting data to a
spreadsheet
q
Creating a report from a
spreadsheet
Formula and
Special Fields
q
Formulas using operators
q
Inserting date and page
number
q
Selecting using formulas
q
Using Crystal Functions
q
Using IF ... THEN ... ELSE
q
Nested IF Statements
Linking
Tables
q
Visual Linking Expert
q
Creating Mailing Labels
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?
|
