(Online Delivery) SAP Crystal Reports 2020: Part 2

Course Objectives:

In this course, you will create complex reports using tools in Crystal Reports 2020.

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.

Lesson 1: Creating Running Totals

Topic A: Create a Running Total Field

Topic B: Modify a Running Total Field

Topic C: Create a Manual Running Total

Lesson 2: Working with Cross-Tabs

Topic A: Create a Cross-Tab Report

Topic B: Format a Cross-Tab Report

Topic C: Create Groups in Cross-Tab Reports

Lesson 3: Adding Subreports

Topic A: Insert a Subreport

Topic B: Edit a Subreport

Topic C: Share Variables

Lesson 4: Creating Drill-Downs in a Report

Topic A: Create a Drill-Down

Topic B: Create Headings for Drill-Down Data

Lesson 5: Using SQL Statements in Report Processing

Topic A: Create a Report Using SQL Queries

Topic B: Summarize Report Data

Topic C: Create Joins Using SQL

Topic D: Create Subqueries

Topic E: Create an SQL Expression Field

Lesson 6: Creating Complex Formulas

Topic A: Work with Loops

Topic B: Work with Arrays

Lesson 7: Adding Charts to Reports

Topic A: Create Charts

Topic B: Drill Down to Chart Data

Topic C: Create a Top N Chart

Topic D: Create a Cross-Tab Chart

Topic E: Create Charts for Grouped Data

Topic F: Format a Chart

Topic G: Create a Chart Template

Lesson 8: Enhancing Report Functionality

Topic A: Organize Data Based on a Hierarchy

Topic B: Create a Dynamic Image

Topic C: Create a Report Alert

Topic D: Create a Geographic Map