Site Network: Main Site | Client Login | Trainer Login

Your Shopping Cart is Empty.
  

2 day course

Crystal Reports 8.5 Introduction

Overview

  • Examining the Capabilities of Crystal Reports
  • Planning Your Report
  • Database Files and ReportTypes
  • Modifying the Program Default Settings
  • Using Help

Creating Basic Reports

  • Report Sections
  • Generating a New Report
  • Viewing Your Report
  • Changing the Size and Position of Your Fields
  • Formatting Your Report
  • Adding the Finishing Touches to Your Report
  • Saving Your Report

Sorting and Selecting Data

  • Using Sort Options
  • Using the Select Expert
  • Using Multiple Criteria in the Selection Formula
  • Changing the Record Selection Formula

Grouping and Summarizing

  • Understanding Group Components
  • Defining Multiple-level Groups
  • Working with Grouping Options
  • Inserting Subtotals and Grand Totals
  • Working with Summary Fields
  • Calculating the Percentage of the Group to theGrand Total Functions
  • Using Grand Total Summary Function
  • Using the Top N/Sort Group Expert

Using the Report Expert

  • Creating a New Report Using the Standard ReportExpert
  • Creating a New Report Using the Mail Label ReportExpert
  • Editing Reports Using the Report Expert

Cross-tab Reports

  • Using Cross-tab Reports
  • Using the Cross-Tab Expert
  • Working with Existing Cross-tabs
  • Understand Cross-tab Layout Features
  • Formatting Options

Linking

  • Understanding Relational Database Basics
  • Using the Visual Linking Expert
  • Understanding Link Options
  • Understanding Link Options for PC and SQL Databases

Creating Formulas

  • Understanding Formula Components
  • Using the Formula Editor to Create Formulas
  • Modifying Your Formulas
  • Using String Functions
  • Using Date/Time Functions
  • Using If-Then-Else Statements in Formulas
  • Calculating Your Own Summary Fields

Formatting Sections

  • Reviewing Sections
  • Resizing Sections in Design View
  • Formatting Sections with the Section Expert
  • Creating Summary and Drill-down Reports

Distributing Data

  • Exporting a Report to Another File Format
  • Integrating Your Information with Office SuiteSoftware
  • Creating a Report from Excel Data
  • Using Crystal Enterprise for Web Reporting

Overview

A ‘hands-on’ course which will introduce delegates to the basic features and benefits of Crystal Reports.

Prerequisites

No prior knowledge of the product is required. Basic computer skills are assumed, and

Benefits

Students will be able to produce presentation quality, well structured basic reports.

Target student

Anyone needing to produce reports from external data sources, for example Access, SQL, Oracle etc.

What's next

Crystal Reports 8.5 Advanced is the next course in this series.

Private Training Courses

We offer private training courses which may be delivered at our training centre or at your premises on dates to suit you and your delegates. Course content can follow the standard course material as listed in the course outline, or can be tailored to your specific requirements at no extra cost.

For a single company private course we normally recommend that any class does not exceed 8 delegates in order to ensure that the learning objectives are met.

Total price per day (ex-Vat)
Number of delegates 1 2 3 4 5 6 Extra Person
At our Reading Training Centre £695 £775 £855 £935 £1015 £1095 £80
On your premises £595 £665 £735 £805 £875 £945 £70

 

For on-site courses only:

  • Notebook computer hire is £40 per computer per day. Savings can be made for block bookings of 2 or more days, please ask for details.
  • Trainer travel and accomodation is charged at cost and we can give you a fixed price quote for this prior to booking.

Course fees are payable in advance and are listed exclusive of VAT.