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