Skip to main content

Crystal Reports Part 2 - GCRM20

0%

Previous
Course data

General

Announcements

Course Overview - Introduction

Course Overview - Introduction

Class Data File Download

How to Reconnect Crystal Reports to Data Source

Creating Running Totals

Creating Running Totals - Overview

Topic A: Create a Running Total Field - Lecture

Create a Running Total Field - Demonstration

Activity 1-1: Creating a Running Total Field - Solution

Topic B: Modify a Running Total Field - Lecture

Activity 1-2: Modifying a Running Total Field - Solution

Activity 1-3: Resetting a Running Total Field - Solution

Topic C: Create a Manual Running Total - Lecture

Activity 1-4: Creating a Manual Running Total on Detail Data - Solution

Activity 1-5: Creating a Manual Running Total on Summary Data - Solution

Creating Running Totals - Summary

Working with Cross-Tabs

Working with Cross-Tabs - Overview

Topic A: Create a Cross-Tab Report - Lecture

Activity 2-1: Creating a Cross-Tab Report - Solution

Topic B: Format a Cross-Tab Report - Lecture

Activity 2-2: Formatting a Cross-Tab Report - Solution

Topic C: Create Groups in Cross-Tab Reports - Lecture

Activity 2-3: Creating Groups in Cross-Tab Reports - Solution

Working with Cross-Tabs - Summary

Adding Subreports

Adding Subreports - Overview

Topic A: Insert a Subreport - Lecture

Insert a Subreport - Discussion and Demonstration

Activity 3-1: Inserting a Subreport - Solution

Topic B: Edit a Subreport - Lecture

Edit a Subreport - Demonstration

Activity 3-2: Editing a Subreport - Solution

Activity 3-3: Creating an On-Demand Subreport - Solution

Topic C: Share Variables - Lecture

Activity 3-4: Sharing Formulas Between Primary Reports and Subreports - Solution

Adding Subreports - Summary

Creating Drill-Downs in a Report

Creating Drill-Downs in a Report - Overview

Topic A: Create a Drill-Down - Lecture

Activity 4-1: Creating a Drill-Down - Solution

Topic B: Create Headings for Drill-Down Data - Lecture

Activity 4-2: Creating Headings for Drill-Down Data - Solution

Creating Drill-Downs in a Report - Summary

Using SQL Statements in Report Processing

Using SQL Statements in Report Processing - Overview

Topic A: Create a Report Using SQL Queries - Lecture

Create a Report Using SQL Queries - Demonstration

Activity 5-1 Creating a Report Using an SQL Query - Solution

Topic B: Summarize Report Data - Lecture

Activity 5-2: Summarizing Report Data Using the Count Function - Solution

Topic C: Create Joins Using SQL - Lecture

Create Joins Using SQL - Demonstration

Activity 5-3: Creating SQL Joins - Solution

Activity 5-4: Changing the Join Type - Solution

Topic D: Create Subqueries - Lecture

Activity 5-5: Creating Subqueries - Solution

Topic E: Create an SQL Expression Field - Lecture

Activity 5-6: Creating an SQL Expression Field - Solution

Using SQL Statements in Report Processing - Summary

Creating Complex Formulas

Creating Complex Formulas - Overview

Topic A: Work with Loops - Lecture

Activity 6-1: Working with Loops - Solution

Topic B: Work with Arrays - Lecture

Activity 6-2: Working with ArraysSolution

Creating Complex Formulas - Summary

Adding Charts to Reports

Adding Charts to Reports - Overview

Topic A: Create Charts - Lecture

Chart Elements - Demonstration

The Chart Expert - Demonstration

Topic B: Drill Down to Chart Data - Lecture

Activity 7-2: Creating a Pie Chart with Drill-Down - Solution

Topic C: Create a Top N Chart - Lecture

Activity 7-3: Creating a Top N Chart - Solution

Topic D: Create a Cross-Tab Chart - Lecture

Activity 7-4: Creating a Cross-Tab Chart - Solution

Topic E: Create Charts for Grouped Data - Lecture

Activity 7-5: Presenting a Chart by Group - Solution

Topic F: Format a Chart - Lecture

Activity 7-6: Formatting a Chart - Solution

Topic G: Create a Chart Template - Lecture

Creating a Chart Template - Demonstration

Activity 7-7: Creating a Chart Template - Solution

Adding Charts to Reports - Summary

Enhancing Report Functionality

Enhancing Report Functionality - Overview

Topic A: Organize Data Based on a Hierarchy - Lecture

Activity 8-1: Organizing Data Based on a Hierarchy - Solution

Topic B: Create a Dynamic Image - Lecture

Activity 8-2: Creating a Dynamic Image - Solution

Topic C: Create a Report Alert - Lecture

Activity 8-3: Creating a Report Alert - Solution

Topic D: Create a Geographic Map - Lecture

Create a Geographic Map - Demonstration

Activity 8-4: Creating a Geographic Map - Solution

Enhancing Report Functionality - Summary

Course Summary

Course Summary
Next

Categories
- All categories
AI Learning Hub
AI Essentials

Level 1: Generative AI Foundation

Level 2: Grounding AI with your Data

