Crystal Reports 9.0 Level 1

« back to previous page

Description:	This course covers learning how to obtain output from databases. The student will build basic list and group reports that work with almost any database.
Prerequisites:	Exposure to a Windows operating system would be helpful and a basic understanding of database concepts is necessary.
Length:	Two days

Creating a List Report
• Set Default Report Settings
• Build the Report
• Preview the Report
• Add a Report Title
• Align Fields

Displaying Data in a Report
• Find Data
• Sort Data
• Filter Data by Single Criteria

Grouping Report Data
• Insert a Group
• Add Summaries
• Change Group Options
• Add an Additional Group
• Format a Group Header
• Filter by Group
• Create a Top N Sort Group

Building Formulas
• Write a Formula
• Edit a Formula
• Group by Formula
• Delete a Formula
• Build a Filter by Multiple Criteria
• Modify a Filter with Multiple Criteria to Create an OR Condition
• Create a Parameter Field
• Write a Formula that Incorporates Null Fields

Formatting Reports
• Remove White Space
• Insert Page Header/Footer Data
• Add Borders and Lines
• Change the Background Color
• Change the Margins

Enhancing Reports
• Create a Watermark
• Add Bulleted Lists
• Modify Format Based on Data Value
• Conditionally Suppress Data
• Insert Hyperlinks
• Hide Report Objects

Creating and Modifying Pie Charts
• Create a Pie Chart with a Drill-down
• Change the Chart Title
• Format a Chart
• Present a Chart by Group

Distributing Data
• Export to Excel
• Export to an Access Database
• Create a Report Definition
• Create Mailing Labels