Crystal Reports is unfortunately unavailable

Thankfully we have 32 other Business Intelligence Classes for you to choose from. Check our top choices below or see all classes for more options.

Questions about this class?
Get help now from a knowledge expert!

Crystal Reports

at Learning Tree International - Rockville

Course Details
Price:
$990
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Rockville
1801 Rockville Pike 2nd Fl
At Rollins Ave
Rockville, Maryland 20852
(Map)
Important:
Course 126
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 16

What you'll learn in this business intelligence training:

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.

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

Recommended Prerequisite:

  • Should be comfortable using Windows and working with a spreadsheet or word processor
  • Experience working with formulas in a spreadsheet program

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

Still have questions? Ask the community.

Refund Policy
If a customer would like to cancel or transfer their course, they must notify Coursehorse prior to two weeks before the start date of the course or within seven days of registration. On-Demand Courses cannot be cancelled once purchased and are not eligible for refund.

If a customer transfers to another course prior to two weeks before the start date or within seven days of registration of the course in which originally enrolled, 100% of any prepaid course tuition will be applied toward the course tuition for the subsequent course.

If a customer needs to cancel an enrollment two weeks prior to the start of the class or within seven days of registration, we will refund 100% of any prepaid course tuition for that enrollment.

If a customer does need to transfer or cancel a course within two weeks of the start date of the course or after seven days from the date of registration, a fee equal to 50% of the price of the course will be assessed for any standard attendances. Attendances associated with a Learning Tree program will be assessed a $500 fee. Training Passports, Training Vouchers and Pay-As-You-Learn Vouchers cannot be used after their expiration dates, and a course cancellation or transfer by the customer will not extend a Training Passport, Training Voucher Pack or Pay-As-You-Learn Voucher Pack expiration date.

Map

Google Map

Learning Tree International

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 9900 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

School: Learning Tree International

Learning Tree International

Established in 1974, Learning Tree International is a leading provider of IT training and management training to business and government organizations worldwide. In addition, Learning Tree provides IT Workforce Optimization Solutions – a modern approach that improves the adoption of skills, and accelerates...

Read more about Learning Tree International

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified DC educator.

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

32 Top Choices

