Crystal Reports 2016 – Part 2

In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency.
Course Details

Price:

$990.00

Days:

2

Location:

Virtual

Course Overview

In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency.

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.

Crystal Reports 2016 – Part 1 or equivalent experience

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
08/04/2025 - 08/05/2025
Virtual
09:00:00 to 17:00:00 EST
Enroll Now
$990.00
09/29/2025 - 09/30/2025
Virtual
09:00:00 to 17:00:00 EST
Enroll Now
$990.00
11/20/2025 - 11/21/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.