Crystal Reports Version 9 Advanced — A 2-Day Course

 Open Public Course Closed In-House Course

Course Synopsis

In this course, you'll use Crystal Reports 9.0 to create more sophisticated reports like subreports and cross-tabs, you'll also learn how to increase the speed and efficiency of your reports by using SQL queries and dictionaries.

Course Objectives

After completing this course, students should be able to:

• Create running totals in a report
• Build cross-tabs in your report
• Add subreports to a report
• Rove processing speed in your reports
• Build a dictionary
• Chart single and multiple data series
• Report from Excel data

Course Prerequisites

Before attending this course, students should have:

• Completed Crystal Reports 9.0 Level 1
• Ideally some knowledge of programming and/or SQL

Outline Course Contents

Creating a Report

• Set Default Report Settings
• Specify Fields for a New Report
• Preview the Report
• Modify Field Display
• Add a Report Title
• Position Fields
• Add Fields from Additional Tables

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 a SQL Expression
• Select Records on the Server
• Write a SQL Query
• Edit a SQL Query
• Build a Report on a SQL Query
• Create SQL Commands in the Crystal Report Environment

Building Dictionaries

• Create a Dictionary
• Organize 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

Reporting on Excel Data

• Create a Report
• Modify a Report
• Update the Report