Google Analytics Bootcamp (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Houston, Texas 00000

Google Analytics is the most used web analytics tool in the world. Are you harnessing its power? Understanding how Google Analytics works–beyond the basic features–gives you the ability to unlock powerful insights. In this bootcamp, we'll explore how to set concrete KPIs and track success through Google Analytics. We'll then dive into how to...

Tuesday Jan 26th, 11am - 6pm Central Time

Google Analytics Bootcamp w/ Freddie Blicher

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Chicago, Illinois 00000

The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring the COVID-19 situation very carefully and are adjusting delivery of our programs. Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online...

Tuesday Jan 26th, 11am - 6pm Central Time

Google Analytics: Key Concepts and Quick Wins

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Chicago, Illinois 00000

Google Analytics for Beginners: Key Concepts and Quick Wins Everyone wants to grow their business and make their websites successful. But how do you know if you are making progress to your goals? And how do you know what marketing activities are the most efficient and cost effective to pursue? That is the job of analytics and Google Analytics in...

Saturday Jan 30th, 12pm - 3pm Central Time

Google Analytics for Beginner:Key Concepts & Quick Wins

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online, Online, California 00000

Everyone wants to grow their business and make their websites successful. But how do you know if you are making progress to your goals? And how do you know what marketing activities are the most efficient and cost effective to pursue? That is the job of analytics and Google Analytics in particular. Without analytics, strategies, goals and marketing...

Saturday Jan 30th, 10am - 1pm Pacific Time

Google Analytics for Beginner:Key Concepts & Quick Wins

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, San Francisco, California 00000

Everyone wants to grow their business and make their websites successful. But how do you know if you are making progress to your goals? And how do you know what marketing activities are the most efficient and cost effective to pursue? That is the job of analytics and Google Analytics in particular. Without analytics, strategies, goals and marketing...

Saturday Jan 30th, 10am - 1pm Pacific Time

Google Analytics for Beginner:Key Concepts & Quick Wins

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Seattle, Washington 00000

Everyone wants to grow their business and make their websites successful. But how do you know if you are making progress to your goals? And how do you know what marketing activities are the most efficient and cost effective to pursue? That is the job of analytics and Google Analytics in particular. Without analytics, strategies, goals and marketing...

Saturday Jan 30th, 10am - 1pm Pacific Time

Google Analytics: Key Concepts and Quick Wins

This class is temporarily being offered remotely.

at General Assembly - Online Online Classroom, Los Angeles, California 00000

Everyone wants to grow their business and make their websites successful. But how do you know if you are making progress to your goals? And how do you know what marketing activities are the most efficient and cost effective to pursue? That is the job of analytics and Google Analytics in particular. Without analytics, strategies, goals and marketing...

Saturday Jan 30th, 10am - 1pm Pacific Time

Google Analytics for Beginner:Key Concepts & Quick Wins

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online , Denver, Colorado 00000

Everyone wants to grow their business and make their websites successful. But how do you know if you are making progress to your goals? And how do you know what marketing activities are the most efficient and cost effective to pursue? That is the job of analytics and Google Analytics in particular. Without analytics, strategies, goals and marketing...

Saturday Jan 30th, 11am - 2pm Mountain Time

Google Analytics for Beginner:Key Concepts & Quick Wins

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Houston, Texas 00000

Everyone wants to grow their business and make their websites successful. But how do you know if you are making progress to your goals? And how do you know what marketing activities are the most efficient and cost effective to pursue? That is the job of analytics and Google Analytics in particular. Without analytics, strategies, goals and marketing...

Saturday Jan 30th, 12pm - 3pm Central Time

Google Analytics for Beginners: Key Concepts

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

Google Analytics for Beginners: Key Concepts & Quick Wins Everyone wants to grow their business and make their websites successful. But how do you know if you are making progress to your goals? And how do you know what marketing activities are the most efficient and cost effective to pursue? That is the job of analytics and Google Analytics in...

Saturday Jan 30th, 1pm - 4pm Eastern Time

Google Analytics for Beginner:Key Concepts & Quick Wins

This class is temporarily being offered remotely.

at General Assembly - Online GA Washington D.C. (Remote Online), Washington, District of Columbia 00000

Everyone wants to grow their business and make their websites successful. But how do you know if you are making progress to your goals? And how do you know what marketing activities are the most efficient and cost effective to pursue? That is the job of analytics and Google Analytics in particular. Without analytics, strategies, goals and marketing...

Saturday Jan 30th, 1pm - 4pm Eastern Time

Alteryx Concepts - Level 1

This class is temporarily being offered remotely.

at ONLC Training Centers - Online Virtual Classroom, New York, New York 00000

This two-day instructor-led course is designed to give students a hands-on introduction to Alteryx Designer, an all-in-one self-service Business Intelligence solution for acquiring, transforming, visualizing and interacting with data. The course doesn’t assume any previous experience with Alteryx or any other Business Intelligence technology. By...

Monday Feb 1st, 10am - 4:45pm Eastern Time

  (2 sessions)
$985

2 sessions

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, San Francisco, California 00000

Google Analytics is the most used web analytics tool in the world. Are you harnessing its power? Understanding how Google Analytics works–beyond the basic features–gives you the ability to unlock powerful insights. In this bootcamp, we'll explore how to set concrete KPIs and track success through Google Analytics. We'll then dive into how to setup...

Wednesday Feb 3rd, 9am - 4pm Pacific Time

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Classroom, Los Angeles, California 00000

Google Analytics is the most used web analytics tool in the world. Are you harnessing its power? Understanding how Google Analytics works–beyond the basic features–gives you the ability to unlock powerful insights. In this bootcamp, we'll explore how to set concrete KPIs and track success through Google Analytics. We'll then dive into how to...

Wednesday Feb 3rd, 9am - 4pm Pacific Time

Google Analytics Bootcamp (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online , Denver, Colorado 00000

Google Analytics is the most used web analytics tool in the world. Are you harnessing its power? Understanding how Google Analytics works–beyond the basic features–gives you the ability to unlock powerful insights. In this bootcamp, we'll explore how to set concrete KPIs and track success through Google Analytics. We'll then dive into how to...

Wednesday Feb 3rd, 10am - 5pm Mountain Time

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Atlanta, Georgia 00000

Google Analytics is the most used web analytics tool in the world. Are you harnessing its power? Understanding how Google Analytics works–beyond the basic features–gives you the ability to unlock powerful insights. In this bootcamp, we'll explore how to set concrete KPIs and track success through Google Analytics. We'll then dive into how to setup...

Tuesday Jan 26th, 12pm - 7pm Eastern Time

Google Analytics Bootcamp (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

Google Analytics is the most used web analytics tool in the world. Are you harnessing its power? Understanding how Google Analytics works–beyond the basic features–gives you the ability to unlock powerful insights. In this bootcamp, we'll explore how to set concrete KPIs and track success through Google Analytics. We'll then dive into how to setup...

Tuesday Jan 26th, 12pm - 7pm Eastern Time

Tableau Desktop Level 1: Introduction for Novice Users

This class is temporarily being offered remotely.

at ONLC Training Centers - Online Virtual Classroom, New York, New York 00000

Tableau has for some time been one of the most popular Business Intelligence and data visualization tools available. Why? Because, quite simply, it’s a tool that’s responsive to the needs of modern businesses. But it’s most effective when you know how to get what you want from it – it might make your business intelligent, but it isn’t going...

Monday Feb 8th, 10am - 4:45pm Eastern Time

  (4 sessions)
$1,995

4 sessions

Crystal Reports Part 2

This class is temporarily being offered remotely.

at ONLC Training Centers - Online Virtual Classroom, New York, New York 00000

Until now, you have used Crystal Reports to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, you will create complex reports and data sources using the tools in Crystal Reports. You will not only create more sophisticated reports including subreports...

Thursday Feb 11th, 10am - 4:45pm Eastern Time

  (2 sessions)
$895

2 sessions

Data Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online, Online, California 00000

This single day bootcamp will run through the analytical workflow -- from collecting, cleaning, analyzing and presenting insights from public data sets. We will introduce important tools used in this process such as Google Sheets and Tableau. Goals: Introduce concepts and practice using and managing data Transform data for descriptive analytics...

Saturday Feb 13th, 10am - 5pm Pacific Time