• Moneyback Guarantee
    -
    100% Peace of mind
  • Expert Trainers
    -
    >12 years experience
  • Happy Customers
    -
    92% book again
  • Rated Outstanding
    -
    11 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

Overview

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

Full Syllabus

  • 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

Am I Ready?

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.

Instructor

CPD Accreditation

Dates, Prices & Booking

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £695 (+VAT)

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

Overview

Become a Crystal Reports expert on this advanced course!

  • Using parameters & formulas

  • Working with charts & maps

  • Creating sub-reports

  • Report processing

  • SQL Queries

Full Syllabus

  • 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

Am I Ready?

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.

Instructor

CPD Accreditation

Dates, Prices & Booking

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: ££795.00 Now £745 (+VAT)

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

Guildford Training Venue & Course Details

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

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

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