Crystal Reports 8

This series introduces users to Crystal Reports 8, a popular database reporting program. In this series, you will learn how to create standard and custom reports. You will also learn how to filter, summarize, sort, group, and manipulate data by inserting formulas and functions.

Syllabus

GETTING STARTED

Shows users how to create and save a standard report in Crystal Reports 8.

• Creating a Standard Report
• Preview and Design Modes
• Working with Fields
• Saving and Closing Reports

DESIGNING A REPORT

Shows users how to create a custom report in Crystal Reports 8 and customize it by inserting special fields and changing object properties.

• Inserting Fields
• Inserting and Using Special Fields
• Using Guidelines
• Changing Text Object Properties
• Changing Date Object Properties

SELECTING RECORDS

Shows the user how to filter data in Crystal Reports 8 using compound filters, date searches and wildcards.

• Setting Up a Selection Formula
• Using Compound Filters
• Selecting Dates
• Using the OR Connector and Wildcards

SORTING AND GROUPING DATA

Shows users how to sort and group data in Crystal Reports 8.

• Sorting Data
• Grouping Data
• Modifying a Group
• Managing Groups

CREATING SUMMARY TOTALS, REPORTS AND GRAPHS

Shows users how to summarize data using totals, reports, and graphs in Crystal Reports 8.

• Creating Grand Totals
• Creating Summary Totals
• Creating Summary Reports
• Producing Summary Graphs
• Editing and Formatting Summary Graphs

FORMULAS AND FUNCTIONS

Shows users how to insert and use formulas and functions in Crystal Reports 8.

• Inserting Formula Fields
• Using Conditional Formatting and Selection Formulas
• Using Functions
• Using IF Statements
• Nested and Conditional IF Statements

PRINTING AND EXPORTING REPORTS

Shows users how to print reports from Crystal Reports 8 and how to export report data to Microsoft Excel and Word formats.

• Printing a Report
• Exporting to Word
• Exporting to Excel
• Creating a Report from a Spreadsheet

LINKING TABLES

Shows users how to use Crystal Reports 8 to link data tables together and create mailing labels.

• Using Tables
• Accessing Data Directly
• Using the Visual Linking Expert
• Creating Mailing Labels

Qualifications

Qualification: Printable Transcript

On completion of this course you may print a transcript off as evidence of your progression throughout the course.

Requirements for Entry

There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.

Study Options

If you do not have Internet access, or would prefer to study this course via the traditional paper/postal based study method, you can find more information on the course by clicking on the link below.

Study Hours

This is only an approximate figure and is dependant upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material. Furthermore, at the end of each lesson there is a question paper that needs to be completed and returned to your tutor. You should allow at least 1 - 2 hours of study to complete each question paper.

The approximate amount of time required to complete the course is: 40 hrs.