 |
Please contact us
for GSA pricing.
Contract #
GS-35F-0307T
Recent Training Venues Accelebrate has recently trained for clients in the following cities:
- Huntsville, Alabama
- Montgomery / Birmingham, Alabama
- Anchorage, Alaska
- Edmonton & Calgary, Alberta
- Phoenix, Arizona
- Tucson, Arizona
- Fayetteville / Little Rock, Arkansas
- Amsterdam, The Netherlands / Brussels, Belgium
- Vancouver, British Columbia
- Oakland / San Jose / San Francisco, California
- Sacramento, California
- San Diego, California
- Orange County / Los Angeles, California
- Boulder / Colorado Springs / Denver, Colorado
- Washington, DC
- Wilmington, Delaware
- Manchester / London, England
- Orlando, Florida
- Fort Lauderdale / Miami, Florida
- Jacksonville, Florida
- Saint Petersburg / Tampa, Florida
- Alpharetta & Atlanta, Georgia
- Augusta & Savannah, Georgia
- Boise, Idaho
- Chicago, Illinois
- Indianapolis, Indiana
- Cedar Rapids / Des Moines, Iowa
- Dublin, Ireland
- Wichita, Kansas
- Lexington / Louisville, Kentucky
- Baton Rouge/New Orleans, Louisiana
- Portland, Maine
- Hagerstown & Frederick, Maryland
- Annapolis / Baltimore, Maryland
- Boston / Cambridge, Massachusetts
- Hartford, Connecticut / Springfield, Massachusetts
- Ann Arbor / Detroit, Michigan
- Grand Rapids, Michigan
- Saint Paul / Minneapolis, Minnesota
- Jackson, Mississippi
- St. Louis, Missouri
- Kansas City, Missouri
- Lincoln / Omaha, Nebraska
- Reno and Las Vegas, Nevada
- Fredericton / Moncton / Saint John, New Brunswick
- Albuquerque, New Mexico
- Princeton, New Jersey & Philadelphia, Pennsylvania
- Albany, New York
- Buffalo, New York
- White Plains / New York City, New York
- Charlotte, North Carolina
- Durham / Raleigh, North Carolina
- Canton / Akron, Ohio
- Cincinnati, Ohio
- Cleveland & Columbus, Ohio
- Dayton, Ohio
- Tulsa / Oklahoma City, Oklahoma
- Toronto, Ontario
- Portland, Oregon
- Pittsburgh, Pennsylvania
- San Juan, Puerto Rico
- Providence, Rhode Island
- Saskatoon / Regina, Saskatchewan
- Edinburgh / Glasgow, Scotland
- Columbia & Charleston, South Carolina
- Spartanburg & Greenville, South Carolina
- Knoxville, Tennessee
- Memphis / Nashville, Tennessee
- Houston, Texas
- El Paso, Texas
- San Antonio / Austin, Texas
- Dallas, Texas
- Salt Lake City, Utah
- Fairfax / Dulles / McLean / Herndon / Reston, Virginia
- Richmond / Alexandria / Arlington, Virginia
- Virginia Beach / Norfolk, Virginia
- Tacoma / Seattle, Washington
- Charleston, West Virginia
- Madison / Milwaukee, Wisconsin
|
|
|
Crystal Reports Training: Advanced Crystal Reports 2008 |
Course Number: CR-102
Duration: 2 days
view class outline
Advanced Crystal Reports 2008 Training Overview
Accelebrate's advanced Crystal Reports Training: Advanced Crystal Reports 2008 teaches attendees the skills they need for developing more powerful and insightful reports using Crystal Reports 2008.
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=CRY301.
Advanced Crystal Reports 2008 Training Prerequisites
All attendees must have basic Crystal Reports 2008 familiarity, as taught in Accelebrate's Intermediate Crystal Reports 2008 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 2008 Training Materials
All Crystal Reports 2008 training students receive comprehensive courseware covering all topics taught and a copy of Crystal Reports 2008: The Complete Reference.
Software Needed on Each Student PC
- Windows XP or later with at least 2GB RAM
- Crystal Reports 2008
- Microsoft Office 2007 or later, including Access
- SQL Server 2005 or 2008 Express Edition with AdventureWorks installed (Accelebrate has detailed setup instructions for this)
- Related lab files
Advanced Crystal Reports 2008 Training Objectives
All attendees will learn to:
- Understand SQL and advanced database concepts
- Use SQL statements in report processing
- Create complex formulas and custom functions
- Use advanced formula features
- Run reports more efficiently
- Use advanced Cross-Tab design
- Enhance report design and functionality
|
Advanced Crystal Reports 2008 Training Outline
- Introduction
- Review
- Planning a Report
- Creating the Report
- Placing Fields on the Report
- Advanced Grouping
- Selecting Certain Records
- Group Sorting
- The Report Header
- The Group Chart
- Advanced Database Concepts
- What is SQL?
- Native Database Driver
- ODBC
- OLE DB
- ODBC, OLE DB or Native
- Using the Database Expert for Linking
- Order Links Dialog
- Index Legend Dialog
- Adding Tables to a Report Multiple Times
- Changing the Join Type for a Link
- Database Changes
- Database Verification
- Set Datasource Location
- Re-mapping Database Fields
- Views
- Stored Procedures
- SQL Commands
- Creating a SQL Command
- Adding a Parameter to the Command
- Using Advanced Formula Features
- Alternatives to the IF THEN ELSE Control Structure
- Select Case Statement
- Using the For Loop Control Structure
- The Different Types of While Loops
- While ... Do
- Do ... While
- Building Arrays
- The Split Function
- Crystal Formula Sizing Limitations
- Custom Functions
- Custom Function Arguments
- When to Use a Custom Function
- Creating Custom Functions
- Creating a Custom Function Using the Custom Function Editor
- Custom Function Properties
- Using the Formula Expert and Custom Functions
- Using the Formula Extractor
- Custom Function Limitations
- Running Reports Efficiently
- Understanding What Crystal Can Pass to the Database
- Strategies for Efficient Report Performance
- Interpreting the SQL Query
- Using a SQL Expression to Make a Report More Efficient
- Record Selection and Performance
- External Joins
- Performance Information
- Report Definitions
- Saved Data
- Processing
- Latest Report Changes
- Performance Timing
- Server Based Grouping
- Requirement s for Server Based Grouping
- Select Distinct Command
- Advanced Cross-Tab Design
- Introduction to 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
- Cross-Tab Calculated Members Expert
- Tips and Tricks
- Creating a Cross-Tab With the Expert
- Formatting Subreports
- Parameter Tips and Tricks
- Conditional Formatting
- Using Fonts to Enhance Readability of Your Report
- Windows Character Map
- Crystal Reports 2008 Application Installation Instructions
- Installing SQL Server 2005 Express Edition
- The AdventureWorks Database
- Conclusion
|
| |
Java® and all Java-based marks are registered trademarks of the Oracle Corporation in the U.S. and other countries.
MySQL™ and all MySQL-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the U.S. and other countries.
|
|
Accelebrate®
Focuses on You! |
|
Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.
Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.
For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.
|
|
|
|
