Database and Reporting Training     
USACanada UK Ireland International
1 877 849 1850   0808 234 2132   1 800 550 311   +1 678 648 3113
  Home   Contact Us
Crystal Reports Training * MySQL Training * Oracle Training * SQL Server Training * Live Online Training


 * Introduction to Crystal Reports 2008 Training
 * Advanced Crystal Reports 2008 Training
 * Introduction to Crystal Reports XI Training
 * Intermediate Crystal Reports XI Training
 * Advanced Crystal Reports XI Training



Please contact us
for GSA pricing.

GSA

Contract #
GS-35F-0307T



Complimentary Database & Reporting Training Seminar

Organizations in the Atlanta, Georgia area are encouraged to contact Accelebrate® about having a complimentary, one-hour database or reporting training seminar. For more details, please contact us today.



Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Calgary, Alberta
  • Phoenix, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Oakland / San Jose / San Francisco, California
  • Sacramento, California
  • Oceanside / San Diego, California
  • Pasadena / Orange County / Los Angeles, California
  • San Bernardino / Riverside, California
  • Boulder / Colorado Springs / Denver, Colorado
  • Washington, DC
  • Wilmington, Delaware
  • Manchester / London, England
  • DeLand / Orlando, Florida
  • Fort Lauderdale / Miami, Florida
  • Gainesville / Jacksonville, Florida
  • Saint Petersburg / Tampa, Florida
  • Titusville & Melbourne, Florida
  • Alpharetta & Atlanta, Georgia
  • Augusta & Savannah, Georgia
  • Macon & Columbus, Georgia
  • Boise, Idaho
  • Bloomington, Illinois
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Kingston, Jamaica
  • Wichita, Kansas
  • Paducah / Lexington / Louisville, Kentucky
  • Baton Rouge, Louisiana
  • Valletta, Malta
  • Hagerstown & Frederick, Maryland
  • Greenbelt / Silver Spring / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Taunton, Massachusetts / Providence, Rhode Island
  • Ann Arbor / Farmington Hills / Detroit, Michigan
  • Grand Rapids, Michigan
  • Lansing, Michigan
  • Saginaw / Flint / Bay City / Midland, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • Gulfport / Biloxi, Mississippi
  • St. Louis, Missouri
  • Whiteman Air Force Base / Kansas City, Missouri
  • Lincoln / Omaha, Nebraska
  • Reno and Las Vegas, Nevada
  • Santa Fe / Albuquerque, New Mexico
  • Newark, New Jersey
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Bowling Green / Toledo, Ohio
  • Canton / Akron, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Dayton, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • Providence, Rhode Island
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Chattanooga / Knoxville, Tennessee
  • Memphis / Jackson / Nashville, Tennessee
  • College Station and Houston, Texas
  • El Paso, Texas / Ciudad Juarez, Mexico
  • San Antonio / Austin, Texas
  • Wichita Falls & Dallas, Texas
  • Ogden / Salt Lake City, Utah
  • Burlington, Vermont
  • Fairfax / Dulles / McLean / Herndon / Reston, Virginia
  • Richmond / Alexandria / Arlington, Virginia
  • Virginia Beach / Norfolk, Virginia
  • Tacoma / Seattle, Washington
  • Madison / Milwaukee, Wisconsin

 

 

Crystal Reports Training: Advanced Crystal Reports XI

Print This Outline
E-mail This Outline
Get A Quote
Course Number: 682
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. To receive a customized proposal and price quote, 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/database.htm.

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 512MB RAM (1GB 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
 

Print This OutlineE-mail This OutlineGet A Quote


Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. 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®
Comes to You!


Accelebrate's courses are taught exclusively on-site at your location for groups of 3 or more attendees, anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate come to your site and deliver exactly the training you want, for less than the cost of a public class.

For pricing and to learn more, please call us at +1 877 849 1850, fill out our information request form, or email us at info@accelebrate.com today.

 
Accelebrate E-Newsletter


Get the latest Web development news delivered to your email box once a month!



VB.NET, C#, ASP, & ASP.NET Training * Java Training * SQL Server Training
Adobe Training * PHP Training * XML Training * Perl 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.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | Sacramento, CA | San Diego, CA | San Francisco, CA | San Jose, CA | Denver, CO | Washington, DC | Jacksonville, FL | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | Las Vegas, NV | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Dayton, OH | Oklahoma City, OK | Toronto, ON | Portland, OR | Philadelphia, PA | Pittsburgh, PA | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | San Antonio, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK

About Accelebrate IT Training VB.NET, C#, and ASP.NET Training Java, Struts, and JSP Training Adobe Training Microsoft SQL Server Training XML Training, PHP Training, Perl Training, and Other Courses Database and Reporting Training