Crystal Reports Training | Crystal Reports Courses

Students will learn the basics of report creation including sorting, grouping, linking, basic formula creation, working with report experts and how to distribute reports to other users.

Course Objectives

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

Who Should Attend

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

Pre-requisites

Delegates should be familiar with basic functions such as creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files in Microsoft Windows. They should also have an understanding of basic database concepts such as those outlined in any of our Microsoft Outlook Introduction courses.

Course Outline

Exploring the SAP Crystal Reports 2011 Interface

• Explore Crystal Reports
• Use Crystal Reports Help
• Customise the Report Settings

Working with Reports

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

Using Formulas in Reports

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

Building Parameterised Reports

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

Grouping Report Data

• Group Report Data
• Modify a Group Report
• Group Using Parameters
• Create a Parameterised Top N Report

Enhancing a Report

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

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

Distributing Data

• Export Data
• Create Mailing Labels