Crystal Reports Module 3: Advanced Reporting Techniques Course

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

Once you’ve mastered the basics of Crystal Reports, it is a powerful tool. But there are a number of advanced features and techniques that can make this software even more effective.

We show you some of the more powerful functions this software is capable of – from charts and cross tab reports, to working with data calculations – extending your knowledge beyond simple list-style reports.

If you’re already confident in building simple reports with this software – either you’ve attended our Crystal Reports Modules 1 and 2 (Creating and Modifying Reports), or have equivalent knowledge – this advanced Crystal Reports training course will enhance your current skill level.

What you’ll learn

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

  • Include and modify graphs within reports
  • Summarise data using a cross tab report
  • Produce reports that incorporate sub-reports
  • Create running totals
  • Use date calculations

What’s covered

Charts (graphs)

  • Creating and editing graphs
  • Formatting graphs
  • Using the Chart Expert
  • Templates
  • Top N graphs

Cross tab reports

  • Creating a cross tab report
  • Linking data tables
  • Formatting
  • Inserting multiple rows and columns
  • Inserting summarised fields
  • Using styles

Advanced cross tab reports

  • Filtering by group
  • Specifying a group order
  • Top N values
  • Using formula fields
  • Using parameter fields

Reports with sub-reports

  • When to use a sub-report
  • Inserting a sub-report
  • Linking to the primary report
  • Modifying a sub-report

Running tools

  • Running totals for lists and groups
  • Creating a conditional running total

Working with data calculations

  • Using the DATEDIFF function
  • Extracting year and month values
  • Custom date periods
  • Creating a date from numbers

Customer Testimonials

Paul did a very good job of understanding by level of ability, and focusing on what I needed to understand. Very good, explained himself well.

MI Analyst, Accord Office Supplies Ltd

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 >