Crystal Reports 9 Advanced

2 days

p>Overview

Students will learn to create complex reports and data sources using Crystal's tools.

Prerequisites

Students should have attended Crystal Reports 9 Introduction and also have a minimum of three months hands-on experience using Crystal Reports in a working environment.

Benefits

Students will learn how to create more sophisticated reports like subreports and cross-tabs. They will also learn how to increase the speed and efficiency of reports by using SQL queries and dictionaries.

Target student

Users 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.

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
Edit 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