Level 3: Automating AI Workflows

Copilot First-Step Kit

Claude

ChatGPT

Microsoft Copilot
M365
Office

Excel

Word

Outlook

PowerPoint

Power Platform

Power BI

Power Apps

Power Automate

SharePoint
- Microsoft Official
- Adobe
- CompTIA
- Holding
- Webinars
- Programming
- WordPress
- Accounting
- Google
- Upskilling Series
Home

Log in

Username Username

Password Password

Forgot your password?

Categories Collapse Expand

All categories

AI Learning Hub

AI Essentials

Level 1: Generative AI Foundation

Level 2: Grounding AI with your Data

Level 3: Automating AI Workflows

Copilot First-Step Kit

Claude

ChatGPT

Microsoft Copilot

M365

Office

Excel

Word

Outlook

PowerPoint

Power Platform

Power BI

Power Apps

Power Automate

SharePoint

Microsoft Official

Adobe

CompTIA

Holding

Webinars

Programming

WordPress

Accounting

Google

Upskilling Series

Home

Course info

Crystal Reports Part 2 - GCRM20

Skill Level: Beginner

Help & Support

You are not logged in. (Log in)

Data retention summary

Get the mobile app

Powered by Moodle

Privacy Policy Terms & Conditions

Copyrights Content

General

Announcements

Course Overview - Introduction

Course Overview - Introduction

Class Data File Download

How to Reconnect Crystal Reports to Data Source

Creating Running Totals

Creating Running Totals - Overview

Topic A: Create a Running Total Field - Lecture

Create a Running Total Field - Demonstration

Activity 1-1: Creating a Running Total Field - Solution

Topic B: Modify a Running Total Field - Lecture

Activity 1-2: Modifying a Running Total Field - Solution

Activity 1-3: Resetting a Running Total Field - Solution

Topic C: Create a Manual Running Total - Lecture

Activity 1-4: Creating a Manual Running Total on Detail Data - Solution

Activity 1-5: Creating a Manual Running Total on Summary Data - Solution

Creating Running Totals - Summary

Working with Cross-Tabs

Working with Cross-Tabs - Overview

Topic A: Create a Cross-Tab Report - Lecture

Activity 2-1: Creating a Cross-Tab Report - Solution

Topic B: Format a Cross-Tab Report - Lecture

Activity 2-2: Formatting a Cross-Tab Report - Solution

Topic C: Create Groups in Cross-Tab Reports - Lecture

Activity 2-3: Creating Groups in Cross-Tab Reports - Solution

Working with Cross-Tabs - Summary

Adding Subreports

Adding Subreports - Overview

Topic A: Insert a Subreport - Lecture

Insert a Subreport - Discussion and Demonstration

Activity 3-1: Inserting a Subreport - Solution

Topic B: Edit a Subreport - Lecture

Edit a Subreport - Demonstration

Activity 3-2: Editing a Subreport - Solution

Activity 3-3: Creating an On-Demand Subreport - Solution

Topic C: Share Variables - Lecture

Activity 3-4: Sharing Formulas Between Primary Reports and Subreports - Solution

Adding Subreports - Summary

Creating Drill-Downs in a Report

Creating Drill-Downs in a Report - Overview

Topic A: Create a Drill-Down - Lecture

Activity 4-1: Creating a Drill-Down - Solution

Topic B: Create Headings for Drill-Down Data - Lecture

Activity 4-2: Creating Headings for Drill-Down Data - Solution

Creating Drill-Downs in a Report - Summary

Using SQL Statements in Report Processing

Using SQL Statements in Report Processing - Overview

Topic A: Create a Report Using SQL Queries - Lecture

Create a Report Using SQL Queries - Demonstration

Activity 5-1 Creating a Report Using an SQL Query - Solution

Topic B: Summarize Report Data - Lecture

Activity 5-2: Summarizing Report Data Using the Count Function - Solution

Topic C: Create Joins Using SQL - Lecture

Create Joins Using SQL - Demonstration

Activity 5-3: Creating SQL Joins - Solution

Activity 5-4: Changing the Join Type - Solution

Topic D: Create Subqueries - Lecture

Activity 5-5: Creating Subqueries - Solution

Topic E: Create an SQL Expression Field - Lecture

Activity 5-6: Creating an SQL Expression Field - Solution

Using SQL Statements in Report Processing - Summary

Creating Complex Formulas

Creating Complex Formulas - Overview

Topic A: Work with Loops - Lecture

Activity 6-1: Working with Loops - Solution

Topic B: Work with Arrays - Lecture

Activity 6-2: Working with ArraysSolution

Creating Complex Formulas - Summary

Adding Charts to Reports

Adding Charts to Reports - Overview

Topic A: Create Charts - Lecture

Chart Elements - Demonstration

The Chart Expert - Demonstration

Topic B: Drill Down to Chart Data - Lecture

Activity 7-2: Creating a Pie Chart with Drill-Down - Solution

Topic C: Create a Top N Chart - Lecture

Activity 7-3: Creating a Top N Chart - Solution

Topic D: Create a Cross-Tab Chart - Lecture

Activity 7-4: Creating a Cross-Tab Chart - Solution