Crystal Reports Advanced

Course Code: CRADV   Duration: 2 Days   Price: £745+VAT

This two-day course covers topics to a more in-depth level in areas such as reporting, formatting and formulae.


This course follows on from the 2-day Crystal Reports Introduction course and is designed for delegates looking to be able to use Crystal Reports to a higher level. 


Delegates should have attended the Crystal Reports v11 Introduction course or have equivalent knowledge. 

Course Contents

Review of Introductory Course

Creating Drill-Down Reports

  • Hiding/Suppressing Sections
  • Hiding/Displaying Sections Conditionally

Section Formatting

  • Section Expert      
  • Adding/Modifying sections
  • Creating a Letter
  • Underlaying Sections


  • Linked/Unlinked subreports   
  • On-Demand Subreports
  • Using Variables within Subreports

Advanced Report Processing

  • SQL Commands / SQL Expression fields
  • Multi-Pass Reporting
  • Report Performance Information
  • Additional Database Options

Charts & Maps

  • Creating Charts with the Chart Expert
  • Formatting Charts
  • Creating & Formatting Maps


  • Adding Cross-tabs
  • Formatting Cross-tabs      
  • Charting on Cross-tabs

Advanced Formulae

  • Formula Workshop
  • Custom Functions
  • Advanced Functions
  • Using Running Totals
  • Variables and Arrays

Advanced Report Formatting

  • Applying a Crystal defined template       
  • Creating a Template      
  • Workbench
  • Dependency Checker
  • Setting Default Report Options

Head Office

Skilltec Training

58 New George Street
City Centre
01752 227330

Follow us on:

Payment methods:

Registered in England 06131527

Registered address: 58 New George Street, Plymouth, PL1 1RR