Crystal Reports XI: Basic Skills Training Class

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.                 

Lesson 1: Creating a Report

Set Default Report Settings

Specify Fields for a New Report

Preview a Report

Modify Field Display

Add a Report Title

Position Fields

Add Fields from Other Tables

Lesson 2: Displaying Specific Report Data

Find Data

Sort Data

Filter Data by a Single Criterion

Lesson 3: Grouping Report Data

Insert a Group

Add Summaries

Format Summary Information

Change Group Options

Add a Second-Level Grouping

Filter Records by Group

Create a Top N Sort Group

Lesson 4: Building Formulas

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

Lesson 5: Formatting Reports

Remove White Space

Tnsert Page Header/Footer Data

Add Borders, Boxes, and Lines

Change Field Background Color

Change the Margins

Lesson 6: 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

Lesson 7: Creating Pie Charts

Create a Pie Chart with a Drill-Down

Modify Chart Text

Format a Chart

Present a Chart by Group

Lesson 8: Distributing Data

Export to a PDF File

Export to a Microsoft Excel File

Export to an Access Database File

Export a Report Definition

Create Mailing Labels