Crystal Reports: Level I

---

Overview

Our Level I Crystal Reports class is designed to provide you with the fundamental principles needed to transform your data into powerful Crystal reports. In this course you will learn to create reports that filter data and include formulas and summary statistics. You will also learn how to connect to your data and understand your database sources.

---

Audience

This course is designed for report designers, new to Crystal Reports, who are responsible for creating reports.

---

Duration

2 days

---

Proposed Syllabus

Planning a Report

• Define database concepts
• Plan and develop a report prototype

Creating a Report

• Create a report
• Add tables
• Describe the design environment
• Insert objects on a report
• Preview a report
• Save a report
• Position and size objects
• Format objects

Selecting Records

• Define the Select Expert
• Determine the criteria for record selection
• Understanding saved and refreshed data
• Apply record selection
• Apply additional record selection criteria
• Modify record selection
• Apply additional record selection criteria

Organizing Data on a Report

• Sort records
• Group records
• Summarize data

Formatting a Report

• Add graphical elements
• Combine text objects with database fields
• Apply specialized formatting

Applying Section Formatting

• Format sections
• Create a summary report

Creating Basic Formulas

• Define a formula and its purpose
• Create formulas
• Apply Boolean formulas
• Apply If-Then-Else formulas
• Apply date calculations
• Apply number calculations
• Apply string manipulation

Applying Conditional Reporting

• Determine trends in data
• Format data conditionally

Representing Data Visually

• Create a chart

Sharing a Report