Crystal Reports Training

We specialise in delivering on-site courses allowing report development from your Company database.

For those with little or no knowledge of Crystal Reports we offer a Basic Design Course while for those who have attended this course or who are experienced report writers we offer an Advanced Course tailored to suit individual needs.

Having completed a course with us, we offer 1 months free email support to ensure that you get up and running with your report writing as soon as possible.

Basic Design Course - from £550 per day

A 2 or 3 day training course depending on the experience of the candidates and your precise training requirements. We will always discuss your needs prior to any course to ensure that you get the maximum benefit from it.

Prerequisites
Although it is useful for candidates to have some knowledge of database concepts it is not essential as this area is covered by the course.

Overview
The course is designed for those with little or no experience of Crystal Reports who wish to gain sufficient knowledge of the software to produce presentation quality basic reports. Group sizes are usually kept to 4 or less and training is largely hands-on with reporting exercises used to reinforce learning.

The course is delivered at your premises and uses the Crystal Reports sample database to cover the essential concepts, progressing to your company database to produce real life reports. The course outline applies to all versions up to Crystal Reports 2013.

Course Outline

In addition to the subject areas shown, we will also cover techniques that we believe will be relevant to your particular requirements. 

 Report Layout and DesignSorting and Selecting Records 
 Use of guidelines and grids Single and multiple sort criteria
 Inserting and formatting text objects Single and multiple selection criteria
 Adding lines, boxes and pictures Group selection
 Inserting and formatting data fields Selection based on saved data
  
 Grouping and Summarising Linking Multiple Database Tables
 Creating single and multi level groups Adding database tables
 Use of the drill-down facility Identifying link fields
 Adding summary fields Linking options and join types
 Sort orders applied to groups 
 Creating running totals 
  
 Parameter Fields Formula Fields
 Concept of parameter fields Using simple maths functions
 Creating dynamic and static parameters Manipulating text strings
 Setting up default values Dealing with date calculations
 Using parameters in record selection Boolean formulas
 Using parameters to change sort order If-then-else and other control structures
  
 Conditional Formatting Cross-Tab Reports
 Use of formulas in section formatting Creating a cross-tab report
 Use of formulas in field formatting Adding rows and columns
 Adding alerts to reports Summary field options
 Use of highlighting Formatting a cross-tab report
  
 Charting Sub Reports
 Creating charts using the Chart Expert Inserting a sub report
 Using cross-tab data Using an existing report as a sub report
 Using summary field data Use of on-demand sub reports
 Formatting and style options Setting up sub report links
  
 Exporting Reports 
 Destination options 
 Format options and setting defaults 

Advanced Course - from £550 per day

A 1 or 2 day course covering advanced techniques and tailored to each clients own needs. Often this course is part training, part consultancy, with the aim being to give candidates the skills and knowledge necessary to overcome their specific reporting challenges.

Prerequisites
Candidates should have completed the Basic Design Course or have experience of producing their own Crystal Reports.

Overview
As with the Basic Design Course, training is delivered at your premises and uses both the Crystal sample database and your company database.

Course Outline

Due to the tailored nature of this training the following are only examples of some of the areas that may be covered. 

 Variables Advanced Formulas                        
 Concept of variables Alternatives to if-then-else
 Significance of evaluation time Creating custom functions
 Scope options Use of loops
 Passing values to and from sub reports Creating SQL Expression fields
  
 Arrays SQL Commands
 How and when to create an array Using commands rather than tables
 Displaying the contents of an array Passing parameters to commands
 Finding values in an array 



To find out whether we can help with your particular training requirements please e-mail your details to info@crystolutions.co.uk or complete our Contact Form.

                                        

Back to Top