banner image

Crystal Reports Advanced

2 Day Instructor-led
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

Dates & Availability

We currently don’t have any dates scheduled for this training course but offer it as a corporate, private course for your own team.

Please use the enquire button below.

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

Very informative course, very useful tips on how to work with SQL Management Studio. A lot of SQL quirks explained, a lot of good examples.

Magdalena Piekarska - Veolia

Course was well adjusted to consider the business perspective - considering commonly needed calculations, time based data analysis etc.

Suvi Salminen - Crane CPE

The trainer did a fantastic job of delivering the course and providing understanding

Niall Simmons - Haven Power

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

The trainer was an excellent tutor. He did check all of the group was able to keep up and if there were any problems or questions of the attendants, he was always willing to help.

Marianne Seager - Wincanton

The pace he delivered the course was perfect and he explained everything so clearly and in a way I could understand.

Jessica Homer - All About Food

Related Courses

Format:
Virtual or Classroom
Length:
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.
Format:
Virtual or Classroom
Length:
2 Days
 Learn to create complex reports and data sources. You will include sub-reports and cross-tabs along with SQL queries.