Crystal Reports 8.5 Introduction

2 days

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.

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

Systematix Training - tel: 0118 3243000 - www.systematix.co.uk
Crystal Reports 8.5 Introduction training courses