Crystal Reports - Introduction

By the end of this 2 day course delegates will be able to:

• Create and work with reports
• Display, find, sort and filter data
• Work with groups
• Build, write and edit formulas
• Work with filters
• Understand formatting
• Enhance reports
• Create charts
• Distribute reports

None - you will require a PC with a version of Crystal pre-loaded for each delegate.

Day 1 -

Reports:

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

Data:

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

Groups:

• 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

Formulas:

• Building Formulas
• Write a Formula
• Edit a Formula
• Group by Formula
• Delete a Formula

Filters:

• Build a Filter by Multiple Criteria
• Modify a Filter with Multiple Criteria to Create an OR Condition Day 2

Day 2 -

Formatting:

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

Enhanced Reports:

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

Charts:

• 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

Report Ditribution:

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

This course is available as an inhouse course tailored to your organisational aims and objectives, please contact us to discuss your requirements and delegate numbers. (pricing can vary dependant on the size of group)

All prices are excluding VAT, travel is charged with In-house courses at 40p per mile from our head office
Accommodation is required for distances over 100 miles from our head office.