Skip to main content

Crystal Reports Part 1 & Part 2

0%

Previous
Course data

General

Announcements

Crystal Reports 2020 Part 1: Course Overview - Introduction

Course Overview - Introduction

Class Data File Download

Exploring the Crystal Reports Interface

Exploring the Crystal Reports Interface - Overview

Topic A: Explore Crystal Reports

Start Page and Preview Tab - Demonstration

Design Tab - Demonstration

Activity 1-1: Exploring the Crystal Reports Interface - Solution

Topic B: Use Crystal Reports Help - Demonstration

Activity 1-2: Use Crustal Reports Help - Solution

Topic C: Customize Report Settings - Demonstration

Activity 1-3: Customize Report Settings - Solution

Exploring the Crystal Reports Interface - Summary

Working with Reports

How to Reconnect Crystal Reports to Data Source

Working with Reports - Overview

Topic A: Create a Report - Demonstration

Activity 2-1: Creating a Report - Solution

Activity 2-2: Changing the Join Type - Solution

Topic B: Modify A Report - Demonstration

Activity 2-3: Positioning Fields in a Report - Solution

Topic C: Display Specific Report Data - Demonstration

The Find Dialog Box - Demonstration

Activity 2-4: Displaying Specific Data in a Report - Solution

Topic D: Work with Report Sections - Demonstration

Activity 2-5: Working with Report Sections - Solution

Working with Reports - Summary

Using Formulas in Reports

Using Formulas in Reports - Overview

Topic A: Discussion Formulas and Operators Rule - Discussion

Creating a Formula - Demonstration

Activity 3-1: Creating a Formula in a Report - Solution

Topic B: Edit and Delete a Formula - Demonstration

Activity 3-2: Editing a Formula - Solution

Topic C: Filter by Using a Formula

Filter Data by Using a Formula - Demonstration

Activity 3-3: Building a Filter by Using Multiple Criteria - Solution

Activity 3-4: Modifying a Filter to Include the OR Operator - Solution

Topic D: Work with Advanced Formulas and Functions

If-Then-Else Statement - Demonstration

Variable Declaration - Demonstration

Activity 3-5: Working with Advanced Formulas and Functions - Solution

Activity 3-6: Working with Date Functions - Solution

Activity 3-7: Working with String Functions - Solution

Activity 3-8: Working with Absolute Values - Solution

Topic E: Handle Null Values

Handle Null Values - Demonstration

Activity 3-9: Handling Null Values in a Report - Solution

Using Formulas in Reports - Summary

Building Parameterized Reports

Building Parameterized Reports - Overview

Topic A: Create a Parameter

Create a Parameter Report - Demonstration

Activity 4-1: Creating a Parameter Field - Solution

Topic B: Use a Range Parameter in a Report

Use a Range Parameter and Edit Mask in a Report - Demonstration

Activity 4-2: Using a Date Range Parameter - Solution

Activity 4-3: Working with Edit Masks - Solution

Topic C: Create a Prompt

Activity 4-4: Creating a Dynamic Prompt - Solution

Building Parameterized Reports - Summary

Grouping Report Data

Grouping Report Data - Overview

Topic A: Group Report Data

Group Report Data - Demonstration

Activity 5-1: Grouping Data in a Report - Solution

Activity 5-2: Formatting the Summary Data - Solution

Topic B: Modify a Group Report

Create Multiple Groups - Demonstration

Delete a Group - Demonstration

Filter and Sort Groups - Demonstration

Activity 5-3: Modifying Groups in a Report - Solution

Topic C: Group by Using Parameters

Activity 5-4: Grouping by Using Parameters - Solution

Topic D: Create a Parameterized Top N Report

Activity 5-5: Creating a Parameterized Top N Report - Solution

Grouping Report Data - Summary

Enhancing a Report

Enhancing a Report - Overview

Topic A: Form a Report

Activity 6-1: Formatting a Report - Solution

Activity 6-2: Changing Report Margins - Solution

Activity 6-3: Formatting Based on Data Value - Solution

Topic B: Insert Objects in a Report

Activity 6-4: Inserting Objects in a Report - Solution

Activity 6-5: Inserting Hyperlinks in a Report - Solution

Topic C: Suppress Report Sections

Activity 6-6: Suppressing Blank Report Sections - Solution

Activity 6-7: Conditionally Suppressing a Report Section - Solution

Topic D: Use Report Templates

Activity 6-8: Designing Report Templates - Solution

Enchaining a Report - Summary

Creating a Report from Excel Data

