Crystal Reports Training: Advanced Crystal Reports XI

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

Advanced Crystal Reports XI Training Overview

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

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=CRY021.

Advanced Crystal Reports XI Training Prerequisites

All attendees must be familiar with the basic and intermediate Crystal Reports XI skills, as taught in Accelebrate's Introduction to Crystal Reports XI training and Intermediate Crystal Reports XI 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 XI Training Materials

All Crystal Reports XI training students receive comprehensive courseware covering all topics taught and a copy of Crystal Reports XI: The Complete Reference.

Software Needed on Each Student PC

Windows 2000 or later with at least 1GB RAM (2GB RAM or more strongly recommended)
Crystal Reports XI
Microsoft Office XP, 2003, or 2007

Advanced Crystal Reports XI Training Objectives

All attendees will learn how to:

Create custom functions
Use advanced formula features
Embed SQL commands within reports
Make the most of advanced database features such as indexes, table relationships, and stored procedures
Build OLAP reports
Use tips and tricks to save time and produce more attractive reports

Advanced Crystal Reports XI Training Outline

Custom Functions

What is a Custom Function
Custom Function Arguments
When to use a Custom Function
Creating Custom Functions
Creating a Custom Function using the Custom Function Editor
Using Crystal Syntax
Using Basic Syntax
Custom Functions Properties
Using the Formula Expert and Custom Functions
Using the Formula Extractor
Custom Function Limitations

Using Advanced Formula Features

Advanced Formula Syntax
Review of If...then...else...Expressions
Alternatives to the IF THEN ELSE Function
Select Case Statement
Immediate If Function
IIF (expression, truePart, falsePart)
For Loops
Exit For
While Do Loops
Join Function
The Split Function
Crystal Formula Sizing Limitations

Crystal Reports, Data Access and SQL

What is SQL?
Direct Database Driver
ODBC
OLE DB
Viewing the SQL
SQL Commands
Creating a SQL Command
Adding a Parameter to the Command
SQL Expressions
Creating a SQL Expression

Advanced Database Concepts

Using the Database Expert for Linking
Order Links Dialog
Index Legend Dialog
Link Options Dialog
Adding and Removing Databases/Tables from the Report
Adding Tables to a Report Multiple Times
Changing the Join Type for a Link
Database Changes
Database Verification
Set Data Source Location
Re-mapping Database Fields
Views
Stored Procedures
Non ODBC Connection Types

Running Reports Efficiently

Understanding What Crystal Can Pass to the Database and How That Affects Report Performance
Strategies for Efficient Report Performance
Interpreting the SQL Query
Using an SQL Statement to Make a Report More Efficient
Record Selection and Performance
Performance Information
Report Definition
Saved Data
Processing
Latest Report Changes
Performance Timing
Server Based Grouping
Requirements for Server Based Grouping
Select Distinct Command

Manual Cross-Tab Reports

Creating a Cross-Tab Object
Creating a Cross-Tab without the Expert

Tips and Tricks

Formatting Subreports
Parameter Tips and Tricks
Conditional Formatting
Formatting Page Headers
Using Fonts to Enhance Readability of your Report
Windows Character Map
String Fields and Dates
Dates Activity

OLAP Reporting

OLAP Explanation
OLAP Servers
Creating an OLAP Report
OLAP Report Formatting

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.