Crystal Reports Part 1

2 Days | Price: $1310

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

This course may earn a Credly Badge.

Learning Objectives

In this course, you will connect to a database to extract data and present it as a report. You will:

  • 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.

Course Details

Course Outline

1 - Exploring the Crystal Reports Interface
  • Topic A: Explore Crystal Reports
  • Topic B: Use Crystal Reports Help
  • Topic C: Customize Report Settings
  • 2 - Working with Reports
  • Topic A: Create a Report
  • Topic B: Modify a Report
  • Topic C: Display Specific Report Data
  • Topic D: Work with Report Sections
  • 3 - Using Formulas in Reports
  • Topic A: Create a Formula
  • Topic B: Edit a Formula
  • Topic C: Filter Data by Using a Formula
  • Topic D: Work with Advanced Formulas and Functions
  • Topic E: Handle Null Values
  • 4 - Building Parameterized Reports
  • Topic A: Create a Parameter Field
  • Topic B: Use a Range Parameter in a Report
  • Topic C: Create a Prompt
  • 5 - Grouping Report Data
  • Topic A: Group Report Data
  • Topic B: Modify a Group Report
  • Topic C: Group by Using Parameters
  • Topic D: Create a Parameterized Top N Report
  • 6 - Enhancing a Report
  • Topic A: Format a Report
  • Topic B: Insert Objects in a Report
  • Topic C: Suppress Report Sections
  • Topic D: Use Report Templates
  • 7 - Creating a Report from Excel Data
  • Topic A: Create a Report Based on Excel Data
  • Topic B: Modify a Report Generated from Excel Data
  • Topic C: Update Data in a Report Based on Excel Data
  • 8 - Distributing Data
  • Topic A: Export Data
  • Topic B: Create Mailing Labels
  • 9 - Appendix
  • Appendix A: Setting Up and Configuring Data Sources
  • Appendix B: Using Report Processing Techniques
  • Appendix C: Using Functions in Formulas
  • Actual course outline may vary depending on offering center. Contact your sales representative for more information.

    Jul 11, 2024 9:00AM