Loading Events

« All Events

  • This event has passed.

Crystal Reports 2016: Part 1

June 25 @ 8:00 am - June 26 @ 5:00 pm

|Recurring Event (See all)

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

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

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

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

Live Online Instructor Led

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

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 Topi

c 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

Details

Start:
June 25 @ 8:00 am
End:
June 26 @ 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