1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Hands-On Crystal Reports

 
Course: 126   Type: Hands-On Training   Duration: 4 Days
 
 

You Will Learn How To

  • Develop reports using Crystal 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 natively, via ODBC and OLE DB
  • Analyze database structures and extract the data you need to meet your reporting needs
  • Deploy reports via HTML to a Web browser or desktop application via Visual Basic and .NET

Course Benefits

With the power of this industry-leading report-writing tool, Crystal Reports users and developers can integrate their organization's data, making sophisticated reports readily available to support critical business decisions. In this hands-on 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 right away.

Who Should Attend

Anyone involved in creating reports from stored data. Experience using Windows and working with a spreadsheet is assumed.

Hands-On Training

You gain hands-on experience using Crystal Reports. Exercises include:
  • Building reports from the ground up
  • Connecting to data sources natively, via OLE DB & ODBC
  • Designing a crosstab and drill-down report
  • Developing a summary report with drill-down capabilities
  • Simplifying information using charts and graphs
  • Adding business logic to your report with the formula language
  • Deploying your report to a Web server for Internet/intranet distribution
  • Integrating reports with Visual Basic

Related Courses

 
Crystal Reports is a registered trademark of Business Objects SA. 		 

Upcoming Dates

Oct 14 - 17, 2008
 Washington, DC (Rockville, MD)
Oct 21 - 24, 2008
 Los Angeles
Oct 21 - 24, 2008
 Ottawa
Oct 21 - 24, 2008
 Washington, DC (Alexandria, VA)
Oct 28 - 31, 2008
 Toronto
Nov 18 - 21, 2008
 Boston (Waltham)
Dec 2 - 5, 2008
 Dallas
Dec 2 - 5, 2008
 New York
Dec 9 - 12, 2008
 Philadelphia
Dec 16 - 19, 2008
 Washington, DC (Rockville, MD)
Jan 6 - 9, 2009
 Chicago (Schaumburg)
Jan 6 - 9, 2009
 Los Angeles
Jan 13 - 16, 2009
 New York
Jan 13 - 16, 2009
 Washington, DC (Alexandria, VA)
Jan 20 - 23, 2009
 Ottawa

For complete schedule, please visit www.learningtree.com
 
http://www.learntree.com/courses/126pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Hands-On Crystal Reports

 
Course: 126   Type: Hands-On Training   Duration: 4 Days
 
 
Course 126 Content
 

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
  • Adding charts and sub reports to a report

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
  • Annotating header and footer fields
  • Designing fields for quality presentations
  • Adding color, borders and pictures
  • 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
  • Optimizing data retrieval

Combining Powerful Report Techniques

Organizing and summarizing reports

  • Sorting user sort control and grouping
  • Grouping with formulas
  • Summary and Rolling Total fields
  • Using Report Alerts

Building advanced reports

  • Embedding linked and unlinked subreports into reports
  • Creating crosstab and drill-down reports
  • Designing dynamic and cascading prompts
  • Multipass reporting, 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 with the Formula Workshop
  • Calling and working with functions
  • Sharing formulas with the Repository

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, Intranets, Visual Basic and .NET

Deploying Crystal Reports

  • Deciding among Push, Pull, Static and Dynamic reports
  • Migrating to production by switching databases
  • Determining when to use the Crystal Reports Server

Publishing reports to a Web site

  • Exporting reports to HTML
  • Publishing to CrystalReports.com

Integrating into custom applications

  • Adding Crystal Reports to Visual Basic and .NET
  • Exploring application development options with Crystal Reports
 
http://www.learntree.com/courses/126pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Hands-On Crystal Reports Tuition

 
Course: 126   Type: Hands-On Training   Duration: 4 Days
 
 

Course Tuition
$ 2,790 Standard Tuition
Tuition with a Savings Plan
$ 1,800 10-Day Pass
$ 1,670 Training Passport
$ 1,700 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,515 Alumni Gold Discount
$ 2,484 Government Discount
 

 

Your Course Tuition Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification
  • FREE participation in College Credit programs (including related exams)
  
 

Tuition Savings Plans

Training Passport
  • 3 courses in 12 months
  • As little as $1,670 per course
  • Savings as much as 40%
  • Only $5,000
Premium Pass
  • 4 courses in 24 months
  • As little as $1,700 per course
  • Save as much as 45%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $990 per course
  • Only $4,500
Training Vouchers
  • Save as much as $990 per course
  • Fully transferable
  • As low as $2,200 per course
Alumni Gold Discount Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $305 on each course you take within the following 12 months. Take just one course each year and you'll be entitled to ongoing discounts...year after year!

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course--and then pay only if you feel the course was well worth the tuition.

Enrolling is Easy and Flexible!

Enroll by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learntree.com/courses/126pf.htm