Please contact us
for GSA pricing.

Contract #

Please see our complete list of Microsoft Official Courses

Crystal Reports 2011 Training: Advanced Crystal Reports 2011

4.8 out of 5 (12 reviews)

Course Number: CR-118
Duration: 2 days
view course outline

Crystal Reports 2011 Training Overview

Accelebrate's advanced Crystal Reports Training: Advanced Crystal Reports 2011 teaches attendees the skills they need for developing more powerful and insightful reports using Crystal Reports 2011.

Location and Pricing

Most Accelebrate courses are delivered as private, customized, on-site training at our clients' locations worldwide for groups of 3 or more attendees and are custom tailored to their specific needs. Please visit our client list to see organizations for whom we have delivered private in-house training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote for private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. See a schedule of online courses.

Crystal Reports 2011 Training Prerequisites

All attendees must be familiar with the basic Crystal Reports 2011 skills, as taught in Accelebrate's Introduction to Crystal Reports 2011 training.

Hands-on/Lecture Ratio

This course is more than 60% hands-on, with the longest lecture segments lasting for 20 minutes.

Crystal Reports 2011 Training Materials

All Crystal Reports 2011 training students receive comprehensive courseware covering all subjects in the course.

Software Needed on Each Student PC

  • Windows XP or later, with the latest service pack updates and at least 3 GB of RAM
  • Crystal Reports 2011, with the latest updates installed
  • Web browser
  • Adobe Reader for viewing PDF documents
  • Optional: Microsoft Excel and Access, version 2003 or later

Crystal Reports 2011 Training Objectives

  • Work with databases and SQL
  • Create custom functions
  • Use more advanced functions
  • Make reports more efficient and effective
  • Add charts to reports
  • Use report alerts

Crystal Reports 2011 Training Outline

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