Crystal Reports 2008 Introduction Training

How To Take This Class:

Live Instructor-Led Online Class > View Schedule or Register
Onsite Group Training > Request Pricing

Instructor-Led Online Course Tuition:

$650.00

Course Duration:

2 Days

Course Description:

Crystal Reports 2008 enhances report building and report processing techniques with many new value-added features. In this Crystal Reports 2008 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 interface.
Create a basic report and modify it.
Use formulas for filtering data.
Group report data.
Enhance a report.
Create a report using data sourced multiple data sources.
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:

Creating a Report

Starting the Crystal Reports Program
Starting a New Report
Choosing a Data Source
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
Auto-saving the Report
Previewing the Report
Refreshing the Data
Using the Status Bar
Getting Help
Challenge Exercise – Creating a Basic Report

Formatting Features

Quick Formatting with the Template Expert
Using the Format Painter
Formatting Objects
Inserting Lines and Boxes
Inserting Graphics
Working with the Page Commands
Changing Page Orientation
Changing Margins
Working with Text Objects
Adding Fields into a Text Object
Formatting Part or All of an Object
Inserting Special Fields
Challenge Exercise – Formatting Features

Database Filters

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
Challenge Exercise – Selecting Specific Records
Challenge Exercise – Selecting a Range of Values

Report Grouping

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
Using the Sort Control
Summarizing Groups
Additional Summary Options
Grouping Data in Date/Time Intervals
Calculating Percentages
Ordering Groups Based on Their Subtotals Using the Group Sort Expert
Challenge Exercise – Grouping, Sorting, Summarizing
Challenge Exercise – Calculating Percentages

Multiple Table Joins

Understanding Tables, Records, and Fields
Learning About Linking
Adding Multiple Tables to a Report
Challenge Exercise – Using the Database Expert to Link Tables

Creating Formulas

Understanding Crystal Formula Syntax without Being a Programmer
About the Formula Workshop
Using the Formula Workshop
Using the Formula Editor
The Formula Editor Toolbar
Performing Simple Number Calculations
Manipulating Dates with Formulas
Creating Boolean (True/False) Formulas
Creating String Formulas
Using Bookmarks to Navigate Through Formulas
Challenge Exercise – Creating String Formulas
Challenge Exercise – Creating String Formulas
Challenge Exercise – Doing Calculations
Challenge Exercise – Subtracting Dates
Challenge Exercise – Using Nested If Statements

Conditional Formatting

Formatting Sections
Formatting Sections Conditionally
Conditionally Formatting Fields
Challenge Exercise – Section Formatting and Conditional Formatting
Summary Reports and Charts

Creating a Summary Report

Applying the Drill Down Feature
Applying the DrillDownGroupLevel
Producing Charts
Editing Charts
Formatting Charts
Using the Chart Options
Modifying Individual Objects in the Chart
Applying Chart Templates
Challenge Exercise – Creating a Summary Report
Challenge Exercise – Charting

Exporting Reports

Understanding Export Formats and Destinations
Using a PDF Format for Crystal Reports
Exporting to Windows Applications
Exporting to a Report Definition Format

Report Wizards

What are the Report Wizards?
Create a Report Using the Standard Report Creation Wizard
The Data Dialog Box
The Fields Dialog Box
The Grouping Dialog Box
The Summaries Dialog Box
The Group Sorting Dialog Box
The Chart Dialog Box
The Record Selection Dialog Box The Template Dialog Box
Challenge Exercise – Create a Report Using a Report Wizard.

See a Sample:

See a sample of one or our live, instructor-led online Crystal Reports 2008 courses: Dynamic Cascading Prompts in Crystal Reports 2008