Advanced Crystal Reports 2011 Training: Advanced Crystal Reports 2011

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

Looking for Advanced Crystal Reports 2008 training?

Advanced Crystal Reports 2011 Training Overview

Accelebrate's 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 taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered 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 private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=course&page=CRY2011.2.

Advanced 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.

Advanced 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 2GB RAM
Windows XP SP3, Windows Vista SP2, Windows 7, or later
Crystal Reports 2011, with any service packs applied
Microsoft Access 2003, 2007, 2010, or later

Advanced Crystal Reports 2011 Training Objectives

All attendees will learn how to:

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

Advanced 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

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
SharePoint Training

Adobe Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.