Crystal Reports Module 3: Advanced Reporting Techniques Course

Crystal Reports Module 3 – Advanced Reporting Techniques

1 DayCrawley£325.00+VAT

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.


Course Detail

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
1 DayCrawley£325.00+VAT