Crystal Reports Training

Level: Intermediate
Rating: 4.6/5 4.64/5 Based on 64 Reviews

In this hands-on Crystal Reports course, you will learn to create sophisticated reports from the ground up and transform raw data into meaningful information. You will gain the knowledge and skills to link multiple data sources and create effective presentations using Crystal Reports. After this training course, you will return to your organisation with a detailed process to help you retrieve and format data, create meaningful reports for widespread distribution, and integrate your reports with a website or application, such as .NET.

Key Features of this Crystal Reports Training:

  • After-course instructor coaching benefit
  • Learning Tree end-of-course exam included

You Will Learn How To:

  • Develop reports to transform data into meaningful information
  • Create advanced graphical and crosstab reports
  • Add calculations and program logic with the Formula Workshop
  • Connect to data sources and extract data to meet reporting needs

Choose the Training Solution That Best Fits Your Individual Needs or Organisational Goals


In Class & Live, Online Training

  • After-course instructor coaching benefit
  • Learning Tree end-of-course exam included
View Course Details & Schedule

Standard £1345




Team Training

  • Bring this or any training to your organisation
  • Full - scale program development
  • Delivered when, where, and how you want it
  • Blended learning models
  • Tailored content
  • Expert team coaching

Customize Your Team Training Experience


Save More on Training with Learning Tree Training Vouchers!

Our flexible, easy-to-redeem training vouchers are available to any employee within your organisation. For details, please call 0800 282 353 or chat live.

In Class & Live, Online Training

Note: This course runs for 2 Days

  • 31 Mar - 1 Apr 2:00 PM - 9:30 PM BST Online (AnyWare) Online (AnyWare) Reserve Your Seat

  • 27 - 28 Sep 2:00 PM - 9:30 PM BST Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.

Crystal Reports Course Information

  • Recommended Experience

    • Should be comfortable using Windows and working with a spreadsheet or word processor
    • Experience working with formulas in a spreadsheet program
  • Which software is being used?

    • This course cover the latest version of Crystal Reports 2016 and backwards compatible to 2008. Any new changes or additions in later versions will be identified so students will know exactly what is included in their Crystal Reports version.

Crystal Reports Course Outline

  • Overview of Crystal Reports

    • Formatting and summarising data
    • Filtering, sorting and grouping data
    • Customising reports with business logic
    • Connecting to SQL Server, Oracle and Access databases
  • The Crystal Report Writer

    Writing a basic report

    • Selecting a format
    • Adding text and fields
    • Connecting to remote data sources
    • Configuring the reporting environment

    Formatting and styling

    • Tailoring sections within a report
    • Designing fields for quality presentations
    • Highlighting data with Highlight Expert
  • Linking Crystal Reports to Data

    Connecting to popular data sources

    • SQL Server
    • Oracle
    • Access
    • Web logs
    • XML
    • Reporting from stored procedures and views

    Establishing data connections

    • Creating a connectivity checklist
    • Configuring ODBC and OLE DB
    • Integrating SQL commands in a report
  • Interpreting Structures and Retrieving Data

    Navigating complex data

    • Deciphering data structures
    • Identifying data relationships

    Gathering the right data

    • Merging data from multiple tables
    • Building business queries
  • Combining Powerful Report Techniques

    Organising and summarising reports

    • Sorting user sort control and grouping
    • Summary and Rolling Total fields

    Building advanced reports

    • Embedding linked and unlinked subreports into reports
    • Creating crosstab and drill-down reports
    • Designing dynamic and cascading prompts
    • Hyperlinking Reports and Multilingual Reports
    • Achieving reusability with templates

    Visualising complex data

    • Simplifying data with charts and graphs
    • Organising fields into sections
    • Adding, merging, suppressing sections
  • Programming Data Functionality

    Coding in formula language

    • Working with variables and operators
    • Deciphering formula syntax
    • Adding and modifying formulas
    • Calling and working with functions

    Writing effective formulas

    • Building if/then/else statements
    • Converting and comparing data
    • Debugging the code
    • Employing the Formula Workshop

    Converting to Basic Syntax

    • Writing formulas with Basic Syntax
    • Laying a foundation for complex reporting logic

Team Training

Crystal Reports Training FAQs

  • Can I learn to Crystal Reports online?

    Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want. This course is available in class and live online.

  • What version of Crystal Reports is this course applicable for?

    This course cover the latest version of Crystal Reports 2016 and backwards compatible to 2008.

Questions about which training is right for you?

call 0800 282 353
chat Live Chat

100% Satisfaction Guaranteed

Your Training Comes with a 100% Satisfaction Guarantee!*

*Partner-delivered courses may have different terms that apply. Ask for details.

Online (AnyWare)
Herndon, VA / Online (AnyWare)
Preferred method of contact:

Please Choose a Language

Canada - English

Canada - Français