Crystal Reports 9: Report Design II UK Classes & Lessons (Business Objects)

Home - FAQ - Corporate Plans

About this class

The object of this course is to teach delegates to use the full power and functionality of Crystal Reports.

Who will the lesson benefit?

Information professionals or 'power users' who want to investigate the full power and functionality of Crystal Reports.

What delegates will learn

This course will enable delegates to:

Create running totals in a report.
Build CrossTab reports.
Add sub reports.
Improve processing speed in reports.
Build a dictionary.
Chart single and multiple data series.

Contents of this class

Creating Running Totals

Creating a Running Total Field.
Editing the Running Total Field.
Creating a Manual Running Total on Detail Data.
Creating a Manual Running Total on Summary Data.

Building CrossTabs in your Report

Create a CrossTab.
Create a specified group order.
Filter CrossTab by group.
Change the CrossTab format.

Adding Subreports

Insert a Subreport.
Link a Subreport in a primary report.
Edit a Subreport.
Format a Subreport object.
Share formula between Main and Subreports.
Create and on-demand Subreport.

Improving Report Processing Speed

Create an SQL Expression.
Select Records on the Server.
Write and Edit an SQL query.
Build a Report on your SQL query.
Create SQL commands in the Crystal Report Environment.

Building Dictionaries

Create a Dictionary.
Organise the view of data in a Dictionary.
Adding Graphics to a Dictionary.
Building 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.

Reporting on Excel Data

Create a Report.
Modify a Report.
Update the Report.

Creating Running Totals

Creating a Running Total Field.
Editing the Running Total Field.
Creating a Manual Running Total on Detail Data.
Creating a Manual Running Total on Summary Data.

Building CrossTabs in your Report

Create a CrossTab.
Create a specified group order.
Filter CrossTab by group.
Change the CrossTab format.

Adding Subreports

Insert a Subreport.
Link a Subreport in a primary report.
Edit a Subreport.
Format a Subreport object.
Share formula between Main and Subreports.
Create and on-demand Subreport.

Improving Report Processing Speed

Create an SQL Expression.
Select Records on the Server.
Write and Edit an SQL query.
Build a Report on your SQL query.
Create SQL commands in the Crystal Report Environment.

Building Dictionaries

Create a Dictionary.
Organise the view of data in a Dictionary.
Adding Graphics to a Dictionary.
Building 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.

Reporting on Excel Data

Create a Report.
Modify a Report.
Update the Report.