Crystal Reports 2008: Level 1

2 days

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.

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