Crystal Reports Version 10 Introduction — A 2-Day Course

 Open Public Course Closed In-House Course

Course Synopsis

Crystal Reports 10 Level 1 is the first course in the Crystal Reports 10 series. In this course, you will build basic list and group reports that work with almost any database.

Course Objectives

After completing this course, students should be able to:

• Create a list report by using data from an existing database
• Locate and present data in a specified order
• Create groups to summarize report data
• Build formulas to add non-database data to a report and display data differently
• Format reports
• Enhance reports by adding and modifying elements in a report
• Create single data series charts
• Distribute report data to other users

Intended Audience

This is the primary recommended course you should take if your job responsibilities require you to obtain output from databases.

Course Prerequisites

Before attending this course, students should have:

• Exposure to a Windows operating system - students should be familiar with the basic functions such as creating folders, opening programs, and working with windows.
• Basic Windows application skills, such as copying and pasting objects, formatting text, saving files, etc.
• A basic understanding of database concepts is necessary

Publicly scheduled dates, locations, and prices

Outline Course Contents

Creating a Report

• Set Default Report Settings
• Specify Fields for a New Report
• Preview the Report
• Modify Field Display
• Add a Report Title
• Position Fields
• Add Fields from Additional Tables

Displaying Specific Report Data

• Find Data
• Sort Data
• Filter Data by Single Criterion

Grouping Report Data

• Insert a Group
• Add Summaries
• Format Summary Information
• Change Group Options
• Add an Additional Group
• 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 Multiple Criteria 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 Color
• Change the Margins

Enhancing Reports

• Create a Section to Contain a Watermark
• Insert Objects Using Object Linking and Embedding
• Modify Format Based on Data Value
• Conditionally Suppress Data
• Insert Hyperlinks
• Hide Blank Report Sections

Creating and Modifying Pie Charts

• Create a Pie Chart with a Drill-down
• Modify Chart Text
• Format a Chart
• Present a Chart by Group

Distributing Data

• Export to PDF
• Export to Excel
• Export to an Access Database
• Create a Report Definition