Crystal Reports Training

Award-winning, small, friendly Crystal Reports courses in London, online & across the UK.

Hands-on training using real-world example for all levels from beginner to advanced.

All courses CPD certified and include 6 months post-course support.

Crystal Reports is a powerful Business Information package, allowing you to create engaging and dynamic reports.

Rated: Exceptional since 2013
Over 1,500 external reviews

Feefo Logo
  • Moneyback Guarantee
    -
    100% Peace of mind
  • Expert Trainers
    -
    >12 years experience
  • Happy Customers
    -
    92% book again
  • Rated Outstanding
    -
    14 years in a row

Our Crystal Reports Courses

Crystal Reports Training – Introduction / Intermediate

Crystal Reports Introduction & Intermediate

CPD Certified
4.93 / 5
2 days.
Client Site Courses Available.
Live Online & Client Site.

This beginners course will give you a thorough grounding in the basics.

  • Introduction to Crystal Reports
  • Creating basic Reports
  • Sorting, selecting & grouping records
  • Creating formulas & linking
  • Using Report Expert & sharing data

This beginners course will give you a thorough grounding in the basics.

  • Introduction to Crystal Reports

  • Creating basic Reports

  • Sorting, selecting & grouping records

  • Creating formulas & linking

  • Using Report Expert & sharing data

  • Examining the application’s capabilities
  • Reports and databases
  • Modifying the program default settings
  • Using help
  • Identify the sections of the report
  • Create a new report
  • View your report as it will print
  • Format your report by changing the size and position of the fields
  • Enhance your report by adding a report title and changing the attributes
  • Add page numbers, logos or other graphics in your report
  • Save your report
  • Sort records
  • Use the Select Expert to limit records
  • Add an additional selection criterion using the “And” statement
  • Modify composite formulas and the selection criteria statement
  • Define a single and multiple level group
  • Modify grouping options
  • Insert subtotals and grand totals
  • Insert summary fields
  • Insert percent of the total fields
  • Use Top N/Sort Group Expert
  • Understanding cross-tab reports
  • Use the Cross-Tab Expert
  • Edit your cross-tab report
  • Modify cross-tab layout options
  • Format your cross-tab report
  • Understand relational database concepts
  • Use the Visual Linking Expert
  • Examine Link Options
  • Difference between PC and SQL links
  • Understand Formula Components
  • Create formulas using the Formula Editor
  • Make changes to formulas
  • Create and use String formulas
  • Create and use Date functions
  • Work with summary formulas
  • Create and use If-Then-Else functions
  • Review sections
  • Resize sections in Design view
  • Use the Section Expert
  • Create Summary and Drill Down reports
  • Identify exporting options
  • Export a report into office applications
  • Create a report using spreadsheet data
  • Discuss Web browser options to view reports online

This is a beginners’ course. We do not assume that you have used Crystal Reports before.

This course assumes that you have a basic understanding of working with computers, so you’re comfortable working with multiple windows, navigating the desktop and have an understanding of computer file storage (i.e. drives, files and folders). So long as you’re happy with that you’ll be fine.

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £695.00 (+VAT)

  • Easy booking

  • Money back guarantee

  • Post-course support

Book Now
Crystal Reports Training – Advanced

Crystal Reports Advanced

CPD Certified
4.93 / 5
2 days.
Client Site Courses Available.
Live Online & Client Site.

Become a Crystal Reports expert on this advanced course!

  • Using parameters & formulas
  • Working with charts & maps
  • Creating sub-reports
  • Report processing
  • SQL Queries

Become a Crystal Reports expert on this advanced course!

  • Using parameters & formulas

  • Working with charts & maps

  • Creating sub-reports

  • Report processing

  • SQL Queries

  • Adding and deleting report sections
  • Hiding sections
  • Closing drill down tab
  • Showing sections
  • Suppressing sections
  • Don’t suppress section
  • Suppressing sections conditionally
  • Parameter fields options: Wildcard, Edit masks
  • Static, dynamic and cascading parameter fields
  • Formula workshop
  • Variables, types and scope
  • Multi-pass reporting
  • Evaluation Time functions
  • For & While Loops
  • Range variables
  • Built-in running total options: summary, evaluate and reset
  • Creating built-in
  • Modifying built-in
  • Delete
  • Manual
  • Types, layout and expert
  • Creating and modifying
  • Changing chart options
  • Formatting Individual chart elements
  • Group chart custom changes
  • Working with chart templates
  • Deleting charts
  • Inserting an unrelated sub-report
  • Inserting a linked sub-report
  • Edit
  • Format options
  • Using shared variables
  • Working with on-demand sub-reports
  • Creating custom on-demand captions
  • Creating
  • Editing
  • Enabling and disabling
  • Deleting
  • Types and layouts
  • Creating and working with maps
  • Modifying and deleting maps
  • Report Performance Information
  • Server-side processing
  • Verify database
  • Mapping fields
  • Working with the workbench
  • Overview
  • SQL Queries; server side processing, clauses, statements, rules
  • Creating a report using a SQL query
  • Editing a SQL command
  • Working with the Group By clause
  • Creating, editing and deleting a SQL expression field

