Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4

In this course, students will build basic list and group reports that work with almost any database. This course requires a basic understanding of databases and their underlying purpose

Course Outline
Course Length: 12hrs (2 Days)

Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, you will create a basic report by connecting to a database and modifying the report's presentation.

Information is critical to making sound business decisions. Data presented without any formatting or structure holds little or no meaning for interpretation. Crystal Reports helps you build advanced reports with ease, presenting complex information in an understandable way.

Learning 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 Student:
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 Outline:
Section 1: Exploring the Crystal Reports Interface

Explore Crystal Reports
Use Crystal Reports Help
Customize Report Settings

Section 2: Working with Reports
Create a Report
Modify a Report
Display Specific Report Data
Work with Report Sections

Section: 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

Section 4: Building Parameterized Reports
Create a Parameter Field
Use a Range Parameter in a Report
Create a Prompt

Section 5: Grouping Report Data
Group Report Data
Modify a Group Report
Group by Using Parameters
Create a Parameterized Top N Report

Section 6: Enhancing a Report
Format a Report
Insert Objects in a Report
Suppress Report Sections
Use Report Templates

Section 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

Section 8: Distributing Data
Export Data
Create Mailing Labels

Prerequisites & Certificates

This course requires a basic understanding of databases and their underlying purpose

Certificates offered

Certificate of completion

Cancellation Policy

Compuease Cancellation Policy
We at Compuease work hard to arrange our schedules around your needs. Last minute cancellations put additional strain on our schedules and therefore we have the following Cancellation Policy for our Public Classes. You may cancel or reschedule a registration at any time up to 10 business days before the class without penalty. Canceling or rescheduling a registration within 10 business days requires full payment of the course fee. You are welcome to transfer your seat in a class to another individual at any time before the class.

Map & Reviews
[ View Provider's Profile ]

The building itself is pretty dingy, but the instructor made up for it!!
Reviewed by 2015

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 4207 times.