Course Description
Mastering Crystal Reports 2008 online training will prepare you to create beginning, intermediate and advanced Crystal Reports based on a variety of data sources. Whether you are using the current version or earlier versions of Crystal Reports, you will learn to create list reports, grouped reports, sub-reports, aging reports and cross tab reports. This online training course will enable you and your co-workers to make better business decisions more rapidly and to determine trends more quickly.
In This Course You Will Learn:
-
Design Crystal Reports
-
Develop formulas and functions for customized calculations
-
Format Crystal Reports in a professional manner
-
Creative interactive Crystal Reports using parameters
-
Export Crystal Reports to other applications
Prerequisites
Prior use and familiarity with databases and queries.
Outline
Module 00: Mastering Crystal Reports 2008 Online Training - Course Introduction
Module 01: Introduction to Crystal Reports 2008
-
What is Crystal Reports?
-
What is Business Intelligence?
-
Why would you switch?
-
New features
-
Creating your first simple report
Module 02: Writing Your First Report
-
The course database
-
Download the course database
-
Employee table
-
Order table
-
Customer table
Module 02 A: First Report Lab
Module 03: Connecting to Varieties of Data Sources
-
Direct versus indirect connections
-
How to connect to database files
-
How to connect to SQL servers
-
How to connect to Excel spreadsheets
-
How to connect to text files
Module 03 A: Varieties of Data Sources Lab
Module 04: Designing Reports
-
Single table reports and summarizing data
-
Multi-Table reports
-
Table relationships
-
SQL commands
Module 04 A: Designing Reports Lab
Module 05: Customizing Reports
-
The field explorer
-
The report explorer
-
How to create mailing labels
-
How to create cross tab reports
-
How to create a standard report
Module 05 A: Customizing Reports Lab
Module 06: Parameters
-
Interactive reports
-
How to create parameters
-
Text parameters
-
Date parameters
-
Parameters and text boxes
-
How to create a sub-report
Module 06 A: Parameters Lab
Module 07: Working with Charts and Graphs
-
The charting Features
-
How to create a column chart
-
How to create pie charts
-
How to create gauge charts
Module 07 A: Charts and Graphs Lab
Module 08: Exporting
-
To CSV
-
To PDF
-
To RPT
-
Crystal Report Viewer 2008
-
To Excel
-
To Word
-
To Access
Module 08 A: Exporting Lab
Module 09: Formatting Reports
-
Fields
-
Conditional formatting
-
Report sections
-
Repeated group headers
-
Printing reports
Module 09 A: Formatting Reports Lab
Module 10: Grouping and Sorting
-
Single level grouping
-
Multi level grouping
-
Grouping by dates
-
Custom grouping
-
Single column sorting
-
Multi column sorting
-
Custom sorting
Module 10 A: Grouping and Sorting Lab
Module 11: Reports from the Real World Part 1
-
How to do an inventory report
-
How to design an aging report
-
How to group data by shift when shift is not in the database
-
How to converting from non-numbers to dates
Module 11 A: Reports-Real World Part 1 Lab
Module 12: Reports from the Real World Part 2
-
How to display who is turning 18 years old - in 30, 60, 90 days
-
How to make a list of customers who have ordered baseball bats
-
Finding the total of products in a certain range
-
Display a number of records randomly from a database
-
How to compare total sales for each of the last three years
Module 12 A: Reports-Real World Part 2 - Lab
Module 13: Mastering Crystal Reports 2008 Online Training - Course Summary