Advanced Crystal Reports 2011 training – Provisional Course Outline

Advanced Crystal Reports 2011 training

Advanced Crystal Reports 2011 training course outlines can be adapted to the needs of the individual or organisation. We provide Crystal Reports 2011 training at your site in Dorset, Hampshire and Wiltshire, including Southampton, Swindon, Salisbury, Sherborne, Winchester, Wimborne, Weymouth, Bournemouth, Poole and Ringwood.

We start with generic exercises, then move on to using your database, thus making the training very relevant. This is a two-day course.

Number on coursePrice per day
1 - 1 training£345 + VAT
2 - 4 people£595 + VAT
5 - 8 people£795 + VAT

Objectives of the course

On completion of the course, learners will be able to:

  • Create and use parameter fields
  • Create and modify running totals
  • Use variables, arrays and ranges in formulae
  • Create a formula using multiple functions
  • Use the Evaluation Time functions in a formula
  • Use For and While constructs
  • Create and format charts
  • Create maps
  • Create alerts
  • Create subreports
  • Access data from various data sources
  • Create basic SQL queries

Course Outline

Selecting data

  • Using parameter fields to filter data
  • Using a pick list to select data
  • Selecting data within a date range

Complex formulae and functions

  • Running totals
  • IF – THEN – ELSE functions
  • Creating formulae using variables
  • Creating formulae using arrays
  • Creating formulae using ranges
  • Creating formulae using multiple functions
  • Evaluation Time functions
  • For and While loops


  • Using formula fields in cross-tab reports


  • Creating a chart
  • Modifying a chart


  • Creating a map
  • Customising a map

Formatting complex reports

  • Using the Section Expert
  • If-then-else conditional formatting
  • Using parameter fields in conditional formatting
  • Hyperlinks
  • OLE objects


  • Creating alerts
  • Modifying alerts
  • Deleting alerts


  • Creating unlinked subreports
  • Creating linked subreports
  • Creating on-demand subreports

Advanced Data Access

  • ODBC data sources
  • Basics of SQL

To request further details of any of our courses, or to make a booking, please contact us by ringing 07477 578417 or by sending an email to [email protected] or filling in our contact form.