Home Courses Crystal Reports Advanced User 9-14


Crystal Reports Advanced User 9-14

Length: 2 Days    Cost: $1,245 + GST    Version: Crystal Reports

= Scheduled class    = Guaranteed to run    = Fully booked
Click on the dates to book online
Virtual Class -- -- -- --

Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.

About this Course

This two day hands-on advanced course develops the skills required to analyse data and produce complex reports from diverse data sources using the crystal report designer


Must have either attended the Crystal Reports Essential Skills course or be an experienced Crystal Reports user.

Course Outline


  • If…Then…Else operator
  • Suppress, Hide and Drill-Down Reports

Parameter Fields

  • Parameter for Selecting Records
  • Parameter for Sort Order
  • Parameter in a Formula Expression


  • Formatting a Cross Tab Report
  • Pivoting a Cross Tab Report
  • Summarising Multiple fields

Custom Functions and the Repository

  • Create Custom Functions
  • Store Objects in Repository

Running Totals

  • Multi-Pass Reporting
  • Creating a Running Total

Forms and Form letters

  • Design a Form
  • Conditional Form Letters

TopN Reports

  • Sort by Group Selection
  • TopN reports
  • BottomN Reports

Linking Tables

  • Linking Two Tables
  • Linking through Direct Access
  • Linking through ODBC
  • Verify Database
  • Set Location

Sub reports

  • Unlinked Sub reports
  • Linked Sub reports
  • On-Demand vs. In-Place Sub reports

Arrays and Variables

  • Variables and Arrays
  • Scope
  • Charts and Maps

 Print this page