Crystal Reports Training
Crystal Reports 8.5 CD
 This is a two part series that introduces the student to the
purpose and features of Crystal Reports. It teaches the basics of designing reports, record selection, record grouping and sorting, formatting reports, and distributing reports. Students
will learn to create and distribute a simple report.
In the 2nd part of the series, learners will be working with formulas, linking reports, working with Cross-tabs, formatting sections, creating charts, and creating geographical maps.
After completing this course, learners will be able to use some of the advanced Crystal Reports tools to create more interactive and visually appealing reports.
Detailed Crystal Reports Training 8.5 course topics are listed below.
Crystal Reports 8.0 - Set of 7 Videos or CD's
 The largest challenge with data and databases is creating the reports
people will use and that provide useful information.
Upon completion of this Crystal Reports 8.x course you will quickly create and customize reports that will be useful and informative.
See the detailed Crystal Reports Training 8.0 course topics listed below.
Crystal Reports 7 - Levels 1-5 Training Videos or CD's
 This course will teach you to create and manage your own reports.
Learn to
define parameters
integrate reports with SQL
format and more.
Crystal Reports 7 Training Course Description
Crystal Reports Training Courses on Videos or CDs
|
Crystal Reports 8.5 CD's Details
|
$258.00
|
n13889d
|
|
|
Crystal Reports 8 - Set of 7 Videos Details
|
$549.95
|
kycr80v
|
|
|
Crystal Reports 8 - Set of CD's Details
|
$599.95
|
kycr80m
|
|
|
Crystal Reports 7 (Levels 1-5) Videos Details
|
$399.95
|
kycr70v
|
|
|
Crystal Reports 7 Levels 1-5: CD Details
|
$399.95
|
kycr70m
|
|
Crystal Reports 8.5 Training CD |
|
Part 1
Unit 1: Crystal Reports: Fundamentals
2 - 3 hours
• Match the features of Crystal Reports with the situations in which the features can be used.
• Create a blank report by using the menu bar.
• Match the types of reports with the situations in which the reports can be used.
• Create reports by using Report Expert.
• Insert a field in a report by using the Field Explorer dialog box.
• Format an object in a specific way by using the menu bar.
• Combine fields in a text object by using the Field Explorer dialog box.
• Import text from a file into a text object by using the shortcut menu.
Unit 2: Records: Manipulation
2 - 3 hours
• Create a record selection by using the menu bar.
• Modify a record selection formula by using the menu bar.
• Sort records in a report by using the menu bar.
• Group records in a report by using the menu bar.
• Modify a record group by using the menu bar.
• Summarize a record group by using the menu bar.
• Insert a running total field in a report by using the menu bar.
Unit 3: Reports: Presentation and Distribution
2 hours
• Format a record field by using the menu bar.
• Format a paragraph in a report by using the menu bar.
• Insert special fields in a report by using the menu bar.
• Insert a box in a report by using the menu bar.
• Insert a picture in a report by using the menu bar.
• Export a report to an application by using the menu bar.
• Export a report to an ODBC data source by using the Export dialog box.
• Send a report to an e-mail recipient by using the Export dialog box.
Part 2
Unit 1: Formulas and Links
2 - 3 hours
• Match the types of Crystal Reports formulas with the situations in which they are used.
• Match Mathematical functions with the situations in which they are used.
• Match String functions with the situations in which they are used.
• Match Date/Time functions with the situations in which they are used.
• Match Programming shortcut functions with the situations in which they are used.
• Create a formula by using Formula Editor.
• Create a report alert by using the Report menu.
• Add data from a database to a report by using the menu bar.
• Link database tables by using the Visual Linking Expert window.
• Create a dictionary by using the Crystal Reports Tools menu.
• Create a SQL query by using the Create SQL Expert dialog box.
Unit 2: Sections and Cross-Tab Objects
2 - 3 hours
• Insert a section in a report by using the Insert menu.
• Identify the properties used to format a section according to specific requirements.
• Create a cross-tab object in a report by using the Insert menu.
• Identify the options used to customize a cross-tab object according to specific requirements.
Unit 3: Maps and Charts
2 hours
• Match the types of maps with the situations in which they are most appropriate.
• Create a map by using the Map Expert dialog box.
• Arrange the layers in a map in the specified order by using the Layer Control dialog box.
• Resolve data mismatches by using the Map Region Resolver dialog box.
• Match the types of charts with the situations in which they are used.
• Create a chart by using the Chart Expert dialog box.
• Identify the chart-formatting tab that is used to meet a specified requirement.
Crystal Reports 8.0 Training |
|
Level 1 (1 Hr 47 Mins)
1.0 The Basics (17 Mins)
1.1 Launching Crystal Reports
1.2 The Application Window
1.3 Exploring Sample Reports
2.0 Creating a Simple Report (29 Mins)
2.1 Using the Create Report Expert
2.2 Previewing the Report
2.3 Designing a Report from Scratch
2.4 Inserting Fields
2.5 Browsing Field Data
2.6 Moving & Sizing Report Objects
2.7 Placing Text Objects on the Report
3.0 Managing Reports (9 Mins)
3.1 Saving a Report
3.2 Closing a Report
3.3 Modifying a Report Description
3.4 Opening an Existing Report
3.5 Switching Between Open Reports
4.0 Getting Help (8 Mins)
4.1 On-line Help & Searching for a Help Topic
4.2 Context-Sensitive Help
4.3 Printing a Help Topic
4.4 Seagate Software on the Web
5.0 Selecting Records (17 Mins)
5.1 The Select Expert
5.2 Using Saved versus Refreshed Data
5.3 Expert Options
5.4 Criteria Based on More than One Field
5.5 Removing a Report Selection
6.0 Sorting, Grouping, & Summarizing (27 Mins)
6.1 Sorting Records
6.2 Grouping Records
6.3 Working with Group Trees
6.4 Deleting & Changing Groups
6.5 Inserting Summary Calculation
6.6 Defining Other Summary Calculations
Level 2 (1 Hr 57 Mins)
1.0 Reports Based on More than One Table (24 Mins)
1.1 Using the Create Report Expert
1.2 Modifying a Report Created with the Expert
1.3 Building a Multi-table Report without the Expert
2.0 Enhancing Your Report with Formatting (17 Mins)
2.1 Changing the Font of a Text or Field Object
2.2 Adding Borders & Drop Shadows
2.3 Formatting Numeric Data
2.4 Changing Object Alignment
3.0 Utilizing Conditional Formatting (23 Mins)
3.1 Absolute Formatting
3.2 Conditional Formatting
3.3 The Highlighting Expert
3.4 Modifying & Deleting a Conditional Format
4.0 Creating Formulas with Crystal Syntax (47 Mins)
4.1 The Formula Editor & Inserting Formulas
4.2 Changing Numbers to Words
4.3 String Manipulation
4.4 Date Calculations
4.5 Creating Summary Calculations & Totaling By Group
4.6 Working with Running Totals
4.7 Running Sums
4.8 If-Then-Else Formulas
5.0 Creating Formulas with Basic Syntax (6 Mins)
5.1 Creating Formulas & Entering Code
5.2 Adding Comments
Level 3 (2 Hrs)
1.0 Parameter Fields (19 Mins)
1.1 Creating Parameters Fields
1.2 Working with Multiple Parameter Fields
1.3 Adding a Parameter Field to a Printed Report
1.4 Deleting Parameters
2.0 Formatting Report Sections (36 Mins)
2.1 Changing the Size of a Section
2.2 Sizing a Section Automatically
2.3 Inserting & Deleting Lines
2.4 Using the Selection Expert
3.0 Advanced Grouping Techniques (16 Mins)
3.1 Grouping & Sort Direction & Custom Groups
3.2 Sorting within a Group
3.3 Grouping on Intervals
4.0 Finishing Touches (17 Mins)
4.1 Using the Style Expert
4.2 Creating Special Fields
4.3 Special Text Object Features
4.4 Working with Lines & Boxes
4.5 Adding Pictures to Your Report
5.0 Including Cross-Tabulations in Your Reports (32 Mins)
5.1 Creating a Cross-Tab Report Using the Cross-Tab Expert
5.2 Creating a Cross-Tab Report without an Expert
5.3 Modifying the Data included in a Cross-Tab Report
5.4 Formatting a Cross-Tab Report
Level 4 (2 Hrs 3 Mins)
1.0 Summary Reports (19 Mins)
1.1 Building a Summary Report
1.2 Allowing or Disallowing Drill-downs
2.0 Running Totals Reports (22 Mins)
2.1 Creating Running Totals Overall
2.2 Creating Running Totals for a Group
2.3 Creating Conditional Running Totals
2.4 Creating Running Totals with a One-to-Many Relationship
3.0 Top N (10 Mins)
3.1 Creating a Report with the Top N Values
3.2 Creating a Report with the Bottom N Values
4.0 Working with Subreports (20 Mins)
4.1 Creating an Unlinked Subreport
4.2 Creating a Linked Subreport
4.3 On-demand Subreports
5.0 Advanced Record & Group Selection (22 Mins)
5.1 Setting up Group Selection
5.2 Creating a Record or Group Selection Formula
6.0 Mailing Labels (9 Mins)
6.1 Creating Mailing Labels
6.2 Modifying the Attributes of Mailing Labels
7.0 Form Letters (21 Mins)
7.1 Creating a Form Letter with the Expert
7.2 Modifying Attributes of a Form Letter
7.3 Creating a Form Letter without the Expert
7.4 Customizing a Form Letter for Different Recipients
Level 5 (1 Hr 40 Mins)
1.0 Working with Data (54 Mins)
1.1 Databases Overview
1.2 Aliases
1.3 Indexes
1.4 Relationships
1.5 SQL & SQL Databases
1.6 Server-side Processing
1.7 Mapping Database Fields
1.8 Working with Different Types of Data
1.9 Advanced Database Features
1.10 Reporting on the NT Event Log
1.11 Reporting on Exchange or Outlook Data
2.0 Using SQL (Structured Query Language) (16 Mins)
2.1 What is SQL? & Creating a Report Based on an ODBC Datasource
2.2 Building a SQL Query
2.3 Modifying SQL Options
3.0 The Crystal Query Designer (18 Mins)
3.1 Why Use a Query
3.2 Creating a Query
3.3 Modifying the Query
3.4 Creating a Report from a Query
3.5 Basing a Query on a Query
4.0 Creating a Data Dictionary (12 Mins)
4.1 Why Use a Data Dictionary?
4.2 Creating a New Data Dictionary
4.3 Basing a Report on a Dictionary
4.4 Setting Dictionary Options
Level 6 (1 Hr 58 Mins)
1.0 Advanced Formula Techniques (51 Mins)
1.1 Creating a Complex Formula
1.2 Using a Variable
1.3 Assigning a Value to a Variable
1.4 Using Arrays in Formulas
1.5 Using Ranges in Formulas
1.6 Debugging Formulas
2.0 Charting Your Report Data (1 Hr 7 Mins)
2.1 Creating a Group Chart
2.2 Creating a Detail Formula Chart
2.3 Creating a Cross-tab Chart
2.4 Modifying Chart Options
2.5 Drilling Down on a Graph
2.6 Re-entering the Chart Expert
2.7 Using a Graph Template
Level 7 (2 Hrs 17 Mins)
1.0 Mapping (44 Mins)
1.1 Mapping on Grouped Fields
1.2 Modifying Map Attributes
1.3 Mapping on Detail Fields
1.4 Mapping on Cross-tab Summaries
1.5 Using the Map Analyzer
2.0 OLE (27 Mins)
2.1 OLE Introduced
2.2 Adding OLE Objects to a Report
2.3 Working with Static OLE Objects
2.4 Embedded vs. Linked Objects
3.0 External Data Sources (25 Mins)
3.1 Dbase/FoxPro
3.2 The File System
3.3 NT Event Log
3.4 Exchange
3.5 Outlook
4.0 Distributing Reports (7 Mins)
4.1 Exporting a Report
4.2 Mailing a Report
5.0 Distributing Reports Over the Web (15 Mins)
5.1 Saving a Report as HTML
5.2 Crystal Web Report Server
5.3 Building Active Web Sites
6.0 Integrating with Visual Basic (19 Mins)
6.1 The Crystal Report Engine API
6.2 Crystal Act
Crystal Reports 7.0 Training |
|
Level 1 (2 Hrs 10 Mins)
1.0 The Basics (14 Mins)
1.1 Launching Crystal Reports
1.2 The Application Window
1.3 Exploring Sample Reports
2.0 Creating a Simple Report (39 Mins)
2.1 Selecting a Report Type
2.2 Using the Create Report Expert
2.3 Previewing the Report
2.4 Designing a Report from Scratch
2.5 Inserting Fields
2.6 Working with the Design Tab
2.7 Moving & Sizing Report Objects
2.8 Browsing Field Data
2.9 Placing Text Objects on the Report
3.0 Managing Reports (10 Mins)
3.1 Saving a Report
3.2 Closing a Report
3.3 Opening an Existing Report
3.4 Switching Between Open Reports
4.0 Getting Help (13 Mins)
4.1 On-line Help
4.2 Context-Sensitive Help
4.3 Searching for a Help Topic
4.4 Printing a Help Topic
4.5 Seagate Software on the Web
5.0 Selecting Records (21 Mins)
5.1 The Select Expert
5.2 Using Saved versus Refreshed Data
5.3 Expert Options
5.4 Criteria Based on Multiple Fields & Removing a Report Selection
6.0 Sorting
6.1 Sorting Records
6.2 Grouping Records
6.3 Working with Group Trees
6.4 Deleting Groups
6.5 Hiding & Changing Groups
6.6 Inserting Summary Calculations
6.7 Inserting Grand-Totals
7.0 Enhancing Your Report with Formatting (12 Mins)
7.1 Changing the Font of a Text or Field Object
7.2 Adding Borders
Level 2 (2 Hrs 1 Min)
1.0 Reports Based on More than one Table (25 Mins)
1.1 Using the Create Report Expert
1.2 Modifying the Table
1.3 Building a Multi-table Report without the Expert
2.0 Working with Formulas (51 Mins)
2.1 The Formula Editor & Inserting Formulas
2.2 Changing Numbers to Words
2.3 String Manipulation
2.4 Date Calculations
2.5 Totaling by Group
2.7 If-Then-Else Formulas
3.0 Parameter Fields (20 Mins)
3.1 Creating & Responding to a Parameter Field Prompt
3.2 Working with Multiple Parameters Fields
3.3 Adding a Parameter Field to Printed Reports
4.0 Utilizing Conditional Formatting (24 Mins)
4.1 Absolute Formatting
4.2 Conditional Formatting
4.3 Modifying & Deleting Conditional Formats
Level 3 (2 Hrs 9 Mins)
1.0 Formatting Report Sections (33 Mins)
1.1 Changing the Size of a Section
1.2 Inserting & Deleting Lines
1.3 Using the Section Expert
2.0 Finishing Touches (16 Mins)
2.1 Using the Style Expert
2.2 Creating Special Fields
2.3 Special Text Object Features
2.4 Working with Lines & Boxes
2.5 Adding Pictures to Report
3.0 Cross-Tabulations (42 Mins)
3.1 Crosstab with & without the Expert
3.2 Modify Data included in Cross Tab
3.3 Formatting Cross Tab
4.0 Summary Reports (9 Mins)
4.1 Building Summary Reports
4.2 Allowing & Disallowing Drill-down
5.0 Graphing (28 Mins)
5.1 Group Graph
5.2 Detail Formula Graph
5.3 Cross Tab Graph
5.4 Modify
5.5 PG Editor
5.6 Drill-downs & Graph Types
5.7 Graph Template
Level 4 (1 Hr 58 Mins)
1.0 Mailing Labels (12 Mins)
1.1 Creating
1.2 Modifying
2.0 Form Letters (23 Mins)
2.1 Creating with the Expert
2.2 Creating From Scratch
3.0 Top N (10 Mins)
3.1 Top N & Bottom N
4.0 Sub Reports (23 Mins)
4.1 Unlinked
4.2 Linked
4.3 On Demand
5.0 Advanced Record & Group Selection (20 Mins)
5.1 Setting up Group Selection
5.2 Creating Record Group Selection Formulas
5.3 Working with Selection Templates
6.0 Advanced Formula Techniques (29 Mins)
6.1 Using Variables in Formulas
6.2 Conditionally Assigning Values
6.3 Arrays
6.4 Ranges
Level 5 (1 Hr 57 Mins)
1.0 Using SQL (29 Mins)
1.1 What is SQL
1.2 Report Based on ODBC D.S.
1.3 Reports Based on Table in SQL Server Database
1.4 Modifying the SQL Statement
1.5 Modifying SQL Queries
1.6 Modifying SQL Options
2.0 Crystal Query Designer (21 Mins)
2.1 Why Use a Query?
2.2 Creating a Query
2.3 Adding & Linking Tables
2.4 Adding Fields
2.5 Query on Query &Report from Query
3.0 Data Dictionary (15 Mins)
3.1 Why Data Dictionary?
3.2 Creating a New Data Dictionary
4.0 External Data (13 Mins)
4.1 NT Event Log
4.2 Exchange Information
4.3 Outlook Data
5.0 Distributing (17 Mins)
5.1 Exporting
5.2 Mailing
5.3 Compiling
5.4 Report Distribution Expert
6.0 Distribution Over the Web (8 Mins)
6.1 Saving as HTML
6.2 Crystal Web Report Server
7.0 Integrating Crystal & Visual Basic (13 Mins)
7.1 Crystal Active X Control
7.2 Crystal Report Engine
|
