Crystal Reports 2008 Advanced Video Tutorial Course

CareerVision Training

£ 70 - (Rs 6,067)
VAT incl.

Important information

  • Training
  • Advanced
  • Distance learning
  • Duration:
  • When:
  • Delivery of study materials

• Format: DVD-ROM
• Duration: 6.5 Hours (85 lessons)
• Instructor: Guy Vaccaro
• Platform: Windows PC or Mac


In this Advanced Crystal Reports 2008 training video, expert author Guy Vaccaro picks up where he left off in the Crystal Reports Fundamentals tutorial. It is recommended that you have a fundamental knowledge of Crystal Reports 2008, or have previously viewed the Infinite Skills Crystal Reports 2008 Fundamentals course before continuing with this training course.

After a brief review of material covered in the basics, Guy jumps in with both feet to walk you through the advanced features and report building capabilities of Crystal Reports.

Important information

Requirements: This is a DVD Video Tutorial Course which is shipped to you. Work through the video tutorials at your own pace. If you have the software you can practice along with the instructor using the same exercise files as the instructor which are included on the DVD. The narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter. All the concepts of each application are explained clearly and precisely. The DVD works on PC and Mac. You can jump to and from lessons and work at your own pace.


Where and when

Starts Location
Distance Learning

What you'll learn on the course

Crystal Reports
SQL Server
Parameter Fields
Creating Alerts

Course programme

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


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