Training for Crystal Reports from Activia

Crystal Reports XI Introduction

A 2-Day Training Course

Course Content

Course Aims

Delegates will learn how to use Crystal Reports XI to build basic list and group reports that work with almost any database.

Who Should Attend

This intensive, hands-on two-day training course is designed for people who need output from a database, where their database programs have limited reporting tools, and/or they may not have access to those tools. They may or may not have programming and/or SQL experience, but must be familiar with basic database concepts, such as those covered in the Microsoft Access Introduction course.

Setup of PCs for training

PCs used for training should have the Microsoft Windows operating system, with Crystal Reports, Microsoft Office (with printer drivers for Print Preview) and Adobe Reader installed.

Course Outline
This course is a 2-day training course structured into 8 modules.
Module 1
Creating a Report
Topics covered
  • Set Default Report Settings
  • Specify Fields for a New Report
  • Preview a Report
  • Modify Field Display
  • Add a Report Title
  • Position Fields
  • Add Fields from Other Tables
  • Module 2
    Displaying Specific Report Data
    Topics covered
  • Find Data
  • Sort Data
  • Filter Data by a Single Criterion
  • Module 3
    Grouping Report Data
    Topics covered
  • Insert a Group
  • Add Summaries
  • Format Summary Information
  • Change Group Options
  • Add a Second-Level Grouping
  • Filter Records by Group
  • Create a Top N Sort Group
  • Module 4
    Building Formulas
    Topics covered
  • Create a Formula
  • Edit a Formula
  • Combine Fields by Formula
  • Delete a Formula
  • Filter Data by Multiple Criteria
  • Modify a Filter Using an OR Operator
  • Create a Parameter Field
  • Account for Null Fields in a Formula
  • Module 5
    Formatting Reports
    Topics covered
  • Remove White Space
  • Insert Page Header/Footer Data
  • Add Borders, Boxes, and Lines
  • Change Field Background Color
  • Change the Margins
  • Module 6
    Enhancing Reports
    Topics covered
  • Add a Watermark
  • Insert Objects Using Object Linking and Embedding
  • Modify Formatting Based on Data Value
  • Suppress Report Sections
  • Insert Hyperlinks
  • Hide Blank Report Sections
  • Module 7
    Creating Pie Charts
    Topics covered
  • Create a Pie Chart with a Drill-Down
  • Modify Chart Text
  • Format a Chart
  • Present a Chart by Group
  • Module 8
    Distributing Data
    Topics covered
  • Export to a PDF File
  • Export to a Microsoft Excel File
  • Export to an Access Database File
  • Export a Report Definition
  • Create Mailing Labels

  • Activia Training :   Training courses for business at twelve locations UK wide