Crystal Reports 2013: Part 2

Skills covered:
Displaying courses for United States [Change]

Overview

In this course, you will create complex reports and data sources using the tools in Crystal Reports 2013. You will not only create more sophisticated reports including subreports and cross-tabs, but you will also increase in speed and efficiency.

Objectives

In this course, you will create complex reports using tools in Crystal Reports 2013.You will:
  • 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.

Audience

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.

Syllabus

Creating Running Totals

  • Create a Running Total Field
  • Modify a Running Total Field
  • Create a Manual Running Total

Working with Cross-Tabs

  • Create a Cross-Tab Report
  • Format a Cross-Tab Report
  • Create Groups in Cross-Tab Reports

Adding Subreports

  • Insert a Subreport
  • Edit a Subreport
  • Share Variables

Creating Drill-Downs in a Report

  • Create a Drill-Down
  • Create Headings for Drill-Down Data

Using SQL Statements in Report Processing

  • Create a Report Using SQL Queries
  • Summarize Report Data
  • Create Joins Using SQL
  • Create Subqueries
  • Create an SQL Expression Field

Creating Complex Formulas

  • Work with Loops
  • Work with Arrays

Adding Charts to Reports

  • Create Charts
  • 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

Enhancing Report Functionality

  • Organize Data Based on a Hierarchy
  • Create a Dynamic Image
  • Create a Report Alert
  • Create a Geographic Map

Training provider

Teaching mode:
Classroom - Instructor Led
Online - Instructor Led
Duration: 2 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

SQL
United States
This skill has an average salary of
US$93,959
and is mentioned in
6.82%
of job ads in this area.
Crystal Reports
United States
This skill has an average salary of
US$74,102
and is mentioned in
0.16%
of job ads in this area.