Crystal Reports 9: Report Design II

To teach delegates to use the full power and functionality of Crystal Reports.

Audience

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

Skills Gained

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.

Course Outline

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.