Discover Classes. Earn Rewards.
Crystal Reports is unfortunately unavailable

Thankfully we have 9 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)
Share:
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
Taking this class for work? Get exclusive perks & discounts for free.

9 Top Choices

Introduction to Google Analytics

at General Assembly - Penn Quarter 509 7th St NW 3rd Fl, Washington, District of Columbia 20004

Google Analytics is an incredibly robust, free tool for measuring web traffic data. In this workshop, you’ll get to know the basics of using Google Analytics to track and evaluate performance and draw insights to improve your business.  Starting with basic terminology and key metrics, you’ll build a foundation of knowledge before diving deeper...

Tuesday Feb 18th, 6:30pm - 9:30pm

Google Analytics Bootcamp

at General Assembly - Penn Quarter 509 7th St NW 3rd Fl, Washington, District of Columbia 20004

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

Saturday Feb 8th, 10am - 5pm

Crystal Reports Designer 1

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

This two day interactive workshop was designed for new users of Crystal Reports. Some of the topics covered include a review of the software features, report design and the creation of presentation quality reports. The course incorporates a number of hands on exercises to reinforce the learning process. Crystal Reports Versions That Can Attend: 2016,...

Thursday Feb 13th, 10am - 5pm

  (2 sessions)
$1,240

2 sessions

Crystal Reports Designer 2

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

This two-day workshop is designed to enhance your basic report writing skills and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice. In addition, you will cover professional design, techniques, sub-reporting and advanced formulas....

Monday Feb 17th, 10am - 5pm

  (2 sessions)
$1,240

2 sessions

Creating Dashboards with SharePoint

at Learning Tree International - Alexandria 1925 Ballenger Ave, Washington, District of Columbia 22314

Business Intelligence (BI) is the process of exposing enterprise data that enables management to make informed business decisions. In this training course, you gain the knowledge and skills to leverage built-in SharePoint BI capabilities, and build reporting dashboards in SharePoint Server — allowing your organization to implement and visualize enterprise...

Tuesday Feb 18th, 9am - 4:30pm

  (4 sessions)
$2,990

4 sessions

Google Analytics

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

This course covers Google Analytics’ current features, paying special attention to new metrics, support such as Intelligence Questions, and the new Global Site Tag tracking code. The updated course discusses the characteristics of the new code as well as the code's impact on page and link tracking, Ecommerce reporting, and event creation and transmission...

Monday Mar 2nd, 10am - 5pm

  (3 sessions)
$1,715

3 sessions

Tableau Desktop: Basic

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

Learn how to create effective data visualizations with Tableau and unlock a smarter approach to business analytics. 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...

Monday Mar 9th, 10am - 5pm

  (2 sessions)
$1,240

2 sessions

Tableau Desktop: Advanced

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

Master the intricacies of Tableau to create effective data visualizations. Tableau has emerged as one of the most popular Business Intelligence solutions in recent times, thanks to its powerful and interactive data visualization capabilities. This course will empower you to become a master in Tableau by exploiting the many new features introduced in...

Thursday Mar 12th, 10am - 5pm

  (2 sessions)
$1,240

2 sessions

Tableau Desktop: Business Intelligence

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

Create powerful, effective visualizations to help analyze your data with Tableau 10 by your side. Tableau is a software tool that can speed up data analysis through its rich visualization capabilities, and help uncover insights for better and smarter decision making. This course is for the business, technology, data and analytics professionals who...

Wednesday Mar 18th, 10am - 5pm

  (2 sessions)
$1,240

2 sessions

Loading...