Advanced Crystal Reports 2016

This Crystal Reports class is intended for those experienced in Crystal Reports and who want to learn more about database functionality and the more advanced features of Crystal Reports. This will be enhanced through the use of hands-on exercises throughout the course.

Goals
  1. Review basic report building.
  2. Learn about working with SQL.
  3. Learn about more advance functions.
  4. Learn about geographic mapping.
Outline
  1. Crystal Reports Review
    1. Review of Basic Report Building
  2. Working with SQL
    1. The SELECT Statement
      1. Working with SELECT Statements
    2. The WHERE Clause
      1. Filtering with a WHERE Clause
    3. The ORDER BY Clause
      1. Using ORDER BY Clauses
    4. Joins
      1. Joining Tables Together
    5. SQL Commands
      1. Using a SQL Command
    6. SQL Expressions
      1. Using a SQL Expression
  3. Advanced Functions
    1. Evaluation Time Functions
    2. Working with Variables
    3. For Loops
    4. While Do Loops
      1. Working with Variables and Loops
  4. Geographic Mapping
    1. Geographic Maps
      1. Map Basics
      2. Adding a Geographic Chart
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

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:

Preparing for Class

Training for your Team

Length: 1 Day
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

Training for Yourself

$395.00 or 1 vouchers

Upcoming Live Online Classes

  • See More Classes

Please select a class.
  • Live Online Training
  • For Individuals
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video

What people say about our training

Thank you for providing this online training class. I learned a great deal and it was just like being in a live class. Excellent!!
Danielle DuBose
n/a
Great. Better than previous training I have had!
Carrie Goertz (Deal)
MIPT
I was looking for a JAVA crash course and not only did this class meet those expectations, but exceeded them. I gained a richer understanding of the JAVA language which better equips me for my job.
June Ellern
IGT
As a company, Webucator exceeded my expectations for online training. I have been in in-person classroom settings and didn't receive anywhere near the service that I received from Webucator.
Marlys Battema
Self-Employed

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

61,490

Students who have taken Instructor-led Training

11,769

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

10.00

Students rated our Advanced Crystal Reports 2016 trainers 10.00 out of 10 based on 2 reviews

Contact Us or call 1-877-932-8228