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 8.5 training – Provisional Course Outline

Advanced Crystal Reports 8.5 training

Our Advanced Crystal Reports 8.5 training course outline can be adapted to the needs of the individual or organisation. We train Crystal Reports at your site in Dorset, Wiltshire and Hampshire, including towns such as Bournemouth, Poole, Salisbury, Southampton, Sherborne, Ringwood, Gillingham, Yeovil, Swindon. We start with generic training exercises then work with your database to create and edit reports, thus making the training very 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

Cross-Tabs

  • Creating more complex cross-tab reports

Charts

  • Creating a chart
  • Modifying a chart

Maps

  • 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

Alerts

  • Creating alerts
  • Modifying alerts
  • Deleting alerts

Subreports

  • 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.