Crystal Reports 2008 Advanced Video Tutorial Course

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