Crystal Reports 2008 - Level 2

Course details

In this course, students create complex reports and data sources using Crystal Reports' tools. They will also increase the speed and efficiency of their reports by using SQL queries.

Course Outline

1 - Creating Running Totals

• Create a Running Total Field
• Modify a Running Total Field
• Create a Manual Running Total

2 - Working with Cross-Tabs

• Create a Cross-Tab Report
• Format a Cross-Tab Report
• Create Groups in Cross-Tab Reports

3 - Adding Subreports

• Insert a Subreport
• Edit a Subreport
• Share Variables

4 - Creating Drill-Downs in a Report

• Create a Drill-Down
• Create Headings for Drill-Down Data

5 - Using SQL Statements in Report Processing

• Create a Report Using SQL Queries
• Summarize Report Data
• Create Joins Using SQL
• Create Subqueries
• Create a SQL Expression Field

6 - Creating Complex Formulas

• Work with Loops
• Work with Arrays

7 - Adding Charts to Reports

• Create Charts
• Create a Chart with a Drill-Down
• Create a Top N Chart
• Create a Cross-Tab Chart
• Create Charts for Grouped Data
• Format a Chart
• Create a Chart Template

8 - Enhancing Report Functionality

• Organize Data Based on a Hierarchy
• Create a Dynamic Image
• Create a Report Alert
• Create a Geographic Map