United States flagCanada flag1 877 849 1850 International flag +1 678 648 311
Please contact us
for GSA pricing.
GSA
Contract #
GS-35F-0307T

Crystal Reports 2011 Training: Advanced Crystal Reports 2011

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

  • At least 3GB RAM
  • Windows XP SP3, Windows Vista SP2, Windows 7 SP1, Windows 8, or later
  • Crystal Reports 2011, with any available updates applied applied
  • Microsoft Access 2007, 2010, 2013, 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