Crystal Reports -Intermediate – Level 2

• 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

• 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

• 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

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

• 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

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

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