LightningCrystal Reports

Introduction ŕ Intermediate Training

From Chase International

 

 

Course Description

This 2 day, instructor-led training course is designed to enable delegates to create powerful database reports using Crystal Reports.  You will cover a wide range of features and learn how to plan, create and distribute reports which analyse database information.

 

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 report designer, new to Crystal Reports or wishing to brush up current skills, responsible for creating and distributing database reports.

 

Course Content

Report Planning

Creating a Report
  • Planning a report

·         Using and linking tables

·         Connecting to data sources

·         Inserting objects on a report

·         The design environment

·         Positioning and sizing and formatting objects

·         Previewing and saving a report

·         Using the Select Expert

Selecting Records

·         Defining saved and refreshed data

·         Setting the record selection criteria

·         Applying time-based record selection

·         Applying and modifying record selection
  • Sorting records

Data Organisation
  • Summarising data
  • Grouping records

·         Adding graphics to report

Formatting

·         Applying specialised formatting

·         Merging data with text objects

Section Formatting

·         Using in built functions
  • Creating summary reports
  • Formatting Sections

Creating Formulas
  • Advanced Section Features
  • Using the Formula Workshop
  • Using the Formula Editor
  • Text, Numeric and Date Functions
  • Functions and Operators
  • Boolean Formulae
  • If-Then-Else and Select Case

Conditional Reporting
  • Formula Tips & Techniques
  • Using the Highlighting Expert
  • Formatting data conditionally
  • Creating and using Charts

Visual Representation

Report Styles
  • Creating and using Maps
  • Report examples & tips
  • Different report styles

Building Parameterised Reports
  • Report templates
  • gsaprovBuilding a report with parameters
  • Defining and creating parameters
  • Grouping using parameters
  • Using edit masks and descriptions

Distribution of Reports
  • Distributing reports to users
  • Distributing reports to users
  • Database and reporting concepts
  • Exporting a report
  •  
  • Publishing to CRS InfoView

 

Pre-Requisite Knowledge

chaseNo prior knowledge is required, knowledge of Windows conventions is useful.  Basic database concepts

will be covered if required.

 

Additional Training

This course may be followed by the Chase International Crystal Reports Advanced training course.

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