We are now back to full face-to-face training at client site. We are also offering training by videoconferencing means, usually via Microsoft Teams or Zoom, if this is your preference. Click for more information about remote training.

Advanced Crystal Reports 2016 training – Provisional Course Outline

Advanced Crystal Reports 2016 training

Our Advanced Crystal Reports 2016 training course outlines can be adapted to the needs of the individual or organisation. We offer Crystal Reports training at your site in Dorset, Wiltshire and , including Bournemouth, Poole, Ringwood, Salisbury, Swindon, Winchester, Wimborne, Sherborne, Yeovil etc.

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

Number on coursePrice per day
1 - 1 training£375 + VAT
2 - 4 people£625 + VAT
5 - 8 people£845 + 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 info@archwayct.co.uk or filling in our contact form.