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

09-04-2017–09-05-2017 Add To Cart/Register

09-25-2017–09-26-2017 Add To Cart/Register

10-16-2017–10-17-2017 Add To Cart/Register

11-06-2017–11-07-2017 Add To Cart/Register

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

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

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

Formatting Number-based Fields

Formatting Introduction
Accessing the Formatting Options for a Field
Formatting Numbers
Formatting Currency
Formatting Date and Time

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

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

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

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

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

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

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