PRODUCT INFO
 
Shipping Information
Product Guarantee
Testimonials
 
MAIN LINKS
 
Training Categories
New Titles
In Development
Free Online Demos
Multi User Training CDs
Contact Us
 


This Week's Special Offer

NEW TITLE DISCOUNT!
Adobe Photoshop Lightroom 4 Tutorial


Quicktime is required for the movies,
click here to download if needed.

Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.

Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials. Please do not hesitate to contact us for download help.


- See right for full details on these Crystal Reports 2008 Tutorials

- See far right to purchase this CBT Crystal Reports Training DVD/CD

Crystal Reports 2008 Training Bundle
Beginner to Advanced

SPECIAL OFFER: 30% DISCOUNT - ENDS SOON!

 Professionally created, self-study video training.

About this Tutorialshow details
This bundle includes:
Beginners Crystal Reports 2008 Tutorial - 7.5 hrs / 152 Lessons
Advanced Crystal Reports 2008 Tutorial - 6.5 hrs / 85 Lessons

From the absolute basics to the advanced and powerful features, these Crystal Reports training videos will teach you all you need to need to know and more! Presented by expert tutor Guy Vaccaro, he uses easy-to-follow video training movies to help break down and demonstrate the complexities of Crystal Reports 2008, helping you to create incredibly complex and beautiful reports and help you to become comfortable with the advanced uses of this powerful reporting software. In over 14 hours of professionally created video training, the tuition includes a tour of the interface, lessons on importing data into CR 2008, setting up your report, how to format your report, knowing your way round your report, formula fields, charting, lessons on Sub Reports and so much more. You can view the full 237 training movies below and start learning right away, click any of the blue linked lessons to sample FREE Crystal Reports training videos...
Learn this Software - See below for FREE TUTORIALS
LATER VERSION AVAILABLE
We also have the
Crystal Reports 2011 Tutorial

TWO COURSES AT A GREAT PRICE!

Each Course on 1 or 2 CDs or Download
For Mac and PC


FREE Shipping on ALL Orders

Crystal Reports Training
2008 Bundle Info
Tutor: Guy Vaccaro
Duration: 14 hrs / 237 video lessons
Cost for UK: £114.95 + VAT
(Separate selling price £159.90 + VAT)
Cost for EU: €122.14 + VAT
(Separate selling price €169.90 + VAT)
Cost for US & Canada: $179.65
(Separate selling price $249.90)
*no further discounts can be applied to value bundles
Product Code: 01619
DELIVERY DETAILS
Downloads: Training downloadable when payment processed (by next working day)
CDs: Please allow 2-3 days for UK, Europe US & Canada, 3-5 days rest of world

IN STOCK

- All CDs Shipped Carriage FREE -
Compatibility: MS Windows 7, Vista, XP, 2000, 98, NT, Mac OS X, OS 9
 

DON'T TAKE OUR WORD FOR IT, SEE OUR CUSTOMER TESTIMONIALS


Benefits of this Software Training
  Tuition by expert tutors.
  Narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter.
  Learning is fast as the trainers provide a beginners guide using simplistic terms and minimal jargon.
  Personal Tutoring - Step-by-step video training from your own desktop. Delivered via best selling DVD/CD training or online tuition.
  The tutor transfers knowledge to you quickly and effectively.
  All the concepts of each application are explained clearly and precisely.
  Every course works on PC and Mac.
  Alternative to a boring book or manual and expensive training courses, seminars, workshops & classes.
  Jump to and from lessons - learn at your own pace.
  The visual and practical nature shortens the learning curve compared to standard training manuals and for dummies books.
Customer Testimonials
Associated Training CDs:
Complete Range of Microsoft Access Tutorials | Microsoft Office 2010 Production Bundle | Complete range of Microsoft Office 2007 Tutorials | Crystal Reports XI | Beginners Drupal 7 | Complete Range of OS X Mac Snow Leopard Tutorials | Complete Range of Crystal Reports Tutorials
 
CD CONTENTS & FREE VIDEO TUTORIALS
Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left

BEGINNERS SAMPLES VIDEOS

Filtering the Data by Dates
Creating a Drilldown Report in Crystal
Using Parameter Fields with Wild Cards
String Manipulation Formulas in Action
Calculating Age with Crystal Reports
DateTime to Date Format to Improve Parameters
Improve Headings in Drilldowns Using Section Expert
Visual Linking in Crystal Reports
Link types and their Effects when Used

ADVANCED SAMPLE VIDEOS

What Will I Be Able To Do At The End Of This Course
Creating A Report From Scratch
Adding And Linking Additional Database Tables
Creating A Formula Field
Sorting Data Within A Report
Grouping Reports
Adding Summary Functions
Filtering Data In The Report
Swapping The Data-source Of A Report
Using The Highlighting Expert
Changing The Order That Conditions Are Met
Removing Highlighting Expert Conditions
Applying ON/OFF Conditional Formatting
Removing Conditional ON/OFF Formatting
Font Color Controlled By A Condition
Font Style Controlled By A Condition
Removing Or Disabling Conditional Formatting
Clever Conditional Format Alternating Page Numbers
Clever Conditional Format Banded Report

