Crystal Reports XI - Level 1

Course details

In this course, students will build basic list and group reports that work with almost any database.

Course Outline

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

2 - Displaying Specific Report Data

• Find Data
• Sort Data
• Filter Data by a Single Criterion

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

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

5 - Formatting Reports

• Remove White Space
• Insert Page Header/Footer Data
• Add Borders, Boxes, and Lines
• Change Field Background Color
• Change the Margins

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

7 - Creating Pie Charts

• Create a Pie Chart with a Drill-Down
• Modify Chart Text
• Format a Chart
• Present a Chart by Group

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

Target Audience: This course is designed for a person who needs output from a database. In some cases, database programs have limited reporting tools, and/or they may not have access to those tools. Students may or may not have programming and/or SQL experience.