Crystal Reports 10 Power User

Two day training course

Course code: PRICR10L3

Now that you have completed the first course, or are familiar with the basics of building and modifying reports, you're ready to move ahead to create complex reports and data sources using Crystal Reports' tools. In this course, you'll not only learn how to create more sophisticated reports including subreports and cross-tabs, but you'll also learn how to increase the speed and efficiency of your reports by using SQL queries and dictionaries.

Target Audience/Pre-Requisites

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.


Course Objectives

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

Course Content

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

Build cross-tabs in your report

Create a cross-tab • Create a specified group order • Filter a cross-tab by group • Change cross-tab by group • Change the cross-tab format • Conditionally 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 using the format editor • Share formulas between main and subreports • Create an on-demand report

Creating drill-downs

Create a drill-down • Create a separate heading for drill-down data

Enhancing report processing using SQL

Create a report using SQL queries • Summarise report data using SQL aggregate function • Create joins using SQL • Create subqueries • SQL expressions to promote server side processing

Charting data

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

Reporting on Excel data

Create a report based on Excel data • Modify a report based on Excel data • Update data in a report based on Excel data

Related Courses
Course Scheduled Dates

Sorry, we are not arranging any scheduled public courses for this course.

Perhaps you may like to organise a private training session. Please feel free to contact us. One of our training consultants would be pleased to discuss the best options available for you.

Alternatively, why not design your own course? Our Customised Course Builder will allow you to select the modules appropriate for your particular training needs.


Send this course to a friend
 
Course Fee / Saving Plans

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

Build your own course

Personal Details

Name
Company
Phone
Email
Address
Contact Preference Phone Email Mail
 

Please Enter The number above before submitting

(Note: 3 Units Minimum)
Total Units:
Pre Course Assessment Tool

Personal Details

Name
Company
Phone
Email
Address
Contact Preference Phone Email Mail
 

You will not be able to submit your assessment until you have completed the personal details section and selected the appropriate Knowledge Level for EVERY topic in the above list."
Request more information

Please fill out the form below for more details:

Last Name
Job Title
Company
Office Telephone
E-mail
Brief Details

 

To Print Course Details Click Here