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 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£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

  • Using formula fields in 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.