Where training face-to-face may still not be viable, we are also offering training by videoconferencing means, usually via Microsoft Teams or Zoom. Do get in contact if we can help you in this way. Click for further details of upcoming sessions. We are also happy to do customised online training to meet your requirements. Contact us for further details.

We have now also resumed face-to-face training at client site.

Advanced Crystal Reports 2013 training – Provisional Course Outline

Advanced Crystal Reports 2013 training

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

We start with generic exercises and then move on to using your database, thus making the training extremely relevant. 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.