2 Day Course

Performance-based objectives

• 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.

Prerequisites

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. Crystal Reports XI: Level 1, and knowledge of programming and/or SQL would be helpful.

Course content

Lesson 1: Creating Running Totals

• A: Create a Running Total Field
• B: Modify a Running Total Field
• C: Create a Running Total on Detail Data
• D: Create a Running Total on Summary Data

Lesson 2: Building Cross-tabs in Your Report

• A: Create a Cross-tab
• B: Create a Specified Group Order
• C: Filter a Cross-tab by Group
• D: Change the Cross-tab Format
• E: Conditionally Format Rows and Columns
• F: Keep Groups Together

Lesson 3: Adding Subreports

• A: Insert a Subreport
• B: Link a Subreport to a Primary Report
• C: Edit a Subreport's Structure
• D: Format a Subreport Using the Format Editor
• E: Share Variables Between Subreports and Primary Reports
• F: Create an On-demand Subreport

Lesson 4: Creating Running Totals

• A: Create a Drill-down
• B: Create Separate Headings for Drill-down Data

Lesson 5: Enhancing Report Processing

• A: Create a Report Using SQL Queries
• B: Report Data Using SQL Aggregate Functions
• C: Create Joins Using SQL
• D: Create Subqueries
• E: Create a SQL Expression Field

Lesson 6: Charting Data

• A: Create a Bar Chart
• B: Modify a Chart
• C: Format a Chart
• D: Create a Chart Template
• E: Create a Top N Chart
• F: Create a Cross-tab Chart

Lesson 7: Reporting on Excel Data with Crystal Reports

• A: Create a Report Based on Excel Data
• B: Modify a Report Generated from Excel Data
• C: Update Data in a Based on Excel Data

Lesson 8: Working with Prompts

• A: Create a Static Prompt
• B: Create a Dynamic Prompt

Lesson 9: Enhancing Report Functionality

• A: Group Data Hierarchically
• B: Create a Dynamic Image
• C: Create a Report Alert
• D: Create a Geographic Map

For more information on Acumen Classes
Please contact Joann Etling 314.333.3330
or This e-mail address is being protected from spambots. You need JavaScript enabled to view it

1750 South Brentwood Blvd.
Suite 200
Saint Louis, MO 63144