Crystal Reports 2008 Training Bundle
Beginner to Advanced

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