Crystal Reports 9.0: Level 2

Course Description

Welcome back to Crystal Reports 9.0. Since you`ve probably completed the first course, or are familiar with the basics of building and modifying reports, you`re ready to move ahead to create complex reports and data sources using Crystal`s tools. In this course, you`ll not only learn how 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. <BR> <BR> <a href='http://www.professional.ie/it_training/crystalreports_and_brio.htm'> View other Crystal Reports Courses available</a> <BR>
2 Days
Contact us for pricing
 

Prerequisites

Crystal Reports 9.0: Level 1, and knowledge of programming and/or SQL would be helpful

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
CrystalCrystal ReportsSAP Crystal Reports