Class overview :

Class goals :

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

Content of Crystal Reports Version 11 Introduction

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
• 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

Formatting Reports

• Remove White Space
• Insert Page Header/Footer Data
• Add Borders, Boxes, and Lines
• Change Field Background Color
• Change the Margins

Enhancing Reports

• 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

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 Microsoft Excel File
• Export to an Microsoft Access Database File
• Create a Report Definition
• Create Mailing Labels