Description:

Course Outline:

Lesson 1: Refresher Exercise

Topic A: Review of Planning a Report

Topic B: Creating the Report

Topic C: Placing Fields on the Report

Topic D: Creating the Formulas

Topic E: Advanced Grouping

Topic F: Selecting Certain Records

Topic G: Helpful Hints for Formatting the Report

Topic H: Adding and Working with Text Objects

Topic I: Hiding and Suppressing Sections

Topic J: Guidelines

Lesson 2: Power Formatting with Multiple Sections

Topic A: Using Multiple Sections in Reports

Topic B: Using the Section Expert to Work with Sections

Topic C: Conditionally Formatting Multiple Sections

Topic D: Challenge Exercise - Formatting with Multiple Sections

Topic E: Challenge Exercise - Conditionally Formatting Using DrillDownGroupLevel

Lesson 3: Using the Running Totals Feature

Topic A: Understanding Running Totals

Topic B: Creating Running Totals for a List of Numbers

Topic C: Conditional Running Totals

Topic D: Challenge Exercise - Creating a Conditional Running Total

Lesson 4: Prompting with Parameters

Topic A: Parameter Field Considerations

Topic B: Creating a Parameter Field

Topic C: Using a Parameter to Select Records

Topic D: Using a Parameter Field

Topic E: Using the Parameter Panel

Topic F: Creating a Dynamic Value List for Parameter Values

Topic G: Importing a Pick List

Topic H: Adding Parameter Values to Text Objects

Topic I: Allowing Multiple Values in Parameters

Topic J: Using Multiple Parameter Fields in Reports

Topic K: Specifying and Limiting a Range

Topic L: Using Parameters in Conditional Formatting

Topic M: Using an Edit Mask to Limit String Parameters

Topic N: Sorting with a Parameter

Topic O: Using a parameter to set N in a Top N Report

Topic P: Cascading Parameters

Topic Q: Challenge Exercise - Using and Displaying Parameters

Lesson 5: Using Advanced Formula Features

Topic A: Understanding How Crystal Reports Processes the Data

Topic B: What Is a Pass?

Topic C: Using Evaluation Time Functions

Topic D: Working with Variables

Topic E: Declaring a Variable

Topic F: Assigning a Value to a Variable

Topic G: Using a Variable in a Formula

Topic H: Variable Scope

Topic I: Separating Statements in Complex Formulas

Topic J: Working with Arrays

Topic K: Understanding the Evaluation Time Debugger

Topic L: Challenge Exercise - Understand and Set Up the YTD Comparison Report

Lesson 6: Using Sub reporting as a Workaround Solution

Topic A: Understanding Sub reports

Topic B: Unlinked versus Linked Subreports

Topic C: Creating an Unlinked Sub report

Topic D: Linking a Subreport

Topic E: Database Links versus Subreports in One-to-Many Situations

Topic F: Formatting the Subreport

Topic G: Passing Data from the Main Report into a Subreport

Topic H: Creating On-Demand Subreports

Topic I: Creating Hyperlinks

Topic J: Using Subreports to Link "Unlinkable" Data

Topic K: Challenge Exercise - Creating Reports with Linked Subreports

Lesson 7: Creating Powerful Groups

Topic A: Creating Custom Groups

Topic B: Customizing Group Sort Order

Topic C: Using Group Selection to Filter the Records in the Report

Topic D: Grouping on a Formula Field

Topic E: Grouping Hierarchically

Topic F: Challenge Exercise – Create Customized Grouping

Topic G: Challenge Exercise - Using Group Selection

Topic H: Challenge Exercise - Creating a Group

Lesson 8: Working with Cross-Tab Reports

Topic A: Understanding How Cross-Tabs Affect Your Data

Topic B: Creating a Cross-Tab Report

Topic C: Creating a Cross- Tab with Multiple Rows or Columns

Topic D: Applying a Formatting Style to the Cross-Tab

Topic E: Customizing the Cross-Tab Format

Topic F: Changing Background Colors

Topic G: Formatting Individual Cells

Topic H: Changing the Summary Operation

Topic I: Suppressing Rows, Columns or Totals

Topic J: Repeating Row Heading for Multi-Page Cross-Tabs

Topic K: Using Alias Names for Column and Row Headings

Topic L: Charting Cross-Tabs

Topic M: Customizing Cross-Tab Group Names

Topic N: Using the CurrentFieldValue Function

Topic O: Challenge Exercise - Cross-Tab Reports

Lesson 9: Report Alerts

Topic A: What are Report Alerts

Topic B: Creating Report Alerts

Topic C: Basing Report Formulas or Conditional Formatting on Report Alerts

Topic D: Creative Usage for Report Alerts

Topic E: Challenge Exercise - Using Report Alerts with Parameter

Lesson 10: Report Templates

Topic A: A Self-Paced Tutorial Teaching the Methods Used to Create Report Templates to be Applied to Unformatted Reports

Lesson 11: The Northwind 2008 Sample Database

Topic A: A Relational Diagram of Tables Existing in the Northwind 2008 Sample Database Provided in the Crystal Reports 2008 Class Files

Lesson 12: Installation and System Requirements

Topic A: A Complete Listing of Operating System and Hardware Requirements

Lesson 13: Setup Instructions for Crystal Reports 2008 APPENDIX E - Function and Operator Locations

Topic A: A Complete Listing of All the Available Formula Functions and an Explanation of the New Custom Functions

Lesson 14: Glossary

Topic A: A Complete Glossary of terms Used Throughout the Book