Crystal Reports

Advanced Training

From Chase International

 

 

Course Description

This 2 day, instructor-led training course is designed to enable delegates to build on skills learned in the Introductory ŕ Intermediate Course.  You will gain increased knowledge and depth of understanding in the more complex areas of Crystal Reports.  You will be able to create faster, more efficient reports that are designed to be effective and clear for the viewer.  Tips & Techniques from years of Crystal Reports consultancy and training experience are included in this Chase course.

 

Course Cost

Course cost includes any courseware, handouts and the book “The Complete Reference Guide to Crystal Reports” by George Peck.  If course is off-site it also includes lunch and refreshments.  Costs are dependant on location and number of delegates.

 

Product Editions and Versions

This course can be delivered to users of any version and edition of Crystal Reports from Version 8.5 to the current XI R2.  Editions covered – Professional, Developer, Server.

 

Who Should Attend?

Any Crystal Reports report designer wishing to enhance current skills and increase knowledge.

 

Course Content

 

Overview

Sub-Reports
  • Overview with practical activity
  • Defining when to use sub-reports

            to cover previous course/knowledge
  • Creating an unlinked sub-report

Crystal Repository
  • Creating a linked sub-report

·         Using the Repository
  • Creating an on-demand sub-report

·         Creating a report from a repository data source
  • Using shared variables in sub-report

·         Benefits of the Repository
  • Sub-reports Tips & Techniques

Advanced Formulas

Report Processing and Optimisation

·         Using Functions
  • Multi-pass reporting

·         Creating complex formulas
  • Evaluation Time functions

·         Defining control structures
  • Dynamic Arrays

·         Using variables
  • SQL Functions

·         Using arrays
  • SQL Expressions

·         Looping formulas
  • Grouping on Server

Custom Functions
  • Optimisation Tips & Techniques
  • Creating custom functions

Specialised Reporting
  • Using and modifying custom functions
  • Form letters & other report styles

Summarising Data with Cross Tabs
  • Using Running Totals
  • Building a cross-tab
  • Including Hyperlinks
  • Formatting a cross-tab
  • Dynamic Graphic Locations

Advanced Formatting

  • Building a report with alerts

·         Advanced report section formatting
  • Using Top N Selection effectively

·         Advanced report styles and Tips & Techniques
  • Advanced Charting and Maps

·         Using and building Report Templates

Managing Reports

 

·         Using the Workbench

 

·         Publishing Reports to InfoView

 

·         Report Management and Distribution discussion

 

 

 

Pre-Requisite Knowledge

Knowledge of Crystal Reports to at least Introduction/Intermediate level.  Knowledge of database

concepts and Windows conventions will be assumed.

 

Additional Training

This course may be followed by on-site workshop style training specifically looking at particular reporting requirements.  Users of Crystal Reports Server may follow on with additional Administrator and InfoView

training.  For more information and specific costs :- www.chase-international.com - 01491 572987