Course Description | Course Outline |Data Warehousing | IT Training

1. Before You Begin

• Defining the Purpose of the Report
• Determining the Layout of the Report
• Finding the Data
• Organizing the Data for the Report
• The Workbench

2. Creating a Simple Report

• Starting the Crystal Reports Program
• Starting a New Report
• The Main Components of the Design Window
• Exploring the Toolbars
  Managing Resources with Explorers
• Placing Fields on the Report
• Selecting and Sizing Objects
• Browsing Field Data
• Moving and Aligning Objects
• Using Guides and Guidelines to Move and Align Objects
• Creating Text Objects
• Saving the Report
• Autosaving the Report
• Previewing the Report
• Refreshing the Data
• Getting Help

3. Formatting Features

• Quick Formatting with the Template
• Expert Formatting Objects
• Format Painter
• Inserting Lines and Boxes
• Drawing a Line
• Drawing a Box
• Inserting Graphics
• Working with the Page Commands
• Working with Text Objects
• Adding Fields into a Text Object
• Formatting Part or All of an Object
• Inserting Special Fields

4. Selecting Specific Records From the Database

• Filtering Data with the Select Expert
• Selecting Records with Multiple Criteria
• Viewing and Editing the Select Formula
• Case Sensitive vs. Case Insensitive
• Record Selection Formula Templates

5. Grouping and Sorting Data

• When and Why to Group Records
• Creating a Group
• Group and Sort Direction
• Customize Group Name Field
• Modifying Groups
• Creating Multiple Groups in a Report
• Using the Group Tree to Navigate the Report
• Reordering Groups
• Sorting Records within a Group
• Summarizing Groups
• Additional Summary Options
• Grouping Data in Date/Time Intervals
• Calculating Percentages