Computer Training

Crystal Reports - Introduction

Course Length: 2 Days

Course Prerequisites

  • Required: Knowledge of Windows Introduction topics and an understanding of database concepts.

Course Description

  • In this course, you will learn how to create reports from a database, such as Microsoft Access. Topics include: creating a list report, displaying data in a report, grouping report data, building formulas, formatting reports, enhancing reports, creating and modifying pie charts, and distributing data.

Detailed List of Topics

Creating a List Report

  • Set Default Report Settings
  • Build the Report
  • Preview the Report
  • Add a Report Title
  • Align Fields

Displaying Data in a Report

  • Find Data
  • Sort Data
  • Filter Data by Single Criteria

Grouping Report Data

  • Insert a Group
  • Add Summaries
  • Change Group Options
  • Add an Additional Group
  • Format a Group Header
  • Filter by Group
  • Create a Top N Sort Group

Building Formulas

  • Write a Formula
  • Edit a Formula
  • Group by Formula
  • Delete a Formula
  • Build a Filter by Multiple Criteria
  • Modify a Filter with to Create an OR Condition
  • Create a Parameter Field
  • Write a Formula that Incorporates Null Fields

Formatting Reports

  • Remove White Space
  • Insert Page Header/Footer Data
  • Add Borders and Lines
  • Change the Background Colour
  • Change the Margins

Enhancing Reports

  • Create a Watermark
  • Add Bulleted Lists
  • Modify Format Based on Date Value
  • Conditionally Suppress Data
  • Insert Hyperlinks
  • Hide Report Objects

Creating and Modifying Pie Charts

  • Create a Pie Chart with a Drill-down
  • Change the Chart Title
  • Format a Chart
  • Present a Chart by Group

Distributing Data

  • Export to Excel
  • Export to an Access Database
  • Create a Report Definition
  • Create Mailing Labels

back to top