Crystal Reports 10: Advanced

Course Specifications:

Courseware: Crystal Reports 10.0: Level 2

Software: Crystal Reports 10

Course length: 2 days

Course times: 8:30 a.m. - 4:30 p.m.

Course Description:

In this course, you will not only learn how to create more sophisticated reports like subreports and cross-tabs, you will also learn how to increase the speed and efficiency of your reports by using SQL queries and dictionaries.

Course Objective:

You will create complex reports and data sources using Crystal Reports tools.

Target Student:

This course is designed for people 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.

Prerequisites:

To ensure the successful completion of Crystal Reports 10: Advanced, we recommend completion of the following MicroAssist courses, or equivalent knowledge from another source:

Delivery Method:

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities. Each student is provided with a computer and a Training Manual. The manual is the student's to keep and makes an excellent reference guide.

Course Content:

Lesson 1: Creating Running Totals

1. Topic 1A: Create a Running Total Field
2. Topic 1B: Modify a Running Total Field
3. Topic 1C: Create a Manual Running Total on Detail Data
4. Topic 1D: Create a Manual Running Total on Summary Data

Lesson 2: Building Cross-tabs in Your Report

1. Topic 2A: Create a Cross-tab
2. Topic 2B: Create a Specified Group Order
3. Topic 2C: Filter a Cross-tab by Group
4. Topic 2D: Change the Cross-tab Format
5. Topic 2E: Conditionally Format Rows and Columns
6. Topic 2F: Keep Groups Together

Lesson 3: Adding Subreports

1. Topic 3A: Insert a Subreport
2. Topic 3B: Link a Subreport to Data in a Primary Report
3. Topic 3C: Edit a Subreport
4. Topic 3D: Format a Subreport Using the Format Editor
5. Topic 3E: Share Formulas Between Main and Subreports
6. Topic 3F: Create an On-demand Subreport

Lesson 4: Creating Drill-downs

1. Topic 4A: Create a Drill-down
2. Topic 4B: Create Separate Headings for Drill-down Data

Lesson 5: Enhancing Report Processing Using SQL

1. Topic 5A: Create a Report Using SQL Queries
2. Topic 5B: Summarize Report Data Using SQL Aggregate Functions
3. Topic 5C: Create Joins Using SQL
4. Topic 5D: Create Subqueries
5. Topic 5E: Create an SQL Expression Field to Promote Server-side Processing

Lesson 6: Charting Data

1. Topic 6A: Create a Bar Chart
2. Topic 6B: Modify a Chart
3. Topic 6C: Create a Top N Chart
4. Topic 6D: Format a Chart
5. Topic 6E: Create a Chart Template

Lesson 7: Reporting on Excel Data

1. Topic 7A: Create a Report Based on Excel Data
2. Topic 7B: Modify a Report Generated from Excel Data
3. Topic 7C: Update Data in a Report Based on Excel Data