IT & Business Systems Training Courses

Crystal Reports Modules 1 and 2 – Creating and Modifying Reports Course

IT Capability Banner 2

Book this course

2 Day
£680.00 +VAT

Course description

SAP Crystal Reports is a powerful business intelligence tool that allows users to design and generate reports from a wide range of data sources.

We show you all the essential features and techniques that will enable you to proficiently create and modify reports with this software – from sorting, grouping and summarising data, to working with tables and formulas.

Is it right for me?

If you’re completely new to Crystal Reports, or you simply want to refresh your existing knowledge – this introductory Crystal Reports training course will provide you with the essential skills you need. 

What will I get out of it?

By the end of the course you will be able to:

  • Select and sort database records in a report
  • Produce simple, grouped and summarised reports
  • Include calculations and conditional formatting in reports

The learning environment was excellent. Paul was very knowledgeable and helped me gain a good understanding of the system. Excellent course and environment which I would recommend to others.

eRostering System Manager, Basildon Hospital

What does it cover?

  • Database, tables and fields
  • Understanding the data
  • Direct access or ODBC
  • Starting a new report
  • Report layout
  • Report views
  • Adding, moving and sizing fields
  • Adding, moving and sizing objects
  • Previewing data
  • Refreshing data
  • Saving a report
  • Editing and formatting text objects
  • Text fields
  • Number fields
  • Date and time fields
  • Using the select expert
  • Adding and editing selection criteria
  • Using logical operators
  • Setting the report date
  • Applying a sort order
  • Adding and editing a group definition
  • Reordering groups
  • Grouping on a date field
  • Summarising
  • Adding a subtotal
  • Adding a grand total
  • Top N / sort group
  • Hiding detail
  • Using drill down
  • Inserting text objects
  • Text rotation
  • Combining text and fields
  • Formatting objects
  • Adding and formatting special fields
  • Inserting boxes, lines and graphics
  • Creating reports using more than one table
  • Using the visual linking expert
  • Relationships and join types
  • Changing join types
  • Removing tables
  • Creating parameters
  • Creating selection list parameters
  • Editing parameters
  • Creating and editing a formula
  • Numeric calculations
  • Date calculations
  • Percentages
  • Using IF formulas
  • Using the highlighting expert
  • Conditional formatting
  • Changing the size of sections
  • Using the section expert
  • Group section breaks
  • Changing backgrounds

Book this course

2 Day
£680.00 +VAT

Other recommended courses

Show more courses +

Course leader

Paul Terry

L&D Consultant, IT Solutions

Need a bespoke solution?

Talk to us about setting up a course that is tailor made for you.


Enhance your potential




Nov 27, 2015

Assimilating Technology into the Workplace

Assimilating Technology into the WorkplaceThe digital revolution has been gaining momentum for the past three decades or so, and while almost everyone these days uses some form of modern tech to benefit their lives, there remain a surprising number of people who continue to resist the influx of tech

Thales Blog >


Visit us on Twitter >


Apprentices are in high demand – research by Barclays shows that £4.4bn would be injected into the UK economy if more businesses employed them. Thales UK is a proud member of The 5% Club which is focused on creating momentum behind the recruitment of apprentices and graduates into the workforce.
As part of Thales UK’s commitment to nurturing raw 

Join the discussion >


31st March - Intelligent Outsourcing, Programme Management & Organisational Health

2nd July - Digital Learning & Workforce Planning

1st October - Discovery Center launch


Book Now >