Creating a Report from Excel Data - Overview

Topic A: Create a Report Based on Excel Data

Activity 7-1 Creating a Report Based on Excel Data - Solution

Topic B: Modify a Report Generated from Excel Data

Activity 7-2: Modifying a Report Based on Excel Data - Solution

Topic C: Update Data in a Report Based on Excel Data

Activity 7-3: Updating a Report in Crystal Reports - Solution

Creating a Report from Excel Data - Summary

Distributing Data

Distributing Data - Overview

Topic A: Export Data

Activity 8-1: Exporting a Report to Excel - Solution

Activity 8-2: Exporting to a PDF File - Solution

Topic B: Export Data

Create Mailing Labels - Demonstration

Activity 8-3: Creating Mailing Labels - Solution

Distributing Data - Summary

Crystal Reports 2020 Part 2: 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 1 & Part 2

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

Crystal Reports 2020 Part 1: Course Overview - Introduction

Course Overview - Introduction

Class Data File Download

Exploring the Crystal Reports Interface

Exploring the Crystal Reports Interface - Overview

Topic A: Explore Crystal Reports

Start Page and Preview Tab - Demonstration

Design Tab - Demonstration

Activity 1-1: Exploring the Crystal Reports Interface - Solution

Topic B: Use Crystal Reports Help - Demonstration

Activity 1-2: Use Crustal Reports Help - Solution

Topic C: Customize Report Settings - Demonstration

Activity 1-3: Customize Report Settings - Solution

Exploring the Crystal Reports Interface - Summary

Working with Reports

How to Reconnect Crystal Reports to Data Source

Working with Reports - Overview

Topic A: Create a Report - Demonstration

Activity 2-1: Creating a Report - Solution

Activity 2-2: Changing the Join Type - Solution

Topic B: Modify A Report - Demonstration

Activity 2-3: Positioning Fields in a Report - Solution

Topic C: Display Specific Report Data - Demonstration

The Find Dialog Box - Demonstration

Activity 2-4: Displaying Specific Data in a Report - Solution

Topic D: Work with Report Sections - Demonstration

Activity 2-5: Working with Report Sections - Solution

Working with Reports - Summary

Using Formulas in Reports

Using Formulas in Reports - Overview

Topic A: Discussion Formulas and Operators Rule - Discussion

Creating a Formula - Demonstration

Activity 3-1: Creating a Formula in a Report - Solution

Topic B: Edit and Delete a Formula - Demonstration

Activity 3-2: Editing a Formula - Solution

Topic C: Filter by Using a Formula

Filter Data by Using a Formula - Demonstration

Activity 3-3: Building a Filter by Using Multiple Criteria - Solution

Activity 3-4: Modifying a Filter to Include the OR Operator - Solution

Topic D: Work with Advanced Formulas and Functions

If-Then-Else Statement - Demonstration

Variable Declaration - Demonstration

Activity 3-5: Working with Advanced Formulas and Functions - Solution

Activity 3-6: Working with Date Functions - Solution

Activity 3-7: Working with String Functions - Solution

Activity 3-8: Working with Absolute Values - Solution

Topic E: Handle Null Values

Handle Null Values - Demonstration

Activity 3-9: Handling Null Values in a Report - Solution

Using Formulas in Reports - Summary

Building Parameterized Reports

Building Parameterized Reports - Overview

Topic A: Create a Parameter

Create a Parameter Report - Demonstration

Activity 4-1: Creating a Parameter Field - Solution

Topic B: Use a Range Parameter in a Report

Use a Range Parameter and Edit Mask in a Report - Demonstration

Activity 4-2: Using a Date Range Parameter - Solution

Activity 4-3: Working with Edit Masks - Solution

Topic C: Create a Prompt

Activity 4-4: Creating a Dynamic Prompt - Solution

Building Parameterized Reports - Summary

Grouping Report Data

Grouping Report Data - Overview

Topic A: Group Report Data

Group Report Data - Demonstration

Activity 5-1: Grouping Data in a Report - Solution

Activity 5-2: Formatting the Summary Data - Solution

Topic B: Modify a Group Report

Create Multiple Groups - Demonstration

Delete a Group - Demonstration

Filter and Sort Groups - Demonstration

Activity 5-3: Modifying Groups in a Report - Solution

Topic C: Group by Using Parameters

Activity 5-4: Grouping by Using Parameters - Solution

Topic D: Create a Parameterized Top N Report

Activity 5-5: Creating a Parameterized Top N Report - Solution

Grouping Report Data - Summary