Crystal Reports 10:
Basic

Topic-Level Outline

Days: 1

Prerequisites: Access 2003: Intermediate or equivalent experience

Unit 1 : Introduction to Crystal Reports

Topic A: 0 Getting started

A-1: Discussing the features of Crystal Reports

A-2: Opening a report

A-3: Examining the environment

A-4: Examining the Design tab

Topic B: 0 Creating and saving reports

B-1: Selecting a blank report document

B-2: Selecting a data source using Database Expert

B-3: Adding fields using the Field Explorer

B-4: Adding a report title

B-5: Saving a report

Topic C: 0 Modifying reports

C-1: Sizing fields

C-2: Arranging a field

C-3: Aligning fields

C-4: Modifying text objects

Topic D: 0 The Help feature

D-1: Using the Help feature

D-2: Using the Search tab

Unit 2 : Organizing records

Topic A: 0 Sorting

A-1: Sorting records

Topic B: 0 Record selection

B-1: Selecting records based on a single criterion

B-2: Deleting a record selection formula

B-3: Selecting records based on multiple criteria

B-4: Deleting a criterion in a multiple-criteria formula

Topic C: 0 Groups

C-1: Creating a group

C-2: Displaying groups in a specified order

Topic D: 0 Summaries

D-1: Inserting a subtotal

D-2: Inserting a grand total

D-3: Summarizing group information

D-4: Displaying the Top N groups of records

Unit 3 : Formulas and functions

Topic A: 0 Formulas

A-1: Discussing formula components

A-2: Creating a formula

Topic B: 0 Modifying formulas

B-1: Editing a formula

B-2: Renaming a formula

B-3: Deleting a formula

Topic C: 0 Functions

C-1: Using a date function to return the current date

C-2: Using a string function to convert text to uppercase

C-3: Using a math function to round data

Topic D: 0 The Crystal Repository

D-1: Adding an item

D-2: Using a Crystal Repository item in a report

D-3: Modifying an item

D-4: Deleting an item

Unit 4 : Formatting

Topic A: 0 Absolute formatting

A-1: Formatting a field

A-2: Adding lines and boxes

A-3: Adding shapes

A-4: Using Format Painter to change fonts

Topic B: 0 Conditional formatting

B-1: Creating conditional formats

B-2: Using a formula to change a font conditionally

Unit 5 : Experts and wizards

Topic A: 0 Database Expert

A-1: Adding a field from a second table

Topic B: 0 Report wizards

B-1: Using the Standard Report Creation wizard

B-2: Using the Mailing Labels Report Creation wizard

Topic C: 0 Cross-tab reports

C-1: Creating a cross-tab report

C-2: Formatting a cross-tab report

Unit 6 : Distributing reports

Topic A: 0 Exporting reports

A-1: Exporting a report to Microsoft Excel

A-2: Exporting a report to HTML 4.0

A-3: Exporting a report to XML

A-4: Exporting a report to an Access database

A-5: Creating a report definition

Topic B: 0 Delivering reports

B-1: Printing a report

B-2: Mailing a report