Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


In this course, students will build basic list and group reports that work with almost any database. This course requires a basic understanding of databases and their underlying purpose

  • Course Start Date: Oct. 17
  • Location: Ottawa (Map)
  • Time: 9:00 am - 4:00 pm (Note on end times)
  • Please Note: End Times are approximate and depend
    on the number or students and pace of the class.
    It is important to allow for the class to run a little bit longer,
    or finish a little sooner, than expected.
  • Duration: 2 Days
  • Delivery Method(s):Instructor Led
  • Mentored training is a revolutionary training method
    that provides you with the quality training that
    you have come to expect, and combines it with
    flexible learning and a self paced environment.
    For more information click here.
  • Seats Available: YES
  • Category:Crystal Reports Training Courses

 
Course Outline
This course requires a basic understanding of databases and their underlying purpose

Learning objectives:
In this course, students will build basic list and group reports that work with almost any database.

Course Outline

Lesson 1:  Overview

Crystal Reports Capabilities
ODBC and OLE Data Sources
The Start Page
Crystal Reports Toolbars
Changing Program Options

Lesson 2:  Creating a Basic Report

Creating a Blank Report
Using the Database Expert
Linking Tables and Join Type
Previewing a Report
Saving Data With Report
Moving, Sizing and Aligning Fields
Inserting Text Objects and Special Fields

Lesson 3:  Formatting

Formatting Fields
Adding Lines, Boxes and Pictures
Using the Report Explorer
Using Templates

Lesson 4:  Sorting and Selecting

Sort Expert and Select Expert
Using an OR condition
Showing the SQL Query
Filtering for Null Values

Lesson 5:  Grouping and Summarizing

Insert a group
Change and delete a group
Applying an additional group
Specified Grouping Order
Insert a Summary Field
Filtering on a Summary
Grand Totals vs. Running Total
Standard Report Wizard

Lesson 6:  Basic Formulas

Create a formula
Basic Syntax
String and Date Functions
Conditional Formulas
Working With Nulls
Converting Data Types
Conditional Formatting Formulas

Lesson 7:  Section Formatting

Section Expert
Inserting and Deleting Sections
Creating Drill-Down Reports

Lesson 8:  Cross-Tabs

Create a Cross-Tab
Using the Cross-Tab Expert
Cross-Tab Formulas

Lesson 9:  Charts

Creating a Chart
Basing a Chart on a Group
Creating an Advanced Chart
Basing a Chart on a Cross-Tab
Changing the Chart Type

Lesson 10:  Distributing Reports

Overview of Distributing Reports
Exporting Reports
Publishing to Business Objects Enterprise
Crystal Reports Dot Com
Crystal Reports Viewers
Export a report definition
Scheduling and Bursting Reports

Lesson 11:  Getting Help

Internet Forums
Accessing Built in Help 


Prerequisites & Certificates
Pre-Requisites

This course requires a basic understanding of databases and their underlying purpose

Certificates offered

Certificate of completion


Cancellation Policy

Compuease Cancellation Policy
We at Compuease work hard to arrange our schedules around your needs. Last minute cancellations put additional strain on our schedules and therefore we have the following Cancellation Policy for our Public Classes. You may cancel or reschedule a registration at any time up to 10 business days before the class without penalty. Canceling or rescheduling a registration within 10 business days requires full payment of the course fee. You are welcome to transfer your seat in a class to another individual at any time before the class.


Map & Reviews
CompuEase
[ View Provider's Profile ]

CompuEase Training Classroom
130 Albert Street
Suite 801

Ottawa, ON
Canada   K1P 5G4


Reviews
 
The building itself is pretty dingy, but the instructor made up for it!!
Reviewed by 2015
17-October-2016 $999 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer Make An Offer Help

Not enough budget for this course? Maybe you just love to make deals!
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!
need-to-train-a-group-banner

This course is also scheduled on the following dates:

Not interested in this Course?

Tell us why:

This page has been viewed 79 times.