Essential Skills Gained

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

Format

Instructor-led
2 days with lectures and hands-on labs.

Audience

Database Administrators
Business Analysts
IT Professionals
Report Developers

Description

This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or such tools may not be accessible. Previous experience with programming or SQL is helpful but not required.

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Lesson 1: Exploring the SAP Crystal Reports 2013 Interface

Explore Crystal Reports
Use Crystal Reports Help
Customize the Report Settings

Lesson 2: Working with Reports

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

Lesson 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

Lesson 4: Building Parameterized Reports

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

Lesson 5: Grouping Report Data

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

Lesson 6: Enhancing a Report

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

Lesson 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

Lesson 8: Distributing Data

Export Data
Create Mailing Labels

Appendix A: Setting Up and Configuring Data Sources

Appendix B: Using Report Processing Techniques

Appendix C: Using Functions in Formulas

Crystal Reports 2013 Level 1