Advanced Crystal Reports XI 2 Days £395

 
 
 
Target Audience:
Users who wish to fully investigate the more sophisticated functions of the package
Prerequisites:
A good understanding of Crystal Reports 11 gained either through practical experience or attendance on the Fundamentals & Intermediate course

Course Outline:

  • Revision
  • Advanced Formulas & Functions
  • Using Built in Functions
  • Understanding Formula Language & Syntax
  • Understanding Multi-Pass Reporting
  • Creating Custom Functions
  • Using Custom Functions
  • Crystal Repository
  • Using Variables
  • Understanding Arrays
  • Using Control Structures
  • ODBC Data Sources
  • Defining & Editing SQL Queries
  • Creating SQL Commands
  • Using SQL Expressions & Applying SQL Options
  • Using the Crystal SQL Designer
  • Creating a Query
  • Formatting the Query as a Report
  • Building & Analyzing a Cube
  • Creating OLAP Reports

By the end of the course delegates will be able to create reports which contain complex formula using variables and various functions. Delegates will also be able to query data sources using SQL Commands and expressions and create reports from the results.