The class provided much hands on practice and explained the high level concepts necessary to produce valid structured... More Testimonials »

Advanced Crystal Reports 2011

Delivery Options

Class Date and Time Price Pricing Information
$790.00
or 2 vouchers vouchers
$790.00 or 2 vouchers vouchers
$790.00 or 2 vouchers vouchers

Class Description

Class Overview

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.

Please note that XI is the older version of Crystal Reports and should not be confused with 2011.

Class Goals

  • Learn about databases and SQL.
  • Learn about custom functions.
  • Learn about more advanced functions.
  • Learn how to make reports more efficient and effective.
  • Learn about charts.
  • Learn about report alerts.

Class Outline

  1. Crystal Reports Refresher
    1. Creating a Crystal Report
  2. Using Parameters
    1. Creating Parameters
    2. Optional Parameters
    3. Using a List of Values
    4. Using Parameters
  3. Subreports
    1. Unlinked Subreports
    2. Linked Subreports
  4. Charts
    1. Adding Charts to Reports
  5. Cross-tabulation Reports
    1. Using Cross-tabulation Reports
  6. Working with SQL
    1. The SELECT Statement
    2. The WHERE Clause
    3. The ORDER BY Clause
    4. Joins
    5. SQL Commands
    6. SQL Expressions
  7. Advanced Techniques
    1. Special Fields
    2. Using the Select Case Statement
    3. Evaluation Time Functions
    4. Conditional Formatting
    5. Alternating Row Formatting
  8. Report Alerts
    1. Using Report Alerts

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 areas is required:

    Solid Crystal Reports experience as taught in our introductory course.

Courses that can help you meet these prerequisites:

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
Compare Us
Watch 3-minute Demo Video
of Live Online Training:
Learn the benefits of online training with Webucator
Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.
© Webucator, Inc. All rights reserved. | Toll Free: 1-877-932-8228 | From outside the USA: 315-849-2724| Fax: 315-849-2723