DUNS #: 07-985-4198 | Cage Code: 7F5V0 | NAICS Codes: 611310, 611420

Crystal Reports XI: Level 1

2 Days

Price: $650

Register to Schedule

These programs require a minimum of 3 registrants to schedule. If you contact us with some possible start times we will respond with a class schedule that meets your requirements.
  • This field is for validation purposes and should be left unchanged.

Overview

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


Objectives

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

  • identify 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 database.
  • distribute data.

Audience

This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, and/or such tools may not be accessible. Students may or may not have programming and/or SQL experience.


Prerequisites


Outline

1 – EXPLORING THE SAP CRYSTAL REPORTS 2011 INTERFACE

Explore Crystal Reports Use Crystal Reports Help Customize the Report Settings

2 – WORKING WITH REPORTS

Create a Report Modify a Report Display Specific Report Data Work with Report Sections

3 – USING FORMULAS IN REPORTS

Create a Formula Edit a Formula Filter Data Using a Formula Work with Advanced Formulas and Functions Handle Null Values

4 – BUILDING PARAMETERIZED REPORTS

Create a Parameter Field Use a Range Parameter in a Report Create a Prompt

5 – GROUPING REPORT DATA

Group Report Data Modify a Group Report Group Using Parameters Create a Parameterized Top N Report

6 – ENHANCING A REPORT

Format a Report Insert Objects in a Report Suppress Report Sections Use Report Templates

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

8 – DISTRIBUTING DATA

Export Data Creating Mailing Labels

Actual course outline may vary depending on offering center. Contact your sales representative for more information.