Crystal Reports XI:
Advanced

Topic-Level Outline

Days: 2

Prerequisites: Crystal Reports XI: Basic

Unit 1 : Selecting data

Topic A: 0 Parameter fields

A-1: Creating a parameter field

A-2: Using wildcards to select data

A-3: Applying an edit mask to a parameter

Topic B: 0 Defining report elements

B-1: Using a pick list in a parameter field

B-2: Modifying a pick list to allow multiple values

B-3: Using a date range

B-4: Creating a cascading parameter

Unit 2 : Advanced formulas and functions

Topic A: 0 Running totals

A-1: Creating a running total

A-2: Modifying a running total

A-3: Resetting a running total based on a group

Topic B: 0 Variables

B-1: Declaring and using a variable in a formula

B-2: Using an array variable in a formula

B-3: Using a range variable in a formula

Topic C: 0 Advanced functions

C-1: Creating a formula by using multiple functions

C-2: Using the EvaluateAfter function

Topic D: 0 Constructs

D-1: Using a For construct

D-2: Using a While construct

Unit 3 : Charts and maps

Topic A: 0 Working with charts

A-1: Creating a chart

A-2: Modifying a chart

A-3: Creating a funnel chart

Topic B: 0 Creating maps

B-1: Creating a map by using the Map Expert

B-2: Customizing a map

Unit 4 : Formatting complex reports

Topic A: 0 The Section Expert

A-1: Modifying section properties

A-2: Adding new sections

A-3: Underlaying a section containing a chart

A-4: Displaying groups on separate pages

A-5: Merging report sections

A-6: Deleting a section

Topic B: 0 Advanced conditional formatting

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

B-2: Suppressing page numbering on first page only

B-3: Conditionally formatting a section background color

B-4: Using parameters to conditionally format background color

B-5: Creating a conditional format for grouped data

Topic C: 0 Objects

C-1: Adding a hyperlink

C-2: Adding a linked OLE object

Unit 5 : Alerts and subreports

Topic A: 0 Report alerts

A-1: Creating a report alert

A-2: Modifying a report alert

A-3: Deleting a report alert

Topic B: 0 Subreports

B-1: Creating an unlinked subreport

B-2: Creating a linked subreport

B-3: Creating an on-demand subreport

B-4: Creating a caption for an on-demand subreport

Unit 6 : Data management features

Topic A: 0 The Business Objects Enterprise Repository

A-1: Adding an item

A-2: Using a repository item in a report

A-3: Modifying an item

A-4: Deleting an item

Topic B: 0 The Workbench

B-1: Creating a new project in the Workbench

Unit 7 : Advanced data access techniques

Topic A: 0 ODBC data sources

A-1: Discussing ODBC data sources

A-2: Making ODBC source settings

A-3: Creating a report using an ODBC data source and an Access database

Topic B: 0 SQL and the Database Expert

B-1: Understanding SQL syntax

B-2: Creating a command while creating a report

B-3: Editing a command

B-4: Adding a command to the repository

B-5: Creating a report based on an existing query