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

Dates
Duration
2 Day
Location
Crawley
Price
£650.00+VAT

A bespoke course, at a venue and date of your choice.

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

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.

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 you’ll learn

By the end of the programme you’ll be able to:

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

What’s covered

Planning a report

  • Database, tables and fields
  • Understanding the data

Connecting to data

  • Direct access or ODBC

Creating a new report

  • 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

Formatting objects

  • Editing and formatting text objects
  • Text fields
  • Number fields
  • Date and time fields

Record selection

  • Using the select expert
  • Adding and editing selection criteria
  • Using logical operators
  • Setting the report date

Sorting and grouping

  • Applying a sort order
  • Adding and editing a group definition
  • Reordering groups
  • Grouping on a date field

Grouping and summarising

  • Summarising
  • Adding a subtotal
  • Adding a grand total
  • Top N / sort group
  • Hiding detail
  • Using drill down

Working with text objects

  • Inserting text objects
  • Text rotation
  • Combining text and fields
  • Formatting objects

Special fields and graphics

  • Adding and formatting special fields
  • Inserting boxes, lines and graphics

Linking tables

  • Creating reports using more than one table
  • Using the visual linking expert
  • Relationships and join types
  • Changing join types
  • Removing tables

Record selection using parameters

  • Creating parameters
  • Creating selection list parameters
  • Editing parameters

Formulas

  • Creating and editing a formula
  • Numeric calculations
  • Date calculations
  • Percentages
  • Using IF formulas

Conditional reporting

  • Using the highlighting expert
  • Conditional formatting

Section formatting

  • Changing the size of sections
  • Using the section expert
  • Group section breaks
  • Changing backgrounds

Customer Testimonials

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

Paul Terry

Course Leader

Enhance Magazine

Issue 3 out now!

READ

HAVE A QUESTION?

Talk to us about how training can enhance your business















Enhance your potential

KEEP UPDATED WITH THALES L&D:

Subscribe

Blog

Dec 11, 2014

How to cultivate emotional intelligence in your staff

Emotional intelligence (EI) – described by business psychologist Dr Susan David of Harvard University as ‘the ability to solve problems with and about emotions effectively’ – is essentially the measure of how well a person monitors their own emotions and the emotions of others, and how they

Thales Blog >

Tweets

Visit us on Twitter >

Group

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 >

Events

HR Leadership Dialogue

When: 1st & 2nd July 2014

Where: Beaumont House, Old Windsor. 

 

More events >