Loading Events

« All Events

  • This event has passed.

Crystal Reports 2013: Part 1

June 12 @ 8:00 am - June 13 @ 5:00 pm

|Recurring Event (See all)

One event on March 7, 2018 at 8:00am

One event on April 10, 2018 at 8:00am

One event on May 10, 2018 at 8:00am

One event on June 12, 2018 at 8:00am

Live Online Instructor Led

PREREQUISITES

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.

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.

COURSE OUTLINE

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

Details

Start:
June 12 @ 8:00 am
End:
June 13 @ 5:00 pm
Event Categories:
,

Organizer

Tony Scott
Phone:
6019145026
Email:
tony@systemsit-ms.com
Website:
www.systemsit-ms.com

Venue

Systems IT
1855 Lakeland Drive, Suite R-101
Jackson, MS 39216 United States
+ Google Map
Phone:
6019144500
Website:
www.systemsit-ms.com