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.
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.
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.
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 Design||Sorting 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|
|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|
|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.
Candidates should have completed the Basic Design Course or have experience of producing their own Crystal Reports.
As with the Basic Design Course, training is delivered at your premises and uses both the Crystal sample database and your company database.
Due to the tailored nature of this training the following are only examples of some of the areas that may be covered.
|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|
|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|