Crystal Reports: Level 2

About this class

This course is designed for users with a basic knowledge of Crystal Reports but who require the use of advanced formulas and formatting, need to access information that is not PC-based, or need to set up reports that other users will access and run. Although no database experience is necessary, some of the concepts may be more meaningful if the user has worked with database applications before. A basic knowledge of relational data concepts is also recommended. This course will introduce you to the some of the advanced features within Crystal Reports. You will use variables and multiple statements in formulas, create and use parameter fields, develop conditional format statements and work with multiple sections.

What prerequisites are required

Before attending this course, students must have:

• knowledge of Crystal Reports 8.5: Introduction.

Contents of this class

Lesson 1: Review Exercises

• Creating a Basic Report
• Adding and Linking Databases to a Report
• Selecting, Grouping, and Summarizing
• Creating Formulas
• Formatting Sections for Summary/Drill-Down

Lesson 2: Conditional Formatting

• Absolute versus Conditional Formatting
• On/Off Formatting
• Conditional Attribute Formatting
• The Highlighting Expert
• Restoring Conditional Formats

Lesson 3: Advanced Formulas

• Using Variables in Formulas
• Creating a Running Total
• Understanding Multiple-pass Reporting
• Using Evaluation Time Functions
• Creating Formulas Using Multiple Variables

Lesson 4: Multiple Sections

• Inserting Sections
• Moving Sections
• Splitting Sections
• Multiple Sections and Conditional Formats

Lesson 5: Parameter Fields

• What are Parameter Fields?
• Creating Parameter Fields
• Using Pick Lists
• Using Parameter Fields in Record Selection
• Using Edit Masks
• Using the Like Statement
• Setting Conditional Formats Using Parameter Fields

Lesson 6: Using Report Alerts

• What are Report Alerts
• Creating Report Alerts
• Modifying Report Alerts
• Deleting Report Alerts

Lesson 7: Advanced Cross-tabs

• Inserting Multiple Rows, Columns, and Summarized Fields
• Editing a Cross-tab
• Using Formula Fields in a Cross-tab
• Using Parameters in Cross-tabs
• Creating a Cross-tab Object for Each Group Value

Lesson 8: Sub reports

• Identifying Sub report Features
• Inserting Unlinked Sub reports
• Formatting Sub reports
• Inserting Linked Sub report
• Using On-demand Sub reports

Lesson 9: SQL/ODBC and Crystal SQL Designer

• Introducing Structured Query Language (SQL)
• Introducing ODBC Data Sources
• Introducing the Crystal SQL Designer
• Using a Query to Create a Report

Lesson 10: Crystal Dictionaries

• Defining Dictionaries
• Creating Dictionaries
• Enhancing Your Dictionary