Crystal Reports 2016 - Part 1 (UT-CR-16-P1)


Course Description

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

Course 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

 

There are no prerequisites for this course.

Course Information

Length: 2 day

Format: Lecture and Lab

Delivery Method: n/a

Max. Capacity: 16



Schedule

Contact Us


Do you have more questions? We're delighted to assist you!

1-877-797-2799
info@firefly.cloud

Who Should Attend

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.