Crystal Reports 10: Level 2
Class Outline:
Unit 1 : Complex reports
Topic A: 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: Subreports
B-1: Creating an unlinked subreport
B-2: Creating a linked subreport
Unit 2 : Formatting complex reports
Topic A: 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: Objects
B-1: Adding a hyperlink
B-2: Adding a linked OLE object
Unit 3 : Advanced formulas and functions
Topic A: 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: Advanced functions
B-1: Creating a formula using multiple functions
B-2: Using the EvaluateAfter function
Topic C: Constructs
C-1: Using a for construct
C-2: Using a While construct
Topic D: Running totals
D-1: Creating a running total
D-2: Modifying a running total
Unit 4 : Advanced data access techniques and alerts
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: 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: 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: Working with charts
A-1: Creating a chart
A-2: Modifying a chart
A-3: Creating funnel charts
Topic B: Creating maps
B-1: Creating maps by using the Map Expert
B-2: Customizing a map