How To Take This Class

Course Overview

In this Crystal Reports 2013 Advanced Training course, students will create complex reports from data sources using SQL statements, they will also see how to create complex formulas and perform loops and conditional logic within a formula. Students will also learn how to create more sophisticated cross-tabs reports and tips and tricks for using parameters effectively.

Course Prerequisites

Students should have completed, or have experience with, topics covered in the Crystal Reports 2013 Introduction and Intermediate Training courses.

Course Audience

This course is designed for people who know how to create basic list and group reports and need to create reports that include advanced formulas, and reports that may be based on more complex SQL statements. Students attending this course may or may not have programming and/or SQL experience.

What You'll Learn

Upon successful completion of this course, students will be able to:
  • Work with native data drivers to connect to data.
  • Work with ODBC, OLE DB and other drivers to connect to data.
  • Work with simple to complex SQL statements.
  • Create conditional logic within a formula.
  • Create complex cross tab reports.
  • Use parameters in reports more effectively.

Course Duration

2 Days

Course Outline

  1. Refresher Exercise
    • Review of Planning a Report
    • Creating the Report
    • Placing Fields on the Report
    • Advanced Grouping
    • Selecting Certain Records
    • Group Sorting
    • Group Charting
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. Tips and Tricks
    • Manual Cross-Tabs
    • Formatting Subreports
    • Parameter Tricks
    • Using Unique Fonts in the Report

What Students Receive

Each student will receive:
  • A printed courseware manual with hands-on exercises and samples for use during and after class.
  • A PC headset for communicating with your instructor and fellow students during your Crystal Reports 2013 Training Class
  • A course completion certificate upon successful completion of your Crystal Reports 2013 Training course
  • Six months of post-class email support from a Crystal Reports 2013 Instructor