Crystal Reports 9.0 Foundation

Target Audience

This course is designed for delegates who need output from a database. In some cases, database programs have limited reporting tools, and/or they may not have access to those tools. Delegates may or may not have programming and/or SQL experience.

Pre-requisites

Before attending this course, delegates should be familiar with the basic functions of Windows, such as creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files. In addition, delegates should have attended the Access Creating Database course or have equivalent experience with basic database concepts.

On completion of this course, delegates will be able to:

• Create a report by using data from an existing database
• Locate and present data in a specified order
• Create groups to summarize report data
• Build formulas to add non-database data to report and display data differently
• Format reports
• Enhance reports by adding and modifying elements in a report
• Create single data series charts
• Distribute report data to other users

Create 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 reports

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 and create an OR condition • Create a parameter field • Write a formula that incorportaes Null fields

Formatting reports

Create a watermark • Add bulleted lists • Modify format based on data value • Conditionally suppress data • Insert hyperlinks • Hide report objects

Create and modify 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

You may also be interested in some of the following related courses below:

Crystal Reports - Crystal Reports 9.0 - Power User
Microsoft - Access 2002/3 - Creating Databases

Send this course to a friend
 

Course Fee

The advertised rates are on a per delegate basis, however if you have more than one attendee you may be entitled to a discount. To maximise your training budget why not email or contact one of our training consultants to see what rates/discounts may apply for your particular requirement.

Alternatively, if you have regular, ongoing training requirements, you may find one of our Training Passports of interest. Each is designed to provide our clients with significant benefits:
• Far better discounts
• Less administrative overhead
• Better control of your training schedules

Scheduled Training Passports
Enables you to pre-purchase training places on any of our standard scheduled courses.

Private Training Passports
Enables you to pre-purchase private training days against any of our standard courses.

Each of the above passports come with substantial discounts.

To maximise your training budget why not email or contact one of our training consultants who will be happy to provide you with the latest offers on any of our Training Passports. See what rates/discounts may apply for your particular requirement.

Passport Saving Plans

Please fill out the form below for more details:

First Name
Last Name
Job Title
Company
Office Telephone
E-mail
Brief Details	Characters Left.