Crystal Reports 11: Level 1
Class Outline:
Description:
This course teaches the basic features and functions of Crystal Reports XI. Students will explore the program environment and learn how to open, navigate, create, modify, and save reports. They will learn the fundamentals of formatting report objects, of sorting and selecting records, and creating groups and summaries. They will also learn how to create simple formulas and functions. Finally, students will work with experts and wizards, and learn how to export reports to various file formats.
Table of Contents:
Unit 1: Getting started
Topic A: The Crystal Reports environment
Topic B: Creating, viewing, and saving reports
Topic C: Modifying report layout
Topic D: The Help feature
Unit 2: Formatting
Topic A: Absolute formatting
Topic B: Introducing conditional formatting
Unit 3: Sorting and selecting records
Topic A: Sorting records
Topic B: Selecting records
Unit 4: Grouping and summarizing
Topic A: Groups
Topic B: Summaries
Unit 5: Formulas and functions
Topic A: Formulas
Topic B: Modifying formulas
Topic C: Functions
Unit 6: Experts and wizards
Topic A: The Database Expert
Topic B: Report wizards
Topic C: Cross-tab reports
Unit 7: Distributing reports
Topic A: Exporting reports
Topic B: Delivering reports
Objectives:
Explore the Crystal Reports window; open, create, save, and modify simple reports; and use Help.
Format a report by changing font style, size, and color; add lines, boxes, and shapes; and format fields conditionally.
Sort records in ascending and descending order; select records based on single or multiple criteria, and delete criteria from a selection formula.
Learn to create groups and subgroups, delete groups, group data by a date field, display groups in a specified order, create a subgroup, set group options, insert subtotals and grand totals, and display the top number of groups of records.
Create, modify, and delete formulas; insert date functions; concatenate fields; and use string and mathematical functions.
Use the Database Expert and Report wizards, and create, modify, and format cross-tab reports.
Export reports to different formats such as Excel, Access, HTML, and XML; create a report definition; and print and e-mail reports.