This course introduces users to Crystal Reports, a popular database reporting program. You will learn how to create standard and custom reports. You will also learn how to filter, summarize, sort, group, and manipulate data by inserting formulas and functions.

Objective

After completing this course, the student should be able to:
• Plan the needs for your report including data as well as appearance
• Become familiar with components of the Crystal Reports application window
• Create reports based directly on database information, use a report expert or create a copy of an existing report
• Add, modify and remove report objects such as data fields, text objects, file information, graphics or decorative lines and boxes
• Format the appearance of your report using font, color, border and number choices
• Change the selection criteria and sort order of your data
• Create subtotals, grand totals and summaries for your report data
• Create, edit and delete formulas using Crystal's formula language
• Identify and control Crystal's report sections
• Distribute your reports to those who need the information through a variety of methods

Audience

This course is valuable for anyone involved in creating reports from stored data.

Minimum Prerequisites

Experience using Windows and working with a spreadsheet or word processor is assumed. A basic knowledge of relational data concepts is also recommended.

Included Labs

Labs to be provided by the trainer

What will you learn?

• Introduction to Crystal Reports
• Creating Simple Reports
• Sorting and Selecting Records
• Grouping and Summarizing
• Understand Parameter fields
• Using the Report Expert
• Creating Formulas
• Formatting Sections
• Linking Multiple Tables
• Distributing Reports