About this Course

Course Code TPBOCA
Duration 3 Days

This three day accelerated course is designed to give delegates the comprehensive skills and in-depth knowledge to plan and create Crystal 2016 reports that will help them analyse and interpret information.

Delegates will find that this course is an in-depth approach to the entire report creation cycle - from planning a report prototype to distributing a report.


The course style is 'hands-on' with practical exercises throughout.

To be successful, delegates who attend this course must have working knowledge of:

  • Windows conventions
  • Reporting tools
  • Basic database concepts

Who should attend?

This training course is designed for Report developers.


Creating a Report

  • Connecting to a data source
  • Adding tables
  • The design environment
  • Inserting Objects
  • Formatting reports
  • Saving documents
  • The Workbench
  • Inserting Special Fields
  • Selecting Records
  • Modifying record selection
  • Understanding saved and refreshed data

Sorting, Grouping & Summarising

  • Sorting records
  • Grouping records
  • Summarising data

Applying Section Formatting

  • Formatting Sections
  • Creating a summary report

Creating Formulas

  • Creating formulas
  • Applying Boolean formulas
  • Applying If-Then-Else formulas
  • Applying date calculations
  • Applying number calculations
  • Applying string manipulation

Creating Variables

  • Defining Variables
  • Creating Variables

Applying Conditional Reporting

  • Determining trends in data
  • Formatting data conditionally

Creating Parameters

  • Static parameters
  • Dynamic parameters

Representing Data Visually

  • Creating a chart

Working with Crosstabs

  • Creating a crosstab

Working with Sections

  • Conditionally formatting sections
  • Using group-related functions to format sections

Specialised Reporting

  • Running Total fields
  • Top N reporting

Report Processing

  • Use multi-pass reporting

Evaluation time functions
Working with subreports

  • Define subreports
  • Unlinked subreports
  • Linked subreports

3 Days


This is a QA approved partner course

Delivery Method

Delivery method


Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0113 220 7150 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.