Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.

This Advanced Crystal Reports 2011 Tutorial Video will show you how to achieve new breakthroughs in impressive, data-driven communication. In a hands-on series of training video lessons, expert Lauri Matson helps you become even more capable and efficient with this powerful business software. As an advanced course, this Crystal Reports tutorial does require a basic proficiency in the program, although there will also be periodic lessons of review. If you've already watched the beginners Crystal Reports 2011 tutorial, you'll be in a perfect position to learn advanced skills such as interaction with SQL, formula design and deployment, creating Cross-Tab reports (known as pivot tables in Excel), formatting complex charts and more. Just like the beginners' series, the advanced training is designed for maximum flexibility, with modular lessons that can easily be tailored to your schedule and learning needs. Intuitive playback controls allow you to pause, rewind or skip through the training at any point, ensuring that you are never left behind or stuck in lessons you don't want to see. This complete Advanced Crystal Reports Tutorial Video can now be ordered on CD / DVD or viewed streaming online through the video subscriber option.

Associated Tutorials: Beginners Crystal Reports | MySQL 5 Development | Microsoft SQL Server 2008 Development | Microsoft Access 2010 | MySQL 5 Development Part 2

Advanced Crystal Reports Tutorial CD / DVD

When you order this Advanced Crystal Reports Video Tutorial CD You'll Receive...
Over 7.5 hours of high quality video-based training that walks you through the program in easy to follow stages.

A training video that focuses on real life examples and teaches you
real life skills. These tutorials are structured to increase not only your skills but also your earning potential.

With this Training Video you will...
Learn Advanced Crystal Reports from a leading expert and quickly master the skills required to work in a commercial environment.

Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike

Customer Comments
" a++++ after learning how to improve my photos and images my eBay sales have gone way up...thanks! "Matthew Quinn, New York

Advanced Crystal Reports Tutorial CD / DVD

Create the best self-paced learning environment right on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Topics Covered on this Training Course

This Training is 7.5 Hours in Duration and Covers 100 Lessons.
Intro to Crystal Advanced Essentials of Database Reporting with Crystal Understanding Extended Database Elements
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
How to View Data in Crystal
  • Crystal Viewing and Query Options
  • Using Crystal Options with Data
  • Utilizing Crystal Commands Versus Expressions
Crystal and SQL Options
  • Using SQL Command Select
  • Working with More than One Table
  • Using Order By, Where, and Alias Commands
Review of Formulas
  • Formula Fundamentals
  • Formula Modification
  • How to Reference Fields
Understanding Formula Structure
  • Understanding Crystal Versus Basic Syntax
  • Additional Syntax Information
  • Working with a Variable
  • Getting Assistance with Syntax
  • Placing Formulas in Crystal
Working with Formula in Depth
  • Working with the Select Expression
  • Formatting Date Fields and Formulae
  • How to Extract Data from a Field
  • A Sample Extraction
  • A Look at Some Basic Formulae
Overview of SQL
  • Understanding SQL Expressions
  • Understanding the Use of the Select Command
  • A Sample Command
  • Review of Basic Expressions
Utilizing Running Totals
  • Introduction to Running Totals
  • Working with Totals and Groups
  • Getting Totals Manually
  • Working with Conditional Totals
  • How to Reset within a Formula
Creating Customized Functions
  • Overview of Custom Functions
  • How to Build a Function
  • Understanding Function Properties
  • Sample Functions
Understanding Crystal Performance
  • Indexing Performance Video One
  • Indexing Performance Video Two
  • Elements of Performance Video One
  • Elements of Performance Video Two
  • Streamlining Crystal for Web Output
Designing Your Reports
  • The Planning Stage
  • Understanding Data Implications
  • Working with Adventureworks Schematics
Review of Cross-Tab Reports
  • Working with a Cross-Tab
  • How to Format a Cross-Tab by Design
  • How to Format a Cross-Tab in Preview
  • Elements of Cross-Tab Design
  • Cross-Tab Terminology
  • Sample Cross-Tab Report
Crystal Database Subreports
  • Including a Subreport
  • Subreport Formatting
  • Viewing Subreports as Charts
  • Utilizing OnDemand and Unrelated SubReports
Working with Database Time and Variables
  • Working with Date and Time in Fields
  • Changing Date Format to Text
  • Calculating Hours
Working with Groups
  • Overview of Groups
  • Working with Groups on a Formula Field
  • Applying a Hierarchy to a Group
  • Grouping with More than One Section
Understanding Database Parameters
  • Understanding the Basic Parameter
  • Working with Multiple Values
  • Applying SQL Commands
  • Working with Dynamic Values
  • Using Parameters and Conditional Formats
Working with Charts
  • How to Create a Report
  • Utilizing the Crystal Wizard
  • Understanding Chart Formatting
  • Choosing a Chart Type
  • Understanding Trendlines
  • Working with Conditional Formatting
  • Inserting a Chart in a Group Header
Understanding Mapping
  • Constructing a Map
  • Map Format Options
  • How to Map Groups Video One
  • How to Map Groups Video Two
Miscellaneous Tips
  • Using Mailing Labels
  • Using Form Letters
  • Making Alerts
  • Using Alerts
  • Including Tooltips
  • Working with Conditional Formatting
  • Using Alternate Row Formatting
Wrap-Up
  • Working with the Viewer
  • Using Dashboards and Excelsius
  • Getting Help
  • Conclusion
End Notes
  • Tutor Bio

Select Playback Format for the Free Demos:

Quicktime
Flash

Did You Know ?

We offer more than 700 video-based courses, and you can watch the first three chapters of every listed course for FREE with no obligation to buy.

About this Advanced Crystal Reports Training CD

Title Advanced Crystal Reports
Tutor Lauri Matson
Other tutorials by Lauri Matson
Videos 100 Lessons- Video run time: 7.5 hours
Compatibility Vista, XP, Windows 7, Mac OSX
Released 2011
Work files Yes
Availability Immediate Dispatch
Price US / Canadian Sales Only $99.95
Closed Captions Closed Captions are available on this title
408 in stock
Purchase Orders from Schools, Colleges, Government and Military Accepted

Mutli User Training Options

This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.

10 Multi User $500

Not Sure Which Titles to Buy? Unlimited Access to all -$30

Need to learn more than one topic? Get Unlimited Access to all the courses listed on this site for just $30!
Unlimited Access to over 70,000+ Training Videos

Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract .
No minimum period.
No commitment on your part.

Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.

Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits

Why Is This Training Format So Effective?

  • Learn Advanced Crystal Reports from an accredited expert in days.

Want to hear what our customers say about our products?

Prove your Knowledge - Free Certificate

Prove Your Credentials!
Free Certificate.