Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4

This course will start with the basics of learning what you can do in Crystal Reports, creating basic reports and formatting, taking you all the way through to creating formulas and charts while making sure you know how to use Help.

Course Outline
 Thiscourse costs a few dollars more than most ... for good reasons:

1.      This is a hands-on course 
- no sitting in a hotel room listening to a trainer and following along 
with some handouts.  You get to learn and practice the skills.

2.      Each student gets their own computer - nosharing of computers;  you will work 100% of the time on your owncomputer.

3.      Each student gets a printed manual -a fully bound, comprehensive document that you will be able to refer to longafter the session - and 30 days ofafter-training support.

4.      Maximum of 6 students -so there is a lot of time to ask questions and get personalized attention fromthe teacher.

5.      Guaranteed to run!   - Even with onestudent we guarantee the class will run.


Crystal Reports Capabilities

ODBC and OLE Data Sources

The Start Page

Crystal Reports Toolbars

Changing Program Options


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 SpecialFields


Formatting Fields

Adding Lines, Boxes and Pictures

Using the Report Explorer

Using Templates


Sort Expert and Select Expert

Using an OR condition

Showing the SQL Query

Filtering for Null Values


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


Create a Formula

Basic Syntax

String and Date Functions

Conditional Formulas

Working with Nulls

Converting Data Types

Conditional Formatting Formulas


Section Expert

Inserting and Deleting Sections

Creating Drill-Down Reports


Create a Cross-Tab

Using the Cross-Tab Expert

Cross-Tab Formulas


Creating a Chart

Basing a Chart on a Group

Creating an Advanced Chart

Basing a Chart on a Cross-Tab

Changing the Chart Type


Overview of Distributing Reports

Exporting Reports

Publishing to Business ObjectsEnterprise

Crystal Reports Dot Com

Crystal Reports Viewers

Export a Report Definition

Scheduling and Bursting Reports


Internet Forums

Accessing Built-in Help

Prerequisites & Certificates

Certificates offered

Certificate of completion

Cancellation Policy
JN Software Consulting works hard to schedule our training and other services around your life, for your
convenience. With that in mind we have the following cancellation policy for all booked training. 
  •  Less than 48 hours: Full quoted fee 
  •  Less than 5 business days: 20% of quoted fee 
  • NSF Charge Policy
    Clients will incur a $40 charge for any NSF cheques
 PLEASE NOTE: Onsite sessions are subject to a 3 hour minimum charge regardless of the duration of the actual training. For sessions expected to last less than 3 hours we suggest booking a live online training session.

Map & Reviews
JN Software Consulting
[ View Provider's Profile ]


This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.
one on one training at my office.
Reviewed by 2017
Excellent course. Even my most advanced excel users came away with valuable new ways to use excel. I highly recommend this course.
Reviewed by 2012
The course was well organized and I recieved lots of attention during the planning phase to make sure we designed the course appropriately for our team I would definately recommend JN Software.
Reviewed by 2012
Philippe was really good at catering the training to our needs. He figured out what our prior knowledge was on the topic and went from there istead of having us go over things we already knew. If we had been in a group setting this would not have been possible. He also was helpful in letting us know how the 2003 version was different from the 2010. We therefore purchased an additional training manual for the 2010 version as we recently had it installed on our workstations.
Reviewed by 2012
There was a little mix up with the time the course was to be held. The website said 9-4 but it should have been 10-5, so when I arrived no one was there. However, it was dealt with quickly after a call and the trainer arrived quickly. I was the only person attending the course, it was very informative and it allowed us to touch on all of the questions I had specifically.
Reviewed by 2012
The instructor was excellent - she was very knowledgeable, patient, and really tried to tailor the course and specific examples to each student. The room was bit too cold in the morning and quite warm in the afternoon, so I would recommend wearing layers for comfort! I would highly recommend this course.
Reviewed by 2012
The instructor used real situations from the participants, so it was extremely relevant to what we were doing. She was very knowledgable and answered all questions.
Reviewed by 2011
Very informative session focused on all my concerns regarding advanced QuickBooks. Carolyn was helpful and very pleasant to learn from. I would reccomend her highly and might want to work with her again in the future.
Reviewed by 2011
The instructor was very knowlegeable but the seminar wasn't very well structured. No handouts, ran out of time before al topics were covered. Certain points were belabored at the expense of covering all desired topics.
Reviewed by 2011
I think this training need more time, it was a bit short in duration
Reviewed by 2011
Course was given on site at my work place - very convenient. Outline changed during course to fit more with our goups needs. Time frame changed also and this caused some disorganization.
Reviewed by 2011
Gordon was a great presenter and traininer, I learned a lot and he has inspired me to further my knowledge in this subject.
Reviewed by 2011
We all enjoyed Shauna's presentation of Adobe. She's a knowledgeable trainer.
Reviewed by 2011
Good course, great instructor.
Reviewed by 2011
The instructor was amazing.
Reviewed by 2011
Excellent training - instructor, facility, course content. Thank you.
Reviewed by 2011
I took a private class with Jon and it was terrific. He was very knowledgeable and patient in explaining to me the mechanics of what I needed to know. I have worked with excel as long as I can remember, however I started a new job that required me to us
Reviewed by 2008

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 512 times.