Advanced
Topic-Level Outline
Days: 2
Prerequisites: Crystal
Reports 2008: Basic
Unit 1 : Selecting data
Topic A: Parameter fields
A-1: Creating a parameter field
A-2: Making a parameter interactive
A-3: Using wildcards to select data
A-4: Applying an edit mask to a parameter field
A-5: Using a parameter field to group data
A-6: Using a parameter to create a Top N report
Unit 2 : Advanced formulas and functions
Topic A: Running totals
A-1: Creating a running total
A-2: Modifying a running total to make it conditional
A-3: Resetting a running total based on a group
Topic B: 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: Advanced functions
C-1: Creating a formula by using multiple functions
C-2: Using the EvaluateAfter function
Topic D: Constructs
D-1: Using a For construct
D-2: Using a While construct
Unit 3 : Charts and maps
Topic A: Working with charts
A-1: Creating a chart
A-2: Modifying a chart
A-3: Creating a funnel chart
Topic B: Creating maps
B-1: Creating a map by using the Map Expert
B-2: Customizing a map
Unit 4 : Formatting complex reports
Topic A: 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
A-7: Using Section Expert to create multiple columns
Topic B: 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: Objects
C-1: Adding a hyperlink
C-2: Adding a linked OLE object
Unit 5 : Alerts and subreports
Topic A: Report alerts
A-1: Creating a report alert
A-2: Modifying a report alert
A-3: Deleting a report alert
Topic B: 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 : Advanced data access techniques
Topic A: 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: The Business Objects Enterprise Repository
B-1: Understanding the repository
Topic C: SQL and the Database Expert
C-1: Understanding SQL syntax
C-2: Creating a command while creating a report
C-3: Editing a command
C-4: Creating a report based on an existing query