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

Prerequisites

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.

Outline

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

Duration

This is a QA approved partner course

Delivery Method

Delivery method

Classroom

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 0345 074 7998 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.