eLearning Bundle - Crystal Reports Online Course

Crystal Reports TrainingeLearning Bundle - Crystal Reports

by Certstaffix® Training

Length: 3 Course(s)      Price: $450/person (US Dollars)      Bulk Pricing: 6+ Contact Us      Access Length: 6 Months      Category: Crystal Reports


This eLearning Bundle includes these 3 courses: Introduction to Crystal Reports Training, Intermediate Crystal Reports and Advanced Crystal Reports.
Purchase This Course ➥
Course Description: Print It | Download PDF | Email It

  Online Crystal Reports Classes: Learn at Your Own Pace

We will enroll you into a demo (Windows 10) eLearning session. Login information will be emailed to you.

Prefer a self-paced learning solution to fit your own schedule? Certstaffix® Training offers eLearning courses bundled together:

  • Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
  • Lecture utilizing video and recorded screen shots
  • 6 month subscription length
  • Any software needed for training is provided in an online lab environment.

  Detailed Training Topics

Course Description: Print It | Download PDF | Email It
Crystal Reports Training

Introduction to Crystal Reports Training - 22:37 hours

This Crystal Reports course is intended for students who have little to no experience with Crystal Reports. The course will provide students with a general overview of the basic functionality and a general understanding of report design, including the need to provide quality reports in various presentation formats. Students will gain practical experience through hands-on exercises.

Class Prerequisites
Experience in the following is required for this Crystal Reports class:

Basic computer skills
Experience in the following would be useful for this Crystal Reports class:

Familiarity with relational database concepts (tables, fields, and records)


Goals
Explore the Crystal Reports interface.
Learn to create a basic report and modify it.
Learn to format reports..
Learn to filter reports.
Learn to group report data.
Learn to create reports from data in multiple tables.
Learn to use formulas..
Learn to use conditional formatting.
Learn to create summary reports and charts.
Learn to export reports to Excel and PDF.
Learn to use Report Wizards.

Outline
Getting Acquainted with Crystal Reports
Report Writing Process
Opening Crystal Reports
The Database Expert
Review the Toolbars
The Standard Toolbar
The Formatting Toolbar
The Insert Toolbar
The Experts Toolbar
The Navigation Toolbar
The External Command Toolbar
The Report Sections in the Design Tab
Report Header
Page Header
Details
Page Footer
Report Footer
The Field Explorer
Preview the Report
Adding Multiple Tables to Reports
Formatting Reports
Formatting Fields
The AdventureWorks Database
The Format Painter
Working with Objects
Text Objects
Field Titles
Using Fields in Text Objects
Aligning and Sizing Objects
The Section Expert
Images
Filtering Reports
Create a Filter Based on a Single Criterion
Create a Filter for Multiple Selection Criteria
Sorting and Grouping Reports
Using the Sort Expert
Using the Group Expert
Summarizing Records within Groups
Using Basic Formulas
String Formulas
Numeric Formulas
Date/Time Formulas
Running Totals
Conditional Formulas
Advanced Formatting
Using Multiple Sections
Summary Reports
Lines and Boxes
The Highlighting Expert
Exporting and Distribution
Exporting to Excel
Exporting to PDF
Exporting to Word
Crystal Reports Viewer
crystalreports.com

Intermediate Crystal Reports - 21:52 hours

This intermediate Crystal Reports training class is designed to enhance your basic report writing skills and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of intermediate report writing along with a good amount of hands on practice. In addition, you will cover professional design, techniques, sub-reporting and advanced formulas.

Goals:
Review the basics.
Learn to use Sections to improve formatting.
Learn to keep running totals.
Learn to work with parameters.
Learn features of advanced formulas.
Learn to create Sub reports.
Learn to create and work with custom Groups.
Learn to work with Cross Tab Reports.
Learn to create Report Alerts.


Outline:
Crystal Reports Review
Creating a Report

Using Parameters
Creating Parameters
Adding a Parameter Field
Optional Parameters
Making a Parameter Optional
Using a List of Parameter Values
Creating a Parameter Value List
Dynamic List of Values
Creating a Dynamic Value List
Cascading List of Values
Creating a Cascading Value List
Multivalue Parameters
Creating a Dynamic Value List
Range Parameter
Creating a Dynamic Value List

Using Subreports
Unlinked Subreports
Creating an Unlinked Subreport
Linked Subreports
Adding a Linked Subreport

Charts
Adding a Chart to a Report
Adding a Chart

Cross-Tabulation Reports
Creating a Cross-Tab Report
Creating a Cross-Tab Subreport

Advanced Techniques
Special Fields
Adding Special Fields to a Report
Using the If Statement
Using the If Statement
Using the Select Case Statement
Using the Select Case Statement
Conditional Formatting
Using Conditional Formatting
Alternating Row Formatting
Formatting Rows by Alternating the Colors

Report Alerts
Using Report Alerts

Advanced Crystal Reports - 11:22 hours

This advanced Crystal Reports training class is designed to enhance your basic report writing skills and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice. In addition, you will cover professional design, techniques, sub-reporting and advanced formulas.

Class Prerequisites
Experience in the following is required for this Crystal Reports class:

Intermediate Crystal Reports experience.


Prerequisite Courses
Courses that can help you meet these prerequisites:

Introduction to Crystal Reports Training
Intermediate Crystal Reports


Outline
Crystal Reports Review
Review of Basic Report Building
Working with SQL
The SELECT Statement
Working with SELECT Statements
The WHERE Clause
Filtering with a WHERE Clause
The ORDER BY Clause
Using ORDER BY Clauses
Joins
Joining Tables Together
SQL Commands
Using a SQL Command
SQL Expressions
Using a SQL Expression
Advanced Functions
Evaluation Time Functions
Working with Variables
For Loops
While Do Loops
Working with Variables and Loops
Geographic Mapping
Geographic Maps
Map Basics
Adding a Geographic Chart
Course Description: Print It | Download PDF | Email It