Crystal Reports 2011 Introduction Training

How To Take This Class

Live Instructor-Led Online Class

Cost: $695.00

  • Open enrollment class for individuals
  • Live class with an instructor
  • Free class retakes forever!
  • Six months of instructor email support
  • Hands-on exercises and student labs
  • Classes never cancelled due to low enrollment
  • Money-back guarantee

Onsite or Offsite Group Training

Cost: Based on number of students

  • For groups as small as 3 people
  • Class Held at our location or yours
  • Hands-on exercises and student labs
  • Customization at no extra charge
  • Six months of instructor email support
  • All-inclusive pricing
  • Money-back guarantee
Request Group Pricing Proposal

Course Duration

2 Days

What Students Receive

Each student will receive:
  • A printed courseware manual with hands-on exercises and samples for use during and after class.
  • A PC headset for communicating with your instructor and fellow students during your Crystal Reports 2011 Training Class
  • A course completion certificate upon successful completion of your Crystal Reports 2011 Training course
  • Six months of post-class email support from a Crystal Reports 2011 Instructor

Course Description

Crystal Reports 2011 enhances report building and report processing techniques with many new value-added features. In this Crystal Reports 2011 Introduction Training course, students will create a basic report by connecting to a database and modifying its presentation.

Course Objectives

Upon successful completion of this course, students will be able to:
  • Explore the Crystal Reports 2011 interface.
  • Create a basic report and modify it.
  • Use formulas for filtering data.
  • Group report data.
  • Enhance a report.
  • Create a parameterized report.
  • Distribute reports.

Course Audience

This course is designed for persons who need output from a database. In some cases, database programs have limited reporting tools, and/or such tools may not be accessible. Students may or may not have programming and/or SQL experience.

Course Prerequisites

Students should have experience navigating in a Windows environment. Some experience with Microsoft Access or an understanding of database concepts is also helpful.

Course Syllabus

  1. Exploring Crystal Reports 2011
    • Crystal Reports 2011 Interface
      • Report Development
      • Touring Crystal Reports
    • Toolbar Overview
    • Program Customization
    • Viewing a Sample Report
    • Report Layout
      • Navigation Tabs
      • Conditionally Formatted Fields
      • Grouping
      • Subtotals
      • Design Tab
      • Preview Tab
      • Close the report
  2. Creating and Modifying Reports
    • Creating a Report
      • Defining a Report
      • Data Sources
      • Creating a Report
      • The Database Expert Tool
    • Exploring the Design tab
      • Report Sections
    • Adding Fields to a Report
    • Adjusting Field Position and Size
      • Resizing Fields
      • Moving Fields
    • Previewing Field Data
    • Aligning Field Data
      • Selecting Fields
      • Aligning Fields
    • Creating a Text Object
    • Saving the Report
      • Saving the Data with the Report
    • Previewing Report Data
      • Preview Data Methods
      • Navigating the Previewed Data
      • Locally Stored Data
  3. Formatting Number-based Fields
    • Formatting Introduction
    • Accessing the Formatting Options for a Field
    • Formatting Numbers
    • Formatting Currency
    • Formatting Date and Time
  4. Grouping, Sorting and Filtering
    • The Importance of Grouping Records
      • The Group Expert
    • Sorting Records with the Record Sort Expert
    • Filtering Records with the Select Expert
      • The Stages of Filtering
      • Select Expert Filter Methods
      • Implementing Record Filters with the Select Expert
      • Filtering Records with Multiple Criteria
      • Modifying Existing Filter Criteria
      • Deleting Filter Criteria
      • Changing Multiple Filter Criteria Logic
    • Creating Group Summary Calculations
      • Summary Operators
      • Grand Totals
      • Group Totals
    • Cleaning Up the Report
    • Calculating Percentages in Summaries
    • Sorting Groups According to Subtotal Rankings
  5. Additional Formmatting Objects
    • Adding Lines
      • Accessing the Formatting Options for a Line
      • Adding Vertical Lines to a Report
    • Adding Boxes
      • Accessing the Formatting Options for a Box
    • Inserting Graphics
    • Formatting Page Options
      • Printer Options
      • Page Options
      • Margins
    • Combine Fields with Text Objects
    • Insert Special Fields
      • Special Fields
      • Document Properties
  6. Working with Formulas
    • Creating a Formula
      • Crystal Formula Syntax
      • Formula components and syntax
    • The Formula Workshop
      • Toolbars
      • Workshop Tree
      • Formula Editor
      • Tables and Fields
      • Functions
      • Operators
    • Simple Formulas
      • Checking for Syntax Errors in Formulas
      • Recycling Formula Fields
    • Handling NULL Values
      • Crystal Reports – How Nulls are handled
      • Handling Nulls via formulas
  7. Working with Multiple Tables
    • Understanding Database Components
      • Fields
      • Tables
      • Records
      • Keys
    • Joining Tables and Join Types
      • Outer Join
      • Inner Join
      • Left Join
      • Right Join
    • Adding Multiple Tables with the Database Expert
      • Linking Multiple Tables
  8. Conditional Formatting
    • Formatting Section Behavior
      • Common Tab
      • Paging Tab
      • Color Tab
      • Layout Tab
    • Formatting Sections with Conditional Logic
    • Suppressing Sections Conditionally
      • Hiding vs. Suppressing
    • Formatting Fields Conditionally
  9. Summary Reports and Charting
    • Creating a Summary Report
      • Hide: (Drill-Down OK)
      • Suppress (No Drill-Down)
    • Utilizing Drill-Down to View Report Details
    • Creating Charts with the Chart Expert
      • Placing and Sizing Charts
    • Formatting and Editing Charts
      • The Data Tab
      • The Type Tab
      • The Axes Tab
      • The Options Tab
      • The Color Highlight Tab
      • The Text Tab
      • Modifying Existing Charts
      • Zooming In and Out on Charts
    • Formatting Individual Chart Objects
      • Chart Expert
      • Format Chart
      • Format Background
      • Chart Options
      • Auto-Arrange
  10. Exporting Reports
    • The Need to Export
      • Export Types
    • Export Formats
      • Character Separated Values
      • Crystal Reports (RPT)
      • RPTR
      • RTF
      • Microsoft Excel
      • HTML (3.2 and 4.0)
      • PDF (Portable Document Format)
      • Text
      • Microsoft Word
      • XML
      • Record Style – Column with spaces
      • Record Style – Column without spaces
      • Report Definition
    • Export Destinations
      • Application
      • Disk File
      • Exchange Folder
      • MAPI (Messaging Application Programming Interface)
    • Previewing with HTML