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

Oct 16, 2014

The winning formula for employee retention and engagement

By Debbie Vernon, Head of HR for TLD and the Thales UK finance functionTwo questions frequently asked by organisations are: how do we make sure our employees are fully engaged with the business and their role, and how do we hold on to our talent? All too often, employers complicate these two reasona

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 >