Crystal Reports 10:
Advanced

Topic-Level Outline

Days: 1

Prerequisites: Crystal Reports 10: Basic or equivalent experience

Unit 1 : Complex reports

Topic A: 0 Parameter fields

A-1: Creating a parameter field

A-2: Applying an edit mask to a parameter field

A-3: Using a pick list in a parameter field

Topic B: 0 Subreports

B-1: Creating an unlinked subreport

B-2: Creating a linked subreport

Unit 2 : Formatting complex reports

Topic A: 0 The Section Expert

A-1: Adding new sections

A-2: Suppressing a blank section

A-3: Merging report sections

A-4: Deleting a section

A-5: Displaying each record on a separate page

Topic B: 0 Objects

B-1: Adding a hyperlink

B-2: Adding a linked OLE object

Unit 3 : Advanced formulas and functions

Topic A: 0 Variables

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

A-2: Using an array variable in a formula

A-3: Using a range variable in a formula

Topic B: 0 Advanced functions

B-1: Creating a formula using multiple functions

B-2: Using the EvaluateAfter function

Topic C: 0 Constructs

C-1: Using a for construct

C-2: Using a While construct

Topic D: 0 Running totals

D-1: Creating a running total

D-2: Modifying a running total

Unit 4 : Advanced data access techniques and alerts

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 Database Expert

B-1: Understanding SQL Syntax

B-2: Creating a command while creating a report

B-3: Editing and adding a command to repository

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

Topic C: 0 Report alerts

C-1: Creating a report alert

C-2: Modifying a report alert

C-3: Deleting a report alert

Unit 5 : Charts and maps

Topic A: 0 Working with charts

A-1: Creating a chart

A-2: Modifying a chart

A-3: Creating funnel charts

Topic B: 0 Creating maps

B-1: Creating maps by using the Map Expert

B-2: Customizing a map