Crystal Reports -Intermediate – Level 2

Online Booking Request

Dates for next course: Call 02 4058 2869 for the next course date
Training Location: 9 Denison St, Newcastle West
Training Format: Workshop/Classroom
Duration: 1 Day
Course Fee: $720.00

In this course, students will learn how to create more sophisticated reports like subreports and cross-tabs. Also, they learn how to increase the speed and efficiency of their reports by using SQL queries and dictionaries.


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