Preferred method of contact:

Crystal Reports

COURSE TYPE

Intermediate

Course Number

126

Duration

4 Days

PDF Add to WishList

Gain the knowledge and skills to link multiple data sources and create effective presentations using Crystal Reports. With 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
  • Deploy reports via HTML, Visual Basic, and .NET

Important 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

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
  • Deploying Reports to the Internet, Visual Basic and .NET

Deploying Crystal Reports

  • Deciding among Push, Pull, Static and Dynamic reports
  • Migrating to production by switching databases

Publishing reports to a website and integrating into custom applications

  • Exploring development options
  • Exporting reports to PDF, Excel, Word and HTML
  • Adding Crystal Reports to a .NET application
Show complete outline
Show Less

Convenient Ways to Attend This Instructor-Led Course

Hassle-Free Enrolment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.

In the Classroom

Live, Online

Private Team Training

In the Classroom — OR — Live, Online

Tuition — Standard: $3285   Government: $2890

Dec 19 - 22 (4 Days)
9:00 AM - 4:30 PM EST
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Jan 16 - 19 (4 Days)
9:00 AM - 4:30 PM EST
Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Feb 27 - Mar 2 (4 Days)
9:00 AM - 4:30 PM EST
Toronto / Online (AnyWare) Toronto / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

May 15 - 18 (4 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Jun 19 - 22 (4 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Aug 14 - 17 (4 Days)
9:00 AM - 4:30 PM EDT
Toronto / Online (AnyWare) Toronto / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Sep 11 - 14 (4 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Guaranteed to Run

Show all dates
Show fewer dates

Private Team Training

Enroling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.

For details, call 1-888-843-8733 or Click here »

Tuition

Standard

Government

In Classroom or
Online

Standard

$3285

Government

$2890

Private Team Training

Contact Us »

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

Free Course Exam
You can take your Learning Tree course exam on the last day of your course or online at any time after class and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm

FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)

“After taking the Crystal Reports course, I finally understood the parent/child link table relationships, which are critical in my current position."

- S. Dickens, Software Engineer
Praxis Engineering Technology

Prev
Next
Chat Now

Please Choose a Language

Canada - English

Canada - Français