Crystal Reports V11 Introduction

Prerequisites: Delegates must be proficient in the use of a personal computer running the Microsoft Windows environment. Prior knowledge of working with databases, such as Microsoft Access is also essential.
Duration: 2 Day
Course Outline

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

Displaying Specific Report Data
• Find Data
• Sort Data
• Filter Data by Single Criteria

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 Colour
• 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
• Create Mailing Labels