185 Madison Ave. at 34th St., Suite 1104, New York, NY 10016 • 212-684-5151
Crystal Reports 2016: Level 2
Crystal Reports 2016: Level 2

Price: $650.00

Course Code: CZ | Hours: 16

Crystal Reports Training Overview: Level 2

You will create complex reports using Crystal Reports' tools.

Upon successful completion of this course, students will be able to:

  • 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

Prerequisites:

Students should have a basic understanding of Windows, including how to use files and folders.

Related Classes:

See Also:

Prerequisites:

Students should have a basic understanding of Windows, including how to use files and folders.

Related Classes:

See Also:

Crystal Reports Training Class Outline - Level 2

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: 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

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

Appendix A: Managing Reports

Appendix B: Processing Data on the Server

Appendix C: Detecting and Fixing Problems

        • Topic 8A: Create a Static Prompt
        • Topic 8B: Create a Dynamic Prompt

Lesson 9: Enhancing Report Functionality

        • Topic 9A: Group Data Hierarchically
        • Topic 9B: Create a Dynamic Image
        • Topic 9C: Create a Report Alert
        • Topic 9D: Create a Geographic Map