IT & Business Systems Training Courses

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

IT Capability Banner 2

Book this course

Dates
Duration
2 Day
Location
Crawley
Price
£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

Dates
Duration
2 Day
Location
Crawley
Price
£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.

RELEVANT BLOG POSTS

Enhance your potential

KEEP UPDATED WITH THALES L&D:

Subscribe

Blog

Jun 30, 2015

Top 10 Missed Opportunities in L&D

The Top 10 Missed Opportunities in L&DInvestment in L&D is not simply about solving pre-existing business problems or overcoming challenges (although targeted learning can, and should, do both of those things if necessary). It is also about creating, and capitalising on, opportunities which

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

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

2nd July - Digital Learning & Workforce Planning

1st October - Discovery Center launch

 

Book Now >