Crystal Reports Training

Level: Intermediate

Rating: 4.68/5 Based on 75 Reviews

In this hands-on Crystal Reports course, you will learn to create sophisticated reports from the ground up and transform raw data into meaningful information. You will gain the knowledge and skills to link multiple data sources and create effective presentations using Crystal Reports. After this training course, you will return to your organization with a detailed process to help you retrieve and format data, create meaningful reports for widespread distribution, and integrate your reports with a website or application, such as .NET.

Page Sections

You Will Learn How To

Training Solutions

Details & Schedule

FAQs

Related Training

Get Started

Key Features of this Crystal Reports Training:

After-course instructor coaching benefit
Learning Tree end-of-course exam included

You Will Learn How To:

Develop reports to transform data into meaningful information
Create advanced graphical and crosstab reports
Add calculations and program logic with the Formula Workshop
Connect to data sources and extract data to meet reporting needs

Certifications/Credits:

Choose the Training Solution That Best Fits Your Individual Needs or Organizational Goals

LIVE, INSTRUCTOR-LED

In Class & Live, Online Training

After-course instructor coaching benefit
Learning Tree end-of-course exam included
Earn 11 NASBA credits (live, in-class training only)

View Course Details & Schedule

Standard $990

Government $990

RESERVE SEAT

PRODUCT #126

TRAINING AT YOUR SITE

Team Training

Bring this or any training to your organization
Full - scale program development
Delivered when, where, and how you want it
Blended learning models
Tailored content
Expert team coaching

Customize Your Team Training Experience

Save More On Training with FlexVouchers – A Unique Training Savings Account

Our FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.

In Class & Live, Online Training

Timezone

Location

Date

Time Zone Legend:

Eastern Time Zone Central Time Zone

Mountain Time Zone Pacific Time Zone

Note: This course runs for 2 Days *

*Events with the Partial Day Event clock icon run longer than normal but provide the convenience of half-day sessions.

Jan 25 - 26 9:00 AM - 4:30 PM EST Ottawa / Online (AnyWare) Reserve Your Seat
Mar 31 - Apr 1 9:00 AM - 4:30 PM EDT Herndon, VA / Online (AnyWare) Reserve Your Seat
Jul 19 - 20 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare) Reserve Your Seat

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.

Partial Day Event

Learning Tree offers a flexible schedule program. If you cannot attend full day sessions, this option consists of four-hour sessions per day instead of the full-day session.

Crystal Reports Course Information

Recommended Experience
- Should be comfortable using Windows and working with a spreadsheet or word processor
- Experience working with formulas in a spreadsheet program
Which software is being used?
- This course cover the latest version of Crystal Reports 2016 and backward compatible to 2008. Any new changes or additions in later versions will be identified so students will know exactly what is included in their Crystal Reports version.

Crystal Reports Course Outline

Overview of Crystal Reports
- Formatting and summarizing data
- Filtering, sorting and grouping data
- Customizing reports with business logic
- Connecting to SQL Server, Oracle and Access databases
The Crystal Report Writer
Writing a basic report
- Selecting a format
- Adding text and fields
- Connecting to remote data sources
- Configuring the reporting environment
Formatting and styling
- Tailoring sections within a report
- Designing fields for quality presentations
- Highlighting data with Highlight Expert
Linking Crystal Reports to Data
Connecting to popular data sources
- SQL Server
- Oracle
- Access
- Web logs
- XML
- Reporting from stored procedures and views
Establishing data connections
- Creating a connectivity checklist
- Configuring ODBC and OLE DB
- Integrating SQL commands in a report
Interpreting Structures and Retrieving Data
Navigating complex data
- Deciphering data structures
- Identifying data relationships
Gathering the right data
- Merging data from multiple tables
- Building business queries
Combining Powerful Report Techniques
Organizing and summarizing reports
- Sorting user sort control and grouping
- Summary and Rolling Total fields
Building advanced reports
- Embedding linked and unlinked subreports into reports
- Creating crosstab and drill-down reports
- Designing dynamic and cascading prompts
- Hyperlinking Reports and Multilingual Reports
- Achieving reusability with templates
Visualizing complex data
- Simplifying data with charts and graphs
- Organizing fields into sections
- Adding, merging, suppressing sections
Programming Data Functionality
Coding in formula language
- Working with variables and operators
- Deciphering formula syntax
- Adding and modifying formulas
- Calling and working with functions
Writing effective formulas
- Building if/then/else statements
- Converting and comparing data
- Debugging the code
- Employing the Formula Workshop
Converting to Basic Syntax
- Writing formulas with Basic Syntax
- Laying a foundation for complex reporting logic

Team Training