Crystal Reports 2016 - Part 1

Duration
2 Days
Price
$550.00
In this course, students will create a basic report by connecting to a database and modifying the report's presentation.

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

Target Audience

This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience.

Upcoming Class Dates and Times
Login