Virtual and Classroom Training - All our courses are available virtually. We have also started a safe return to classroom training. Click here to learn more.

banner image

Crystal Reports Advanced

2 Day Course
course icon

Course Information

Overview

You will create complex reports using Crystal Reports' tools.

Objectives

  • Upon successful completion of this course, students will be able to:
  • Create automatic and manual running totals.
  • Work with cross-tab reports.
  • Add subreports.
  • Create drill-downs in a report.
  • Use SQL statements in report processing.
  • Create complex formulas.
  • Add charts to reports.
  • Enhance report functionality.

Target Student

This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience.

Prerequisites

Crystal Reports® 2011: Level 1. A knowledge of programming and/or SQL would also be helpful.

Course Outline

1. Creating Running Totals
  • Create a Running Total Field
  • Modify a Running Total Field
  • Create a Manual Running Total
2. Working with Cross-Tabs
  • Create a Cross-Tab Report
  • Format a Cross-Tab Report
  • Create Groups in Cross-Tab Reports
3. Adding Subreports
  • Insert a Subreport
  • Edit a Subreport
  • Share Variables
4. Creating Drill-Downs in a Report
  • Create a Drill-Down
  • Create Headings for Drill-Down Data
5. Using SQL Statements in Report Processing
  • Create a Report Using SQL Queries
  • Summarize Report Data
  • Create Joins Using SQL
  • Create Subqueries
  • Create a SQL Expression Field
6. Creating Complex Formulas
  • Work with Loops
  • Work with Arrays
7. Adding Charts to Reports
  • Create Charts
  • Create a Chart with a Drill-Down
8. Enhancing Report Functionality
  • Organize Data Based on a Hierarchy
  • Create a Dynamic Image
  • Create a Report Alert
  • Create a Geographic Map

Private Courses

We can arrange your own private Crystal Reports* course.

Tailored

Have us build a custom private course tailored to your needs.

Cost Effective

If you are looking to training a group of people private courses can be very cost effective.

Post Course Support

Unlimited post course email support on the course topics.

What Our Clients Think

As usual a first class training course.

Wendy Thomas - Aldi Stores Ltd

Very good, trainer was excellent.

Mike Hartley-Bingle - XPS Pensions Group

Very good course. I've been using the software constantly in the last three months and still learnt a lot.

George Martin - NHS North of England

The trainer was a really good instructor, he took the time to help us with individual issues and also tried to cater the course to meet our collective needs.

Ben Knight - Atlas Copco Ltd

Cannot fault the content & delivery of the course at all. A brilliant service from start to finish. Thank you Systematix.

Claire Mitchell - Denbighshire County Council

Course is well structured and instructor delivered the content, and more, perfectly. No question left unanswered, no theory unexplained.

Aidan Hamill - Intact Software

Related Courses

Introduction 2 Days
Learn how to create customised and richly formatted, interactive reports from all your data sources. Help deliver insightful information and make better decisions.
Advanced 2 Days
 Learn to create complex reports and data sources. You will include sub-reports and cross-tabs along with SQL queries.