We hope you enjoyed the FREE lessons. To view the complete contents, including ALL the lessons below & above, please purchase the course via CD or Download

BEGINNERS TO INTERMEDIATE CONTENTS

Getting Started
What To Expect From Crystal Reports
Opening And Viewing Different Crystal Report Types
Tour Of The Crystal Reports Interface
Crystal Reports Toolbars
What Will I Be Able To Do?

Setting Up A New Report
Starting The Report Creation Process
Setting The Page Size/Orientation For The Report
Making A Connection To An Access Database
Making A Connection To An Excel File
Making A Connection To A SQL Server Database
Selecting The Correct Tables/Views
The Sections Of A Report
Adding Fields To The Report
Removing Fields From A Report
Field Masks And Column Header Control
Browsing The Data Before Insertion
Previewing The Report For The First Time
Refreshing The Data
Saving The Report
Saving The Report With The Data
Creating A New Report - The Whole Process
Setting Up A User DSN
Changing A Reports Data Source

Report Navigation
Paging Through The Report
Searching For Text Within The Report
Group Navigation
Changing The Zoom In Preview And Design Mode

Formatting The Report
Selecting Objects For Formatting Or Resizing
Moving Objects
Resizing Objects
Using The Guides
Using The Grid
Changing The Font Style, Size And Colour - Lesson 1
Changing The Font Style, Size And Colour - Lesson 2
Adding A Colour Border Or Background To Controls
Adding A Hyperlink To A Control
Changing The Paragraph Settings
Number Formatting For Numerical Data Fields
Currency Formatting For Money Data Fields
Date Formatting For Date Data Fields
Using The Format Painter
Aligning And Resizing Multiple Controls On A Report
Setting Default Formatting For Reports
Editing The Layout Default Options

Using The Special Data Fields
Adding Data Date And Data Time Fields
Using The Print Date And Print Time Fields
Inserting Page Numbering
Adding The File Path To The Page Footer
Overview Of The Remaining Special Fields

Adding Non Data Items To A Report
Inserting And Editing Text Objects
Format Options For A Text Box
Adding Labels To Special Fields
Adding A Horizontal Line
Adding A Vertical Line
Formatting A Line
Controlling A Lines Behaviour
Controlling A Lines Position
Adding A Box
Adding A Box That Crosses Section Boundaries
Formatting A Box
Controlling A Box's Behaviour
Controlling The Size And Position Of A Box
Adding A Company Logo Or Other Image
Removing A Non Data Item

Sorting Data In A Report
How To Sort By A Field On The Report
Sorting By More Than One Field
Sorting By Data Fields Not Visible On The Report
Removing Or Changing The Sort Criteria

Filtering The Data That A Report Is Using
The Basics Of Filtering The Data
Filtering A Field By Existing Values
Filtering A Field By More Than One Value
Filtering The Data By Dates
Filtering Numeric Fields
Filtering Field Criteria Using And
Filtering Field Criteria Using Or
Editing Filters With The Select Expert
Removing Filters From The Report
Other Text Data Field Filter Options
Filtering For Nulls
Using A Wildcard In Filter Criteria

Reporting By Groups
Understanding Grouping
How To Add A Group
Group Labels And Headings
Creating A Multiple Level Group
Removing A Group
Changing The Group Sort Order
Changing The Group Name That Is Displayed
Group Preview Options
Utilizing The Group Tree Navigation Panel
Specifying Your Own Groups
Swapping The Data Field For A Group

Summarizing Data
Insert A Grand Total Field
Insert A Sub Total Field
Moving Summary Fields Within The Report
Displaying Sub Totals As A Percentage Of Grand Totals
Summary Fields Using Average, Min Or Max
Creating A Summary Report By Hiding Details
Creating A Drilldown Report
Refreshing A Drilldown Report
Sorting A Group With Summary Fields
Using Top N To Filter Summary Data
Creating A Top 10 List Of Products

Using Parameters In Reports
The Benefits Of Using Parameters
How To Add A Free Text Parameter Field
Using A String Parameter To Filter Data Records
Using A Numeric Parameter To Filter Data Records
Using A Date Parameter To Filter Data Records
Using A Parameter Field With Wildcards
Creating And Using A Pick List Parameter Field
Creating A Dynamic Pick List
Deleting A Parameter Field
Controlling The Request Order For Parameters
The Parameter View Panel

Formula Fields
How To Create Your Own Fields
A Basic Formula To Enhance The Report
Altering Or Renaming A Formula Field
Deleting A Formula
Creating A Formula To Concatenate - Lesson 1
Creating A Formula To Concatenate - Lesson 2
String Manipulation Formulas In Action
Date Formulas At Their Best
Calculating Age With Crystal Reports
Using Formula Fields In The Sort Expert And The Select Expert
Using Formula Fields While Grouping
Making The Formula Field Work With If And Else
Converting Datetime To Date Format To Improve Parameters
Creating An Address Formula With Carriage Returns

