Crystal Reports XI Designer 3 Workshop Training in Gilbert

Enroll in or hire us to teach our Crystal Reports XI Designer 3 Workshop class in Gilbert, Arizona by calling us @303.377.6176. Like all HSG classes, Crystal Reports XI Designer 3 Workshop may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Crystal Reports XI Designer 3 Workshop may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.

Course Description

 
This two-day workshop is designed to expand your working knowledge of Crystal Reports and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing, along with a lot of hands-on practice. In addition, you will cover custom function, advanced formulas, and report efficiencies techniques. This course incorporates a number of hands-on exercises that reinforce the learning process.
Course Length: 2 Days
Course Tuition: $790 (US)

Prerequisites

Successful completion of the Designer 1 and 2 Workshops is strongly recommended.

Course Outline

 

Refresher Exercise
Review of Planning a Report
Creating the Report
Placing Fields on the Report
Advanced Grouping
Selecting Certain Records
Group Sorting
The Report Header
The Group Chart

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
 

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.