Crystal Reports 2016 – Part 1

In this course, students will create a basic report by connecting to a database and modifying the report’s presentation.
Course Details

Price:

$990.00

Days:

2

Location:

Virtual

Course Overview

In this course, students will create a basic report by connecting to a database and modifying the report’s presentation.

Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data.

Basic computer literacy Basic PC operating system navigation skills Basic Internet usage skills Basic IP address knowledge

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

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

3 – ADDING SUBREPORTS

  • Topic A: Insert a Subreport
  • Topic B: Edit a Subreport
  • Topic C: Share Variables

4 – CREATING DRILL-DOWNS IN A REPORT

  • Topic A: Create a Drill-Down
  • Topic B: Create Headings for Drill-Down Data

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

6 – CREATING COMPLEX FORMULAS

  • Topic A: Work with Loops
  • Topic B: Work with Arrays

7 – ADDING CHARTS TO REPORTS

  • Topic A: Create Charts
  • Topic B: Create a Chart with Drill-Down
  • 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

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

9 – APPENDIX

  • Appendix A: Managing Reports
  • Appendix B: Processing Data on the Server
  • Appendix C: Detecting and Fixing Problems
Class Dates & Times
Filters Sort results
Reset Apply
01/26/2026 - 01/27/2026
Virtual
09:00:00 to 17:00:00 EST
Enroll Now
$990.00
04/30/2026 - 05/01/2026
Virtual
09:00:00 to 17:00:00 EST
Enroll Now
$990.00
10/29/2025 - 10/30/2025
Virtual
11:00:00 to 19:00:00 PST
Enroll Now
$990.00
11/13/2025 - 11/14/2025
Virtual
09:00:00 to 17:00:00 EST
Enroll Now
$990.00
— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.