Crystal Reports 9.0 Power User

Target Audience

This course is designed for delegates who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools to make it easier for other people to create reports. They may or may not have programming and/or SQL experience.

Pre-requisites

Crystal Reports Foundation and knowledge of programming and/or SQL would be helpful.

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

• Create running totals in a report
• Build cross-tabs in your report
• Add subreports to a report
• Design a report that uses a drill-down
• Improve processing speed in your reports
• Chart single and multiple data series
• Report from Excel data

Creating running totals

Create a running total field • Modify a running total field • Create a manual running total on detail data • Create a manual running total on summary data

Building cross-tabs in your report

Create a cross-tab • Create a specified group order • Filter cross-tab by group • Change the cross-tab format • Format rows and columns • Keep groups together

Adding subreports

Insert a subreport • Link a subreport to data in a primary report • Edit a subreport • Format a subreport object • Share formulas between main and subreports • Create an on-demand subreport

Improving report processing speed

Create an SQL expression • Select records on the server • Write an SQL query • Edit an SQL query • Build a report on an SQL query • SQL commands in the Crystal Reports environment

Building dictionaries

Create a dictionary • Organise the view of data in a dictionary • Adding graphics to the dictionary • Build a report based on a dictionary

Charting data

Create a chart • Modify a chart • Create a top N chart • Format a chart • Create a chart template

Repoting on Excel data

Create a report • Modify a report • Update the report

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

Crystal Reports - Crystal Reports 9.0 - Foundation
Microsoft - Access 2002/3 - Power User
Microsoft - Access 2002/3 - VBA

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.