I came in with questions and the instructor took the time to go over those areas with extra care when they were...
More Testimonials »
Advanced Crystal Reports 2008 Training
Delivery Options
- Live Online Training - Public Class (): $790.00 (Register)
- Customized Onsite Training (2 days): Request a Proposal
| Class Date and Time |
Price
|
|
|---|---|---|
|
$790.00
or 2 vouchers
vouchers
|
||
| $790.00 or 2 vouchers vouchers | ||
| $790.00 or 2 vouchers vouchers | ||
| $790.00 or 2 vouchers vouchers | ||
| $790.00 or 2 vouchers vouchers | ||
| $790.00 or 2 vouchers vouchers | ||
| $790.00 or 2 vouchers vouchers | ||
| $790.00 or 2 vouchers vouchers | ||
| $790.00 or 2 vouchers vouchers | ||
| $790.00 or 2 vouchers vouchers |
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
Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.
Class Prerequisites
Experience in the following areas is required:
- Solid Crystal Reports experience as taught in our introductory and intermediate courses.
Courses that can help you meet these prerequisites:
Technical Requirements
Our computer technical requirements and setup process is easy, with support just a click away.
- Onsite and Instructor-led Online course technical requirements and setup instructions.
- WebEx system requirements for Instructor-led Online delivery option.
Watch 3-minute Demo Video
of Live Online Training:
of Live Online Training:
Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.