- GS-35F-0556S
- Toll Free 877.932.8228
Advanced Crystal Reports 2008 Training
Delivery Options
- Live eLearning (2 days): $790.00 (Register)
- Customized Onsite Training (2 days): Request a Proposal
| Class Date and Time |
Price
|
Register |
|---|---|---|
| Apr 12 - 13, 2010 10:00 AM - 5:00 PM ET | $790.00 or 2 vouchers | Register |
| May 10 - 11, 2010 10:00 AM - 5:00 PM ET | $790.00 or 2 vouchers | Register |
| Jun 7 - 8, 2010 10:00 AM - 5:00 PM ET | $790.00 or 2 vouchers | Register |
Class Description
Class Overview
This advanced Crystal Reports training class is designed for people experienced with Crystal Reports who want to solidify their expertise by learning the most advanced features.
Students get practical experience through plenty of hands-on exercises.
Class Goals
- Learn advanced database concepts.
- Learn more advanced formula features.
- Learn to create custom functions.
- Learn to make your reports run more efficiently.
- Learn advanced cross-tab design.
Class Outline
- Refresher Exercise
- Review of Planning a Report
- Creating the Report
- Placing Fields on the Report
- Advanced Grouping
- Selecting Certain Records
- Group Sorting
- Group Charting
- Advanced Database Concepts
- What is SQL?
- Native Database Driver
- ODBC
- OLE DB
- ODBC, OLE DB or Native
- Using the Database Expert for Linking
- Adding a table Multiple Times
- Changing Join Types
- Database Changes
- Database Verification
- Set Data Source Location
- Re-mapping Database Fields
- Views
- Stored Procedures
- SQL Commands
- Creating an SQL Command
- Using the Advanced Formula Features
- Select Case Statement
- For Loop Control Structure
- While... Do Loops
- Do... While Loops
- Building Arrays
- The Split Function
- Array Sizing Limitations
- Custom Functions
- What is a Custom Function
- Function Arguments
- When to use a Custom Function
- Using the Custom Function Editor
- Using Crystal Syntax
- Using Basic Syntax
- Custom Function Properties
- Using the Formula Expert and Custom Functions
- Using the Formula Extractor
- Custom Function Limitations
- Running Reports Efficiently
- Understanding What Crystal Sends to the Database
- Strategies for Efficient Report Performance
- Using the SQL Statement
- Record Selection and Performance
- Performance Information
- Report Definition
- Saved Data
- Processing
- Latest Report Changes
- Performance Timing
- Server Based Grouping
- Select Distinct Command
- Advanced Cross-Tab Design
- Dissecting a Cross-Tab Grid
- Cross-Tab Parts Listing
- Row and Column Indexes
- Summary Indexes
- Grid Value Functions
- Embedded Summaries
- Conditionally Formatting Embedded Summaries
- Calculated Members
- Additional Tips and Tricks
- Manual Cross-Tabs
- Formatting Subreports
- Parameter Tricks
- Using Unique Fonts in the Report
Class Materials
All students receive a course manual or book and all the class examples.
Students in private onsite classes will also receive:
Class Prerequisites
Experience in the following areas is required:
- Solid Crystal Reports experience as taught in our introductory and intermediate courses.
Technical Requirements
Our computer technical requirements and setup process is easy, with support just a click away.
Like a class you would go to, but you don't have to go anywhere. More...
The trainer comes to you and delivers a class customized for your team. More...
Our least expensive option. You proceed through the course entirely at your own pace. More...
