Crystal Reports

5 Sessions –

15 Hours of Interactive Training

LearnKey's Crystal Reports course, taught using Crystal Reports XI, provides comprehensive instruction for anyone who wants to use one application to create elegant and complex reports from a variety of data sources. Expert instructor Erin Olsen walks you through the application, exploring the interface and showing you how to design your report and connect to various data sources. You'll learn how to work with text objects, formulas, parameters, and much more in order to start creating publication-quality reports right away!

Benefits

Crystal Reports creates professional reports, attaching to virtually any data source.

Every report can be produced by one single function.

Crystal Reports can be utilized in nearly every industry for comprehensive reporting.

About The Author

Since founding PCKeys Technology Solutions in 1995, Erin Olsen has personally trained more than 10,000 people worldwide in a wide variety of applications and technologies, and she has helped many organizations transition to using Microsoft, Adobe and Macromedia software tools. A Microsoft Office Specialist Master Instructor, Erin enjoys a reputation for providing solid foundations in skills applicable to real-world needs in an easy-to-understand and fun manner. She combines technical knowledge with real-world experience allowing her to provide a wealth of practical examples and inside tips to help her audience learn, retain and actually apply their skills.

Session 1

Section A: Introduction
· Benefits
· Editions
· Versions

Section B: Designing Reports
· Defining the Purpose
· Planning the Layout
· Examples of Reports
· Choosing Data
· Laying Out the Report
· The Workbench

Section C: Data Connections
· Database Expert
· Data Source Options
· Access/Excel Connections
· ODBC Connections
· Selecting Database Objects
· Database Object Types

Section D: Relational Database Review
· Simple Databases
· Relational Database
· Fields and Records
· Table Relationships
· Data Types
· Xtreme Sample Database

Section E: Interface Overview
· Toolbars
· Start Page and Report Tabs
· Design/Preview Views
· Field Explorer
· Report/Repository Explorers
· Sample Reports

Section F: Creating Basic Reports
· Blank Report
· Placing Fields on Reports
· Previewing Field Data
· Selecting/Sizing Fields
· Aligning/Moving/Using Guides
· Customizing Layout Options
· Creating Report Titles
· Finishing Touches

Section G: Previewing, Saving, and Deleting
· Saving Reports
· Previewing Reports
· Deleting Fields

Section H: Working with Text Objects
· What is Concatenation?
· Adding Text Fields
· Concatenating Text and Data
· Editing Concatenations
· Creating a Form Letter
· Formatting Fields
· Special Fields

Session 2

Section A: Basic Formatting
· Template Expert
· Page Margins and Orientation
· Font and Alignment
· Formatting Multiple Selections
· Format Painter
· Formatting Editor Options
· Customizing Formatting Editor
· Preview Formatting

Section B: Adding Graphical Elements
· Inserting Lines
· Border Styles and Colors
· Drawing/Formatting Boxes
· Inserting Pictures

Section C: Filtering Records
· Case Sensitivity
· Select Expert
· Select Statements
· And Statements
· Or Statements
· Editing Formulas
· Formula Workshop
· Help Menu Options

Section D: Grouping and Sorting
· Insert Group
· Insert Group Options
· Keeping Groups Together
· Group Tree
· Reordering Groups
· Grouping Multiple Fields
· Changing/Deleting Fields
· Record Sort Expert

Section E: Advanced Grouping Options
· Inserting Summaries
· Adding Labels
· Formatting Calculations
· Modifying Labels and Calculations
· Creating a Grand Total
· Group Sort Expert
· Grouping on Data Fields

Section F: Conditional Formatting
· Conditional Highlighting
· Reordering Highlight Conditions
· Removing Highlight Conditions
· Conditional Formatting Formulas
· Formatting Groups

Section G: Running Totals
· Running Total Fields
· Running Totals by Group
· Running Total Counts

Session 3

Section A: Formula Overview
· Formula Uses
· Function Basics
· Syntax Rules
· Formula Workshop
· Formula Editor

Section B: Creating Formulas
· New Formula Field/Workshop
· Multiplying Fields
· Calculating Fax
· Adding Fields
· Spot Checking Calculations

Section C: Manipulating Data with Formula
· Date Added
· Date Add Arguments
· Concatenated Formulas
· Converting Dates to Text
· Boolean Fields
· Nested If-Then-Else Statements

Section D: Basic Parameters
· Parameter Uses
· Considerations
· Characteristics and Options
· Value Choices
· Static List Parameters
· Dynamic List Parameters
· Exporting Data
· Importing Data

Section E: Advanced Parameter Applications
· Creating Dynamic Fields
· Range of Dates
· Range of Values
· Minimums and Maximums
· Default Values/Edit Masks
· Selection Formulas
· Sort Parameters

Section F: Formulas Timing
· Passes
· Pass Phase 1
· Pass Phase 2
· Specifying When Formulas Run
· Variables
· Declaring Variables
· Setting Variables
· Using Variables

Section G: Controlling Formula Runtime
· Sample Report
· Manual Running Totals
· Resetting Running Totals
· Displaying Variable Values
· Suppressing Details
· Refreshing the Report

Crystal Reports

Crystal Reports

Crystal Reports continued