Crystal Reports XI:

Topic-Level Outline

                         Days:  2

         Prerequisites:  Windows XP: Basic and Access 2003: Intermediate, or equivalent experience

                         Unit 1 :  Getting started

                               Topic A: 0  The Crystal Reports environment

                               A-1:                               Discussing the features of Crystal Reports

                               A-2:                               Examining the Start Page

                               A-3:                               Opening a report

                               A-4:                               Examining the Design tab

                               A-5:                               Modifying the size of the Details section

                               A-6:                               Setting file options

                               Topic B: 0  Creating, viewing, and saving reports

                               B-1:                               Creating a new blank report

                               B-2:                               Adding fields by using the Field Explorer

                               B-3:                               Changing the page orientation of a report

                               B-4:                               Adding a report title

                               B-5:                               Viewing a report

                               B-6:                               Saving a report

                               Topic C: 0  Modifying report layout

                               C-1:                               Sizing fields

                               C-2:                               Arranging a field

                               C-3:                               Aligning fields

                               C-4:                               Modifying a text object

                               Topic D: 0  The Help feature

                         D-1:                         Using the Help feature

                         D-2:                         Using the Search tab

                         Unit 2 :  Formatting

                               Topic A: 0  Absolute formatting

                               A-1:                               Formatting a field

                               A-2:                               Formatting a date field

                               A-3:                               Adding lines and boxes

                               A-4:                               Adding a shape

                               A-5:                               Using Format Painter to change font styles

                               Topic B: 0  Introducing conditional formatting

                         B-1:                         Using the Highlighting Expert

                         Unit 3 :  Sorting and selecting records

                               Topic A: 0  Sorting records

                               A-1:                               Sorting records in ascending order

                               Topic B: 0  Selecting records

                         B-1:                         Selecting records based on a single criterion

                         B-2:                         Deleting a single-criterion selection formula

                         B-3:                         Selecting records based on multiple criteria

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

                         Unit 4 :  Grouping and summarizing

                               Topic A: 0  Groups

                               A-1:                               Creating a group

                               A-2:                               Grouping by date fields

                               A-3:                               Displaying groups in a specified order

                               A-4:                               Creating a subgroup

                               A-5:                               Setting group options

                               A-6:                               Deleting a group

                               Topic B: 0  Summaries

                         B-1:                         Inserting a subtotal

                         B-2:                         Inserting a grand total

                         B-3:                         Displaying the top N of groups of records

                         Unit 5 :  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 the Month (x) function

                         C-3:                         Using the MonthName function

                         C-4:                         Combining field names and formulas

                         C-5:                         Using a string function to convert text to proper case

                         C-6:                         Using the Left function

                         C-7:                         Using a math function to round data

                         Unit 6 :  Experts and wizards

                               Topic A: 0  The Database Expert

                               A-1:                               Adding a field from a linked table

                               Topic B: 0  Report wizards

                               B-1:                               Using the Standard Report Creation Wizard

                               B-2:                               Using the Mailing Label Report Creation Wizard

                               Topic C: 0  Cross-tab reports

                         C-1:                         Creating a cross-tab report

                         C-2:                         Grouping data in a cross-tab report

                         C-3:                         Formatting a cross-tab report

                         Unit 7 :  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