Course Code: 95202
Course Length: 2 days

OVERVIEW

Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports® 2016 enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, you will create a basic report by connecting to a database and modifying the report's presentation. Information is critical to making sound business decisions. Data presented without any formatting or structure holds little or no meaning for interpretation. Crystal Reports 2016 helps you build advanced reports with ease, presenting complex information in an understandable way.

PREREQUISITES

Before taking this course, students should be familiar with the basic functions of Windows and database concepts.

PERFORMANCE-BASED 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 CONTENT

LESSON 1: EXPLORING THE CRYSTAL REPORTS INTERFACE
Explore Crystal Reports; Use Crystal Reports Help; Customize Report Settings

LESSON 2: WORKING WITH REPORTS
Create a Report; Modify a Report; Display Specific Report Data; Work with Report Sections

LESSON 3: USING FORMULA IN REPORTS
Create a Formula; Edit a Formula; Filter Data by using a Formula; Work with Advanced Formulas and Functions; Handle Null Values

LESSON 4: BUILDING PARAMETERIZED REPORTS
Create a Parameter Field; Use a Range Parameter in a Report; Create a Prompt

LESSON 5: GROUPING REPORT DATA
Group Report Data; Modify a Group Report; Group by Using Parameters; Create a Parameterized Top N Report

LESSON 6: ENHANCING A REPORT
Format a Report; Insert Objects in a Report; Suppress Report Sections; Use Report Templates

LESSON 7: CREATING A REPORT FROM EXCEL DATA
Create a Report Based on Excel Data; Modify a Report Generated from Excel Data; Update Data in a Report Based on Excel data

LESSON 8: DISTRIBUTING DATA
Export Data; Create Mailing Labels

Appendix A: Setting up and Configuring Data Sources

Appendix B: Using Report Processing Techniques

Appendix C: using Functions in Formulas

Before taking this course, students should be familiar with the basic functions of Windows and database concepts.