Crystal Reports training
at your office.

Learn from professionals in instructor‑led training.

Crystal Reports is a program designed for one purpose only - to create reports from nearly any raw data source (ODBC, SQL, Access, etc). If your company has data, especially data that is linked to multiple sources, Crystal Reports can bring that data together to build professional looking reports with formulas, filters, user‑prompts, and automation using the Crystal Reports language.

Our comprehensive two-day courses in Crystal Reports are delivered by our highly experienced instructors throughout Southern Ontario and the GTA. Choose from two standard courses, or build your own course to meet your specific needs.

Crystal Reports training at your office.

Learn from professionals in instructor‑led training.

We travel to you.

Training delivered right to your office on a day that works best for your team.

Hands-on experience.

Professional instruction, lots of practise time, and solutions for your Crystal Reports concerns.

No computers? No problem.

If you're short on computers, we will gladly supply a laptop for each person.

Everything you need to succeed.

We provide a free assessment to determine the right course content for your team.

Crystal Reports is a program designed for one purpose only - to create reports from nearly any raw data source (ODBC, SQL, Access, etc). If your company has data, especially data that is linked to multiple sources, Crystal Reports can bring that data together to build professional looking reports with formulas, filters, user‑prompts, and automation using the Crystal Reports language.

Our comprehensive two-day courses in Crystal Reports are delivered by our highly experienced instructors throughout Southern Ontario and the GTA. Choose from two standard courses, or build your own course to meet your specific needs.


Standard Crystal Reports Courses

2 days of training, reference manuals and 30 days of technical support: $ 325 / person / day

Minimum charge of 3 people. Discounts available for groups of 6 or more.

Level 1

Building Reports

Learn to work with different data sources to build and format reports with filters, parameters and automation.

Learn more ›

Level 2

More Complex Reports

Build on your knowledge by creating subreports, crosstabs, running totals, drill‑downs, charts/maps and more.

Learn more ›

Build your own custom course.

Have specific needs, or just want a more personalized experience? Simply send us your list of topics or we can work with you to create a full-day course. Mix‑and‑match beginner, and intermediate topics to ensure every person gains valuable knowledge.

Every "build your own course" includes a customized reference manual featuring your topics, and the same 30 days of technical support as our standard offerings.

    $ 350 / person

Minimum charge of 4 people. Discounts for groups of 6 or more.

$ 350 / person. Minimum charge of 4 people. Discounts for groups of 6 or more.

Level 1: Building Reports

2 days of training, reference manuals and 30 days of technical support: $ 325 / person / day (discounts available)

Using Crystal Reports, you can create sophisticated reports from almost any data source. This course gets you familiarized with the user interface and teaches you to create beautifully formatted reports that include formulas, parameters and grouping.

Course Prerequisites: knowledge of basic Windows use and an understanding of database concepts.

  

  • Creating a List Report

  • Set Default Report Settings
  • Build the Report
  • Preview the Report
  • Add a Report Title
  • Align Fields
  • Displaying Data in a Report

  • Find Data
  • Sort Data
  • Filter Data by Single Criteria
  • Grouping Report Data

  • Insert a Group
  • Add Summaries
  • Handle Page Breaks through Group Options
  • Change Group Options
  • Add an Additional Group
  • Format a Group Header
  • Filter by Group
  • Create a Top N Sort Group
  • Building Formulas

  • Write a Formula
  • Edit a Formula
  • Group by Formula
  • Delete a Formula
  • Build a Filter by Multiple Criteria
  • Modify a Filter with a Formula to Create an OR Condition
  • Write a Formula that Manages Null Fields
  • Formatting Reports

  • Remove White Space
  • Insert Page Header/Footer Data – Add Page Numbers, Dates, etc.
  • Add Borders and Lines
  • Change the Background Colour
  • Change the Margins
  • Enhancing Reports

  • Add Bulleted Lists
  • Modify Format Based on Date Value
  • Conditionally Suppress Data
  • Insert Hyperlinks
  • Hide Report Objects
  • Creating Parameter Fields

  • Static vs Dynamic
  • Setting Options
  • Adding to Report
  • Creating Formulas

Level 2: More Complex Reports

2 days of training, reference manuals and 30 days of technical support: $ 325 / person / day (discounts available)

This course builds on the basic reporting techniques from the Level 1 course with sophisticated reporting categories, large sets of data, and unique methods of visualizing data such as maps.

Course Prerequisites: solid understanding of Crystal Reports Level 1 topics.

  

  • 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
  • Building Cross-tabs in Your Report

  • Create a Cross-tab
  • Create a Specified Group Order
  • Filter Cross-tab by Group
  • Change the Cross-tab Format
  • Format Rows and Columns
  • Keep Groups Together
  • Adding Subreports

  • Insert a Subreport
  • Link a Subreport to Data in a Primary Report
  • Edit a Subreport
  • Format a Subreport Object
  • Share Formulas Between Main and Subreports
  • Create an On-demand Subreport
  • Working with Drill Downs

  • Hiding from Main Report
  • Adding Headings
  • The DrillDownGroupLevel Function
  • Working with Sections

  • Creating Alternating Headers & Footers
  • Creating Letters & Alternating Letters
  • Create a Watermark
  • Create Mailing Labels
  • Improving Report Processing Speed

  • Create a Report with SQL Queries
  • Edit a SQL Query
  • Summarize Report Data with SQL
  • Create and Edit Joins with SQL
  • Create Subqueries
  • Create an SQL Expression Field
  • Select Records on the Server
  • Charting Data

  • Create a Chart
  • 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
  • Distributing Data

  • Export to Excel
  • Export to an Access Database
  • Create a Report Definition
  • Reporting on Excel Data