Crystal Reports -Intermediate – Level 2

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.


Area of Learning — Crystal Reports -Intermediate – Level 2

Course Outline

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.

Now is the time to get qualified.

Discover our areas of learning.

Forsythes Training is an established, trusted, quality training provider with an extensive list of corporate clients and individuals who have attended our training courses over the last twenty years in a variety of learning areas: