Welcome to ONLC Training Centers


Crystal Reports On-Demand: Comprehensive (Part 1 & Part 2) Course Outline

 (4 days)

*** Note: This is an On-Demand Self Study Class, covering 4 days of content, 6-month access, $695 ***
You can take this class at any time; there are no set dates. It covers the same content as the 2-day, Crystal Reports Part 1 and the 2-day, Crystal Reports Part 2 classes. This course is taught using Crystal Reports 2016 software. However, there are very few differences between the 2016 and the 2013 and 2011 versions. Users of any of the 3 versions of Crystal Reports will have no problem learning in the 2016 software environment.
Customers must call us directly to purchase this class at 800-288-8221.

Overview
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.

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.

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® 2016: Level 1 course or have equivalent experience with basic database concepts.

Do You Still Prefer a Live, Instructor-led Class?
Already know Crystal Reports On-Demand is not right for you? We also offer this same course content in a live, instructor-led format. For more details, click on the links below:
Instructor-led Crystal Reports Part 1
Instructor-led Crystal Reports Part 2

Course Content

From Crystal Reports Part 1:

Lesson 1: Exploring the Crystal Reports Interface
Topic A: Explore Crystal Reports
Topic B: Use Crystal Reports Help
Topic C: Customize Report Settings

Lesson 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

Lesson 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

Lesson 4: Building Parameterized Reports
Topic A: Create a Parameter Field
Topic B: Use a Range Parameter in a Report
Topic C: Create a Prompt

Lesson 5: Grouping Report Data
Topic A: Group Report Data
Topic B: Modify a Group Report
Topic C: Group by Using Parameters
Topic D: Create a Parameterized Top N Report

Lesson 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

Lesson 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

Lesson 8: Distributing Data
Topic A: Export Data
Topic B: Create Mailing Labels

From Crystal Reports Part 2:

Lesson 1: Creating Running Totals
Topic A: Create a Running Total Field
Topic B: Modify a Running Total Field
Topic C: Create a Manual Running Total

Lesson 2: Working with Cross-Tabs
Topic A: Create a Cross-Tab Report
Topic B: Format a Cross-Tab Report
Topic C: Create Groups in Cross-Tab Reports

Lesson 3: Adding Subreports
Topic A: Insert a Subreport
Topic B: Edit a Subreport
Topic C: Share Variables

Lesson 4: Creating Drill-Downs in a Report
Topic A: Create a Drill-Down
Topic B: Create Headings for Drill-Down Data

Lesson 5: Using SQL Statements in Report Processing
Topic A: Create a Report Using SQL Queries
Topic B: Summarize Report Data
Topic C: Create Joins Using SQL
Topic D: Create Subqueries
Topic E: Create an SQL Expression Field

Lesson 6: Creating Complex Formulas
Topic A: Work with Loops
Topic B: Work with Arrays

Lesson 7: Adding Charts to Reports
Topic A: Create Charts
Topic B: Create a Chart with Drill-Down
Topic C: Create a Top N Chart
Topic D: Create a Cross-Tab Chart
Topic E: Create Charts for Grouped Data
Topic F: Format a Chart
Topic G: Create a Chart Template

Lesson 8: Enhancing Report Functionality
Topic A: Organize Data Based on a Hierarchy
Topic B: Create a Dynamic Image
Topic C: Create a Report Alert
Topic D: Create a Geographic Map

View outline in Word

GCRZ16

Attend hands-on, instructor-led Crystal Reports On-Demand: Comprehensive (Part 1 & Part 2) training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

Microsoft Gold Partner

Price:$695

Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com