Crystal Reports -Intermediate – Level 2

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 Data in a Primary Report
• Edit a Subreport
• Format a Subreport Using the Format Editor
• Share Formulas Between Main and Subreports
• 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 Using SQL

• Create a Report Using SQL Queries
• Summarise Report Data Using SQL Aggregate Functions
• Create Joins Using SQL
• Create Subqueries
• Create an SQL Expression Field to Promote Server-side Processing

Lesson 6: Charting Data

• Create a Bar Chart
• Modify a Chart
• Create a Top N Chart
• Format a Chart
• Create a Chart Template

Lesson 7: Reporting on Excel Data

• Create a Report Based on Excel Data
• Modify a Report Generated from Excel Data
• Update Data in a Report Based on Excel Data

Forsythes Training provides instructor led computer training on the Microsoft Office and Adobe range of applications. We service Sydney, Newcastle, the Hunter Valley, Lake Macquarie, Central and Northern Coasts of New South Wales (NSW) Australia.With our mobile training room we can provide a range of courses on-site at your premises.

Learning Outcomes