Crystal Reports V11 Advanced

Prerequisites: Delegates must have attended Crystal Reports 11: Introduction course or have working knowledge of the subjects
Duration: 2 Day
Course Outline

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 a Cross-tab by Group
• Change the Cross-tab Format
• Conditionally Format Rows and Columns
• Keep Groups Together

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

Creating Drill-downs
• Create a Drill-down
• Create Separate Headings for Drill-down Data

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

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

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

Working with Prompts
• Create a Static Prompt
• Create a Dynamic Prompt

Enhancing Report Functionality
• Group Data Hierarchically
• Create a Dynamic Image
• Create a Report Alert
• Create a Geographic Map
•