As this is an advanced course it assumes that you understand the basics of working in Crystal Reports.

To attend this course you should have:

  • Attended our Crystal Reports Introduction training course, or
  • Have a working knowledge of Crystal Reports to an equivalent level.

You will also preferably have some hands-on experience using Crystal Reports in a working environment.

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £795 (+VAT)

  • Easy booking

  • Money back guarantee

  • Post-course support

Book Now

Easy booking & payment

Money back guarantee

Post-course support

Crystal Reports FAQs

For General FAQs and Booking questions, see our FAQ Page.

Crystal Reports is a business intelligence reporting tool that allows users to create detailed, formatted reports from almost any database or data source.

First released in 1991, it has been embedded in hundreds of enterprise software systems over the decades – which is a large part of why so many organisations still use it today.

If you work in finance, operations, manufacturing, or any function that relies on a business system:

There’s a good chance Crystal Reports is already involved in producing the reports and documents your organisation runs on.

Crystal Reports is used to extract data from databases and business systems and turn it into precisely formatted, print-ready documents and reports.

Its particular strength is producing what are often called “pixel-perfect” reports – layouts where the formatting, positioning, and structure need to be exact, regardless of the data.

Common uses include: financial statements, invoices, payroll summaries, regulatory compliance documents, operational dashboards, and any report that needs to look identical every time it’s run.

They do different things well, and the honest answer many organisations use both.

Crystal Reports is already integrated in many workplaces across the UK, so it’s still a very valuable skill.

However, Power BI is a much more user-friendly, and modern software.

If you don’t already need or use Crystal Reports, we would recommend Power BI.

Where Do Your Courses Run?

London Training Venue & Course Details

44 Southampton Buildings
London, WC2A 1AP
Tel: 0203 603 0150

Our City of London training centre sits in Holborn, one of central London’s most accessible locations. From the West End, Paddington or Canary Wharf – you’re rarely more than 20 minutes away.

See the full London location details here.

Guildford Training Venue & Course Details

Surrey Technology Centre, 40 Occam Road
Guildford, GU2 7YG
Tel: 01483 688 488

See the full Guildford location details here.

Online Courses

We run a full schedule of remote courses over Zoom.
We also deliver private courses over Teams, if requested.

What Do Previous Delegates Say

4.93 from 29 reviews

Kim Dickinson, Africa Express Line Ltd Business Analyst

Great, friendly, calm, relaxed atmosphere allowing me to concentrate totally on the subjects at hand & where I needed to focus most.

Harry Kerr, Scania Finance Great Britain Limited Finance Administrator

Lewine is a very knowledgeable trainer who answered company specific questions as best as she could with information provided.

Laura Key, Land & Water Plant Ltd Management Accountant

Janet was very patient and thorough and always helped us relate what we were learning to how we would use it at work. Would definitely attend another course.

Andy Hassen, Rivertrace Ltd Finance Manager

One to one training and being able to focus on any issues I may of had.

Steve Tutt, Kakapo Systems Marketing Director

Cross tabs was helpful.

Catherine Massey, Fina Systems Ltd Training

Ability to put into use.

Alex Segal, S Simmonds & Son Ltd Retail Buyer

Learning some SQL in the course.

Alex Gazzaniga, Photofabrication Sales Account Manager

Simple and relatable content, builds the subject and complexity gradually. Very flexible as there was only 2 of us from the same company.

Wayne Deakin, Photofabrication Planning and Graphics Supervisor

I found the course to be well catered towards my real world job needs. Any and all questions were listened to and answered. One of the better courses I have been on.

Ian Wilson, Photobox Ltd

Understanding how to read existing Crystal Reports and build my own.

EJ Darlington, Information Systems Developer

Being able to ask questions off topic was helpful.

Sarah Bridger, Accounts Manager

Everything was good.

Joe Johnson, Finance Assistant

Personalised exercises adapting to our questions relating to what we need to learn.

Ngozi Akinsola, Database Systems Coordinator

The fact that it was a one to one training session and how easy it was to ask the tutor questions, she was very patient and detailed.

Sarah Bridger, Accounts Manager

Everything was good.

Jon Newman, Management Accountant

As a 1-2-1 session it allowed for a good focus on real life examples.

Jack Gray, Business Analyst

Trainer worked at our pace, introduced us to additional features when they were relevant to our needs and always answered questions fully even if they were outside the scope of the course.

Kristin Smith, IT Project Manager

It showed me how I would likely to be able to use Crystal Reports, really useful and interactive couple of days. Great trainer, kept it at the right level so we didn't get lost in all its capabilities.

Ewart VanCooten, Analyst Developer

The course was tailored to my specific learning needs and very well presented.

Matthew Spooner, Nationwide Hire Ltd Customer Service Assurance Manager

Quick computers, enough refreshment breaks etc..

Getting To Know You

Letting us know before the course which areas you would like to focus on is very helpful.

Tell Us What You Are Looking For From Your Course ->

Please note if you are unsure of the syllabus for your course please see the relevant course block above.