Skip to Content

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

expand or collapse the menu Accessibility

expand or collapse the menu Web Development

expand or collapse the menu Adobe / Macromedia Web

expand or collapse the menu Programming

expand or collapse the menu Databases

expand or collapse the menu Professional Courses

expand or collapse the menu Adobe

expand or collapse the menu Microsoft SharePoint

expand or collapse the menu Technical

expand or collapse the menu Geographic (GIS)

expand or collapse the menu Microsoft Office

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

Crystal Reports XI - Level 3

2 day course

View Detailed Outline in PDF format

Get Adobe Reader

This two-day course is designed to expand your working knowledge of Crystal Reports and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice. In addition, you will cover custom function, advanced formulas and report efficiencies techniques. This course incorporates a number of hands on exercises that reinforce the learning process.

Course Topics:

(for a full detailed outline, visit our PDF link above)

Reviewing the Basics

  • Planning and Creating and Advanced Report
  • Placing Fields and Creating Complex Formulas
  • Advanced Grouping and Record Selection
  • Group Sorting
  • Charting Groups

Custom Functions

  • What is a Custom Function?
  • Function Arguments
  • Using the Custom Function Editor
  • Using Crystal vs. Visual Basic Syntax
  • Custom Function Properties
  • Using the Formula Expert for Custom Functions
  • Using the Formula Extractor
  • Custom Function Limitations

Using Running Totals

  • Understanding Running Totals
  • Creating Running Totals
  • Conditional Running Totals

Using Advanced Formula Features

  • Advanced Formula Syntax
  • Review of If…Else…Then Expressions
  • Select Case
  • Immediate IF (IIF)
  • For Loops
  • Exit For
  • The Join Function
  • The Split Function
  • Array Sizing Limitations

Crystal Reports, Data Access, and SQL

  • What is SQL?  (How do you spell SQL?)
  • Direct Database Drivers
  • ODBC and OLE DB
  • Viewing the SQL Commands
  • Creating your own SQL Command
  • Adding Parameters to the SQL Command
  • SQL Expressions

Advanced Database Concepts

  • Using the Database Expert for Linking
  • Links Indexes and Options Dialogs
  • Adding and Removing Databases / Tables
  • Adding a Table Multiple Times
  • Changing Join Types
  • Database Changes and Verification
  • Set Data Source Location
  • Re-mapping Database Fields
  • Using Database Views and Stored Procedures
  • Non-ODBC Connection Types

Report Tuning

  • What Crystal Sends to the Database
  • Strategies for Efficient Report Performance
  • Using the SQL Statement
  • Record Selection and Performance
  • Performance Information
  • Report Definition and Saved Data
  • Controlling Processing
  • Performance Timing
  • Server Based Grouping

Manual Cross Tab Reports

  • What is a Manual Cross-Tab
  • Creating a Cross-Tab Object
  • Creating a Cross-Tab without the Expert

Tips and Tricks

  • Formatting Subreports
  • Parameter Tricks
  • Conditional Formatting
  • Formatting Page Headers
  • String Fields and Dates
  • Dates Activity

OLAP Reporting

  • OLAP Explanation and OLAP Servers
  • Creating an OLAP Report
  • Formatting an OLAP Report