Crystal Reports 8
Training
Provided by Online Training Directory
This self-paced interactive course will give the student in-depth knowledge of Crystal Reports 8 and all of its functionality.
One of the greatest challenges in working with data and databases is creating useful, effective, and efficient reports that people will use to enhance the business capabilities of their companies. Upon completion of this course, the student will be able to quickly create and customize reports that will be useful and informative using Crystal Reports 8. The student will learn how to configure, develop, and run a variety of reports in different reporting environments.
This course comes with keynotes for each level of study.
|
|
||||||||
Crystal Reports 8
Outcomes
Upon completion of this course, students will be capable of installing and configuring Crystal Reports 8. Students will be able to quickly and accurately develop, run and analyze reports. They will have a very good understanding of the application, its potential and its functionality.
Assessment
This course provides a variety of quizzes and exams to test the students, learning and comprehension as they progress through the course. Built in to this course are pre and post course assessments for each of the 7 levels of training, assuring adequate feedback to the student on their progress and understanding of Crystal Reports 8.
Instructor: Alison Balter, your trainer, is a Microsoft Solution Provider, Microsoft Certified Systems Developer and Access Trainer who teaches Windows Systems, Access and other software products to all levels of users. She has over 15 years of experience working with corporations and government agencies. Alison is also a regular speaker for Advisor Publication Conferences. She is the President of The Independent Computer Consultants Association of Los Angeles.Course Outline: Level 1 The Basics
Contact Hours: 24
Upon completion of this course, students will be capable of installing and configuring Crystal Reports 8. Students will be able to quickly and accurately develop, run and analyze reports. They will have a very good understanding of the application, its potential and its functionality.
Assessment
This course provides a variety of quizzes and exams to test the students, learning and comprehension as they progress through the course. Built in to this course are pre and post course assessments for each of the 7 levels of training, assuring adequate feedback to the student on their progress and understanding of Crystal Reports 8.
Instructor: Alison Balter, your trainer, is a Microsoft Solution Provider, Microsoft Certified Systems Developer and Access Trainer who teaches Windows Systems, Access and other software products to all levels of users. She has over 15 years of experience working with corporations and government agencies. Alison is also a regular speaker for Advisor Publication Conferences. She is the President of The Independent Computer Consultants Association of Los Angeles.Course Outline: Level 1 The Basics
- Launching Crystal Reports
- The Application Window
- Exploring Sample Reports
- Using the Create Report Expert
- Previewing the Report
- Designing a Report from Scratch
- Inserting Fields
- Browsing Field Data
- Moving & Sizing Report Objects
- Placing Text Objects on the Report
- Saving a Report
- Closing a Report
- Modifying a Report Description
- Opening an Existing Report
- Switching Between Open Reports
- On-line Help & Searching for a Help Topic
- Context-Sensitive Help
- Printing a Help Topic
- Seagate Software on the Web
- The Select Expert
- Using Saved versus Refreshed Data
- Expert Options
- Criteria Based on More than One Field
- Removing a Report Selection
- Sorting Records
- Grouping Records
- Working with Group Trees
- Deleting & Changing Groups
- Inserting Summary Calculation
- Defining Other Summary Calculations
- Using the Create Report Expert
- Modifying a Report Created with the Expert
- Building a Multi-table Report without the Expert
- Changing the Font of a Text or Field Object
- Adding Borders & Drop Shadows
- Formatting Numeric Data
- Changing Object Alignment
- Absolute Formatting
- Conditional Formatting
- The Highlighting Expert
- Modifying & Deleting a Conditional Format
- The Formula Editor & Inserting Formulas
- Changing Numbers to Words
- String Manipulation
- Date Calculations
- Creating Summary Calculations & Totaling By Group
- Working with Running Totals
- Running Sums
- If-Then-Else Formulas
- Creating Formulas & Entering Code
- Adding Comments
- Creating Parameters Fields
- Working with Multiple Parameter Fields
- Adding a Parameter Field to a Printed Report
- Deleting Parameters
- Changing the Size of a Section
- Sizing a Section Automatically
- Inserting & Deleting Lines
- Using the Selection Expert
- Grouping & Sort Direction & Custom Groups
- Sorting within a Group
- Grouping on Intervals
- Using the Style Expert
- Creating Special Fields
- Special Text Object Features
- Working with Lines & Boxes
- Adding Pictures to Your Report
- Creating a Cross-Tab Report Using the Cross-Tab Expert
- Creating a Cross-Tab Report without an Expert
- Modifying the Data included in a Cross-Tab Report
- Formatting a Cross-Tab Report
- Building a Summary Report
- Allowing or Disallowing Drill-downs
- Creating Running Totals Overall
- Creating Running Totals for a Group
- Creating Conditional Running Totals
- Creating Running Totals with a One-to-Many Relationship
- Creating a Report with the Top N Values
- Creating a Report with the Bottom N Values
- Creating an Unlinked Subreport
- Creating a Linked Subreport
- On-demand Subreports
- Setting up Group Selection
- Creating a Record or Group Selection Formula
- Creating Mailing Labels
- Modifying the Attributes of Mailing Labels
- Creating a Form Letter with the Expert
- Modifying Attributes of a Form Letter
- Creating a Form Letter without the Expert
- Customizing a Form Letter for Different Recipients
- Databases Overview
- Aliases
- Indexes
- Relationships
- SQL & SQL Databases
- Server-side Processing
- Mapping Database Fields
- Working with Different Types of Data
- Advanced Database Features
- Reporting on the NT Event Log
- Reporting on Exchange or Outlook Data
- What is SQL? & Creating a Report Based on an ODBC Datasource
- Building a SQL Query
- Modifying SQL Options
- Why Use a Query
- Creating a Query
- Modifying the Query
- Creating a Report from a Query
- Basing a Query on a Query
- Why Use a Data Dictionary?
- Creating a New Data Dictionary
- Basing a Report on a Dictionary
- Setting Dictionary Options
- Creating a Complex Formula
- Using a Variable
- Assigning a Value to a Variable
- Using Arrays in Formulas
- Using Ranges in Formulas
- Debugging Formulas
- Creating a Group Chart
- Creating a Detail Formula Chart
- Creating a Cross-tab Chart
- Modifying Chart Options
- Drilling Down on a Graph
- Re-entering the Chart Expert
- Using a Graph Template
- Mapping on Grouped Fields
- Modifying Map Attributes
- Mapping on Detail Fields
- Mapping on Cross-tab Summaries
- Using the Map Analyzer
- OLE Introduced
- Adding OLE Objects to a Report
- Working with Static OLE Objects
- Embedded vs. Linked Objects
- Dbase/FoxPro
- The File System
- NT Event Log
- Exchange
- Outlook
- Exporting a Report
- Mailing a Report
- Saving a Report as HTML
- Crystal Web Report Server
- Building Active Web Sites
- The Crystal Report Engine API
- Crystal ActiveX Controls
Contact Hours: 24
About The Training Provider: Online Training Directory
Online Training Directory - Workforce and Continuing Ed online courses are offered at basic, intermediate and advanced levels. Going beyond basic training provides a deeper and more educationally rewarding learning experience, especially for students who wish to advance careers or initiate new ones. For the general lifelong learner we continue to offer "fun to learn" single, stand-alone courses.
We look forward to...
