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 this Advanced Crystal Reports Tutorial 2008

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

Advanced Crystal Reports 2008 Tutorial

SPECIAL OFFER: 20% DISCOUNT & FREE SHIPPING!
 Professionally created, self-study video training.

About this Tutorialshow details
Learn how to create and format reports like a seasoned pro with the help of this Advanced Crystal Reports tutorial. Assuming prior knowledge of Crystal Reports, expert tutor Guy Vaccaro uses step-by-step video training movies to help explain and demonstrate the more complex features and advanced report building capabilities, helping you to get the very most out of Crystal Reports 2008. In over 6 hours of professionally created video training, tuition includes using conditions to control formatting, how to use variables for advanced reporting, utilizing parameter fields, how to create your own SQL statements for reports, adding an alert to a report and so much more. You can view the complete training course listings below and start learning right away, click any of the blue linked lessons to sample FREE Advanced Crystal Reports tutorials...
Learn this Software - See below for FREE TUTORIALS
RECOMMENDED TITLES
We also have the
Crystal Reports 2011 Tutorial

And the
Beginners Crystal Reports 2008 Tutorial


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

FREE Shipping on ALL Orders

Advanced Crystal Reports Tutorial 2008 Info
Tutor: Guy Vaccaro
Duration: 6.5 hrs / 85 video lessons
Cost for UK: £79.95 £63.95 + VAT
Cost for EU: €84.95 €67.95 + VAT
Cost for US & Canada: $124.95 $99.94
*no further discounts can be applied
Product Code: 01618
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:
Crystal Reports 2008 Bundle | Complete Range of FileMaker Pro Tutorials | Complete Range of Microsoft Access Tutorials | Complete range of Microsoft Office 2003 Tutorials REAL Studio | 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

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

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

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



  UK & Europe
Marrutt Software Training
Bellbrook Industrial Estate
Uckfield, East Sussex, TN22 1QL
United Kingdom
UK Tel: +44 (0) 1825 764057
UK Fax: +44 (0) 1825 768841

  US & Canada
Marrutt Software Training
244 5th Ave # 1877
New York, NY 10001
United States
US Tel: 646-736-7932
US Fax: 646-895-7649