Browse all IT training courses

Crystal Reports Introduction

Click here for a PDF version

Introduction

Crystal Reports is a powerful reporting tool for presenting information from data held in relational databases. Its functions enable you to produce professional quality reports beyond the capability of database programs such as Access. 

Objectives

A comprehensive introduction to Crystal Reports. The knowledge gained will enable students to produce presentation quality structured basic reports. 

Designed for

Users new to Crystal Reports who need to produce reports from external data sources i.e. Access, SQL, Oracle etc. No prior knowledge of the product is required, but a good understanding of a Relational Database is required. 

Duration

Two days 

Topics

  • Introduction
  • Crystal Overview
  • Simple Reports
  • Design View
  • Report Preview
  • Adding Fields
  • Adding Objects
  • Formatting
  • Fields & Objects
  • Sizing & Positioning
  • Record Selection
  • Select Expert
  • Record Options
  • Selecting Multiple Fields
  • Saving vs Refreshed Data
  • Sorting & Grouping
  • Sorting Records
  • Grouping Records
  • Changing Groups
  • Nested Groups
  • Totals & Summaries
  • Subtotals
  • Grand Totals
  • Totals in Groups
  • Summarising
  • Top N Expert
  • Using Help
  • On Line Help
  • Facts on Demand
  • Return Email/Fax Help
  • Report Experts
  • Experts Explained
  • Using and Expert
  • Benefits and Features
  • Tips and Tricks
  • Report Design
  • Setting margins, page size and orientation
  • Header & Footer Fields
  • Report Titles
  • Special Fields
  • Lines, Boxes and Graphics
  • Linking
  • Linking Overview
  • Adding/Removing Tables and Databases
  • Smart Linking
  • Working with Links
  • Formula Basics
  • Inserting Formulas
  • Basic Calculations
  • String Manipulation
  • Data Calculations
  • If then Else Formulas
  • Boolean Formulas
  • Conditional Formatting
  • Fields & Objects
  • Sections
  • Section Expert
  • Graphing
  • Creating & Editing
  • Using Drill Down
  • Positioning
  • Cross Tabs
  • Defining a Cross Tab
  • Creating and Formatting
  • Changing Field Widths
  • Pivoting a Cross Tab
  • File Options
  • Basic Settings
  • Field Formats
  • Defaults

Follow-up

Individual consultancy and tuition as required. 

Get in Touch

Pricing Guide:

  • 1

    £495 per head

  • 4

    £130 per head

  • 8

    £70 per head

Ask us about training for roll-outs and bespoke systems.

…and every course includes

  • Custom-building the course for you
  • Free post-course support helpline
  • All course materials
  • Trainer expenses