Log On/Register  

855.838.5028

Crystal Reports 2013 - Part 1

Duration: 2 Days
Course Price: $990

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.

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.

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.

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.

Before taking this course, learners should be familiar with basic computer functions, such as creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files in Microsoft® Windows®. In addition, learners should have taken the Microsoft® Office Access® 2013: Level 1 course or have equivalent experience with basic database concepts.

1 - EXPLORING THE CRYSTAL REPORTS INTERFACE

Explore Crystal Reports Use Crystal Reports Help Customize 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 by 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 by 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 Create Mailing Labels

Learn More
Please type the letters below so we know you are not a robot (upper or lower case):

The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.

ITIL® is a registered trade mark of AXELOS Limited, used under permission of AXELOS Limited. The Swirl logo is a trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.