Section Formatting
The Report Header And Report Footer Options
Exploring The Formatting Options Of The Page Header And Footer
The Details Section Expert
How To Add A Watermark To A Report
Improving Headings In Drilldowns Using The Section Expert

The Standard Report Wizard
The Steps Involved In The Standard Report Wizard
The Report Template Expert

Data Table Linking
Quick Overview Of Relational Databases
Visual Linking In Crystal Reports
How To Identify Key Fields
Link Types And Their Effects When Used
Removing Links And Tables From The Report

Distributing The Report
Choosing Your Export Format
Export Directly To An Email
Export Directly To Microsoft Excel
Other Export Destinations

The Workbench
Opening The Workbench
Adding Projects To The Workbench
Managing Your Reports Using The Workbench
Removing Reports From The Workbench

Credits And Beyond
About The Trainer
Using The Files Included With This Course
Further Practice - Lesson 1
Further Practice - Lesson 2
What's Next?
CR 2008 Tutorial Wrap Up

ADVANCED TRAINING CONTENTS

Before We Start
What Will I Be Able To Do At The End Of This Course
Using The Files Included With This Course
Installing The SQL Server Sample Databases
About The Tutor

Getting Up To Speed
Creating A Report From Scratch
Adding And Linking Additional Database Tables
Creating A Formula Field
Sorting Data Within A Report
Grouping Reports
Adding Summary Functions
Filtering Data In The Report
Swapping The Data-source Of A Report

Conditional Formatting
Using The Highlighting Expert
Changing The Order That Conditions Are Met
Removing Highlighting Expert Conditions
Applying ON/OFF Conditional Formatting
Removing Conditional ON/OFF Formatting
Font Color Controlled By A Condition
Font Style Controlled By A Condition
Removing Or Disabling Conditional Formatting
Clever Conditional Formatting Alternating Page NOs
Clever Conditional Formatting Banded Report

Advanced Formulas Using Variables
Declaring Variables To Use In Reports
Understanding The Multiple Pass Report Generation
Making Use Of Multi-Pass In A Report
Using And Outputting Multiple Variables At Once
Using Variables In Multiple Formulas And Locations
Creating And Using User Defined Functions

SQL And Commands
Standard Query Language (SQL)
Defining Your Own SQL As The Data Source
Adding Parameters To Your Own SQL Statement

Parameter Fields
Creating A Parameter Field And Using It To Filter Data
Parameter Fields To Customize Formatting
Letting The User Change The Color Of Banded Reports
Parameter Controlled Sort Order
Making Use Of Masks In Parameters

Report Alerts
Adding An Alert To A Report
Triggering A Report Alert
Viewing Record Sets Created By Alerts
Add A Formula To Generate The Alert Message
Using A Parameter Value With A Report Alert

Multiple Sections
Inserting Extra Sections By Dividing Existing Sections
Deleting And Merging Sections
Splitting Existing Content Between Sections
Moving A Sections Position In A Report
Uses For Multiple Page Header Footer Sections
Multiple Sections Can Provide Column Headings In Drilldown Reports
Adding Continued To Page Heading When Required

Sub Reports
What Is A Sub Report
Creating And Importing An Unlinked Sub Report
Create And Insert A Linked Sub Report
On Demand Sub Reports
Hiding Sub Reports That Contain No Data
Dealing With Overlapping Sub Reports
Methods For Updating Changes Made To The Sub Report
Pass Data Between Sub And Main Report Using Variables

Cross Tabs
Adding A Cross Tab To A Report
Cross Tabs Within Group Headers Or Footers
Generating A Month Name Instead Of A Number
Making Use Of Formulas In Cross Tabs
Utilizing A Parameter Field To Control A Cross Tab
Formatting A Cross Tab And Its Components
Turning On And Off Totals
Change The Calculation Between The Rows And Columns
Placing More Than One Cross Tab On A Report
Sorting A Crosstab By The Summarized Data
Insert Multiple Rows And Or Columns
Use The Step By Step Crosstab Wizard

Charting
Creating A Chart in CR 2008
Changing The Chart Type
Formatting And Renaming The Chart Labels
Customize The Appearance Of A Given Chart
Sorting And Top N In Charts
Placing Charts Within Group Headers Or Footers
Managing Multiple Charts In A Report
A Special Case The Pie Chart
Charts Based On Cross Tabs

Crystal Reports Reader And Automated Report Distributor
Downloading The Reader And The Automated Report Distributor
Installing The Reader And The Distributor (CRD)
Report Viewer File Management
Running Reports In The Viewer
Exporting Data From The Reader
Filtering Data With The Reader
Setup And Configure CRD
Create A Simple Single Report Daily Schedule