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

Nov 21, 2014

10 ways to foster a learning culture within your organisation

The word ‘learning’ does not just have to refer to putting people in classrooms or taking them out of the office on a week-long training programme. It can mean something more organic than that, more ingrained into the fabric of your organisation and the way people work every day. By creating and

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 >