Skip to Content

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

expand or collapse the menu Accessibility

expand or collapse the menu Web Development

expand or collapse the menu Adobe / Macromedia Web

expand or collapse the menu Programming

expand or collapse the menu Databases

expand or collapse the menu Professional Courses

expand or collapse the menu Adobe

expand or collapse the menu Microsoft SharePoint

expand or collapse the menu Technical

expand or collapse the menu Geographic (GIS)

expand or collapse the menu Microsoft Office

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

Crystal Reports XI - Level 2

2 day course

View Detailed Outline in PDF format

Get Adobe Reader

This two-day course is designed to enhance your basic report writing skills and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice. In addition, you will cover professional design, techniques, subreporting and advanced formulas. This course incorporates a number of hands on exercises that reinforce the learning process.

Course Topics:

(for a full detailed outline, visit our PDF link above)

Reviewing the Basics

  • Planning and Creating a New Report
  • Placing Fields and Creating Formulas
  • Grouping and Record Selection
  • Formatting the Report
  • Working with Text Objects
  • Hiding and Suppressing Sections

Formatting with Multiple Sections

  • Using Multiple Sections in Reports
  • Using the Section Expert
  • Conditionally Formatting Multiple Sections
  • Advanced Drill Down - Group Level

Using Running Totals

  • Understanding Running Totals
  • Creating Running Totals
  • Conditional Running Totals

Using Report Parameters

  • Creating Parameter Fields
  • Using a Parameter to Select Records
  • Dynamic Value List for Parameter Values
  • Importing a Pick List
  • Adding Parameter Values to Text Objects
  • Allowing Multiple Values in Parameters
  • Specifying a Limit Range for a Parameter
  • Using Parameters in Conditional Formatting
  • Edit Masks to Limit String Parameters
  • Sorting with a Parameter
  • Cascading Parameters

Advanced Formulas

  • How Crystal Reports Processes Data
  • What Is a Pass?
  • Using Evaluation
  • Time Functions
  • Working with Variables in Formula
  • Variable Scope
  • Separating Statements in Complex Formulas
  • Working with Arrays
  • Setting Up a YTD Comparison Report

Subreports

  • Understanding Subreports
  • Unlinked vs Linked Subreports
  • Creating an Unlinked Subreport
  • Linking a Subreport
  • Database Links vs Subreports
  • Creating On-Demand Subreports
  • Creating Hyperlinks
  • Using Subreports to Link "Unlinkable" Data

Power Grouping

  • Using the Group Expert
  • Customizing Group Names with Fields
  • Customizing Group Names with a Formula
  • Creating Custom Groups
  • Grouping on a Formula Field
  • Using Group Selection to Filter Records
  • Grouping Hierarchically
  • Create Customized Grouping
  • Using Group Selection

Cross Tab Reports

  • How Cross-Tabs Affect Your Data
  • Creating a Cross-Tab Report
  • Cross-Tab with Multiple Rows or Columns
  • Formatting Styles in Cross-Tabs
  • Changing the Summary Operation
  • Suppressing Rows, Columns or Totals
  • Charting Cross-Tabs

Report Alerts

  • What are Report Alerts
  • Creating and Working with Report Alerts

Report Templates

  • What is a Report template
  • Standard Report Wizards and Templates
  • The Template Expert
  • Applying a Template and Template Considerations
  • Creating Your Own Templates
  • Inserting and Formatting Template Fields