Type to search LearningTree.com

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

Business Intelligence Training









Preferred method of contact?

Crystal Reports

COURSE TYPE

Practitioner

Course Number

126

Duration

4 Days

Enroll

About This Course: You gain extensive experience using Crystal Reports to connect to databases, retrieve raw data, format data, and create and present reports for widespread distribution. You return to your organization with a detailed process to help you connect to data sources and create useful reports.

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

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Feb 21 - 24 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Feb 28 - Mar 3 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Mar 21 - 24 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Apr 18 - 21 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

May 9 - 12 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Aug 15 - 18 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Aug 29 - Sep 1 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Sep 5 - 8 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Sep 19 - 22 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Guaranteed to Run

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here

Tuition

Standard

$2990

Government

$2659

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 course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Questions

Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

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)
  • Make progress toward one or more Learning Tree Specialist & Expert Certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

Earn 23 Credits from NASBA

This course qualifies for 23 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

“The hands-on experience in the Crystal Reports class significantly increased my productivity in working with the product. I am no longer clicking and hunting -- it's like a light bulb went on!”

- F. Tucker, IT Manager
American Society of Appraisers

Prev
Next
s