Crystal Reports 9 Advanced

Course Description
Course Outline

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.

We offer a range of Crystal Reports training courses

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

Publisher:	Business Objects
Version:	9
Length:	2 Days
Course-ID:	084414

	Printer Friendly Version
	Download Outline As PDF

Related Courses

Trainer was patient and attentive - just what we needed... fantastic

- Hewlett Packard