Crystal Reports XI:  Advanced Skills

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. They may or may not have programming and/or SQL experience.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

• create running totals in a report.
• build cross-tabs in your report.
• add subreports to a report.
• design a report that uses a drill-down.
• improve processing speed in your reports.
• chart single and multiple data series.
• report from Excel data.
• implement report prompts.

• enhance report functionality.

Lesson 1: 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

Lesson 2: Building Cross-tabs in Your Report

Create a Cross-tab

Create a Specified Group Order

Filter a Cross-tab by Group

Change the Cross-tab Format

Conditionally Format Rows and Columns

Keep Groups Together

Lesson 3: Adding Subreports

Insert a Subreport

Link a Subreport to a Primary Report

Edit a Subreport's Structure

Format a Subreport Using the Format Editor

Share Variables Between Subreports and Primary Reports

Create an On-demand Subreport

Lesson 4: Creating Drill-downs

Create a Drill-down

Create Separate Headings for Drill-down Data

Lesson 5: Enhancing Report Processing by Writing SQL Statements

Create a Report Using SQL Queries

Summarize Report Data Using SQL Aggregate Functions

Create Joins Using SQL

Create Subqueries

Create a SQL Expression Field

Lesson 6: Charting Data

Create a Bar Chart

Modify a Chart

Format a Chart

Create a Chart Template

Create a Top N Chart

Create a Cross-tab Chart

Lesson 7: Reporting on Excel Data with Crystal Reports

Create a Report Based on Excel Data

Modify a Report Generated from Excel Data

Update Data in a Report Based on Excel Data

Lesson 8: Working with Prompts

Create a Static Prompt

Create a Dynamic Prompt

Lesson 9: Enhancing Report Functionality

Group Data Hierarchically

Create a Dynamic Image

Create a Report Alert

Create a Geographic Map