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

Dates
Duration
2 Day
Location
Crawley
Price
£680.00+VAT

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

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

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















RELEVANT BLOG POSTS

Enhance your potential

KEEP UPDATED WITH THALES L&D:

Subscribe

Blog

Apr 24, 2015

Primavera P6 and PRA Features and Beneftis Guide

Primavera P6 and PRA Features and Benefits GuideThis informative guide will provide you with the valuable information the features and benefits of Primavera P6 and PRA.Primavera Enterprise Project Management (P6)This offers a comprehensive project management toolset for the effective management of p

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

Customer Days 2015

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

12th June - A focus on Sales in a complex environment. Content TBC

4th September - Content TBC

4th December - Content TBC -

To book your space click here

 

More events >