Monday, September 06, 2010
Crystal 11 Level 1 Minimize
Class Time 2 Days (8:30am-3:30pm)
Prerequisite: PC experience, Introduction to Windows, or experience within the Windows environment. Experience in using a mouse and reasonable degree of keyboard proficiency.

Topics covered in this class include:
GETTING STARTED
  • Introduction
  • What is Crystal Reports
  • Starting Crystal Reports
  • The Crystal Reports Environment
  • Crystal Reports Default Settings
  • Planning a Report
  • Data Types
  • Exploring Help
CREATE A BASIC REPORT 2-1
  • Introduction
  • Open an Existing Report
  • Create a Report Using the Report Expert
  • Report Wizard
  • Planning a Report
  • Design View vs. Preview
  • Building a Report
  • Adding a Report Title (text objects)
  • Formatting a Report
  • Align Fields
  • Additional Report information
  • Previewing a Report Before Printing Saving the Report With or Without the Data
DISPLAYING DATA IN REPORTS
  • Introduction
  • Create a Custom Report (Review of procedure)
  • Finding Specific Data
  • Sorting Data
  • Filtering Data in a Report (Record Selection)
  • Using the Report Explorer
GROUPING DATA IN REPORTS
  • Introduction
  • Inserting a Group
  • Adding Summaries to a Report
  • Change Group Options
  • Adding Additional Groups
  • Changing the Group Order/Deleting Groups/Undo
  • Formatting Group Headers
  • Filter by Group (Using a formula to filter groups)
  • Create a Top N Sort Group
  • Groups That Sort Using a Specified Order
  • Drill Down Reports
USING BASIC FORMULAS IN A REPORT
  • Introduction
  • Formula Creation
  • Formula Workshop
  • Creating a Concatenation Formula
  • Date Time Formulas
  • Creating an If…Then…Else Formula
  • Using Formulas to Group
  • Deleting a Formula Field
  • Dealing With NULLs in Formulas
FORMATTING IN CRYSTAL REPORTS
  • Introduction
  • Resize a Section
  • Special Page Fields
  • Header/Footer
  • Borders and Lines
  • Create Conditional Formatting for Sections
  • Using the Highlighting Expert
ENHANCING A REPORT
  • Introduction
  • Creating Multiple Sections
  • Suppress a Blank Section
INSERT A PARAMETER FIELD
  • What is a Parameter?
  • Create and insert a parameter field on a report
  • Creating a List of Values
  • Manually Entering a List of Values
  • Using a Table to Populate the List of Values
  • Importing a value list from a text file
  • Incorporate the parameter into the selection criteria
  • Use a parameter field in a formula
  • Dynamic Value Lists
  • Creating Cascading Pick Lists
DISTRIBUTING REPORTS
  • Introduction
  • Print a Report
  • Export format types
  • Export a Report to a Spreadsheet Format
  • Creating a Report Definition
ADDITIONAL CRYSTAL REPORTS FEATURES
  • Introduction
  • The Crystal Reports XI Workbench
  • Using the Workbench
  • The Crystal Reports XI Dependency Checker
    

Copyright 2009 by The Continuous Improvement Center