Crystal Reports 2008 Level 1

2 days

Course Overview

Organizations use reporting tools to access data sources and generate customized reports. Crystal ReportsĀ® 2008 enhances report building and report processing techniques with a slew of features that add value to your presentation. In this course, you will create a basic report by connecting to a database and modifying its presentation.

Course Objective

You will connect to a database to extract data and present it as a report.

Target student

This course is designed for persons who need output from a database. In some cases, database programs have limited reporting tools, and/or such tools may not be accessible. Students may or may not have programming and/or SQL experience.

Prerequisites

Before taking this course, students should be familiar with the basic functions of their computer’s operating system such as creating folders, opening programs, and working with windows. Students should have basic Windows application skills, such as copying and pasting objects, formatting text, saving files, etc. Students should have a basic understanding of database concepts.

Course Outline

Exploring the Crystal Reports 2008 Interface

  • Explore the Crystal Reports Interface
  • Use the Crystal Reports Help
  • Customize the Report Settings

Working with Reports

  • Create a Report
  • Modify a Report
  • Display Specific Report Data
  • Work with Report Sections

Using Formulas in Reports

  • Create a Formula
  • Edit a Formula
  • Filter Data Using a Formula
  • Work with Advanced Formulas and Functions
  • Handle Null Values

Building Parameterized Reports

  • Create a Parameter Field
  • Use a Range Parameter in a Report
  • Create a Prompt

Grouping Report Data

  • Group Report Data
  • Modify a Group Report
  • Group Using Parameters
  • Create a Parameterized Top N Report

Enhancing a Report

  • Format a Report
  • Insert Objects in a Report
  • Suppress Report Sections
  • Use Report Templates

Creating a Report from Excel Data

  • Create a Report Based on Excel Data
  • Modify a Report Generated from Excel Data
  • Update Data in a Report Based on Excel Data

Distributing Data

  • Export Data
  • Creating Mailing Labels