Advanced Crystal Reports 2008 Training (2 days)

Advanced Crystal Reports Training Course Overview

This Crystal Reports training course, students will learn to use Crystal Reports to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. Students will also learn to build tools to make it easier for other people to create reports.

Advanced Crystal Reports Training Course Goals

• Learn to create automatic and manual running totals.
• Learn to work with cross-tab reports.
• Learn to add subreports.
• Learn to create drill-downs in a report.
• Learn to use SQL statements in report processing.
• Learn to create complex formulas.
• Learn to add charts to reports.
• Learn to enhance report functionality.

Advanced Crystal Reports Training Course Prerequisites

Experience in the following areas is required:

• Basic Crystal Reports experience

Advanced Crystal Reports Training Course Outline

1. Creating Running Totals
   1. Create a Running Total Field
   2. Modify a Running Total Field
   3. Create a Manual Running Total
2. Working with Cross-Tabs
   1. Create a Cross-Tab Report
   2. Format a Cross-Tab Report
   3. Create Groups in Cross-Tab Reports
3. Adding Subreports
   1. Insert a Subreport
   2. Edit a Subreport
   3. Share Variables
4. Creating Drill-Downs in a Report
   1. Create a Drill-Down
   2. Create Headings for Drill-Down Data
5. Using SQL Statements in Report Processing
   1. Create a Report Using SQL Queries
   2. Summarize Report Data
   3. Create Joins Using SQL
   4. Create Subqueries
   5. Create a SQL Expression Field
6. Creating Complex Formulas
   1. Work with Loops
   2. Work with Arrays
7. Adding Charts to Reports
   1. Create Charts
   2. Create a Chart with a Drill-Down
   3. Create a Top N Chart
   4. Create a Cross-Tab Chart
   5. Create Charts for Grouped Data
   6. Format a Chart
   7. Create a Chart Template
8. Enhancing Report Functionality
   1. Organize Data Based on a Hierarchy
   2. Create a Dynamic Image
   3. Create a Report Alert
   4. Create a Geographic Map

Advanced Crystal Reports Training Course Materials

In addition to a comprehensive set of materials, including course notes and all the programming examples, each student will also receive a one-year subscription to Webucator's online reference library, which contains hundreds of the most current electronic technology books - a $149.95 per student value.

Advanced Crystal Reports Training Course Technical Requirements and Setup Instructions

Click here for technical requirements and setup instructions