Books & Videos

Table of Contents

Chapter: Getting Started

What To Expect From Crystal Reports

03m 46s

Opening And Viewing Different Crystal Report Types

03m 59s

Tour Of The Crystal Reports Interface

03m 9s

Crystal Reports Toolbars

03m 16s

What Will I Be Able To Do?

04m 31s

Chapter: Setting Up A New Report

Starting The Report Creation Process

01m 33s

Setting The Page Size/Orientation For The Report

01m 13s

Making A Connection To An Access Database

01m 10s

Making A Connection To An Excel File

00m 43s

Making A Connection To A SQL Server Database

02m 1s

Selecting The Correct Tables/Views

00m 58s

The Sections Of A Report

00m 41s

Adding Fields To The Report

02m 1s

Removing Fields From A Report

00m 43s

Field Masks And Column Header Control

01m 34s

Browsing The Data Before Insertion

01m 9s

Previewing The Report For The First Time

00m 59s

Refreshing The Data

00m 36s

Saving The Report

01m 6s

Saving The Report With The Data

01m 11s

Creating A New Report - The Whole Process

02m 45s

Setting Up A User DSN

02m 55s

Changing A Reports Data Source

03m 11s

Chapter: Report Navigation

Paging Through The Report

01m 13s

Searching For Text Within The Report

01m 9s

Group Navigation

00m 48s

Changing The Zoom In Preview And Design Mode

01m 30s

Chapter: Formatting The Report

Selecting Objects For Formatting Or Resizing

01m 57s

Moving Objects

01m 22s

Resizing Objects

01m 44s

Using The Guides

02m 12s

Using The Grid

02m 5s

Changing The Font Style, Size And Colour Part 1

03m 23s

Changing The Font Style, Size And Colour Part 2

01m 6s

Adding A Colour Border Or Background To Controls

02m 16s

Adding A Hyperlink To A Control

01m 54s

Changing The Paragraph Settings

01m 6s

Number Formatting For Numerical Data Fields

02m 27s

Currency Formatting For Money Data Fields

01m 12s

Date Formatting For Date Data Fields

01m 56s

Using The Format Painter

01m 37s

Aligning And Resizing Multiple Controls On A Report

02m 42s

Setting Default Formatting For Reports

03m 47s

Editing The Layout Default Options

01m 46s

Chapter: Using The Special Data Fields

Adding Data Date And Data Time Fields

04m 46s

Using The Print Date And Print Time Fields

01m 32s

Inserting Page Numbering

02m 40s

Adding The File Path To The Page Footer

01m 27s

Overview Of The Remaining Special Fields

03m 0s

Chapter: Adding Non Data Items To A Report

Inserting And Editing Text Objects

02m 40s

Format Options For A Text Box

01m 58s

Adding Labels To Special Fields

02m 32s

Adding A Horizontal Line

02m 18s

Adding A Vertical Line

02m 5s

Formatting A Line

02m 43s

Controlling A Lines Behaviour

02m 55s

Controlling A Lines Position

03m 13s

Adding A Box

00m 51s

Adding A Box That Crosses Section Boundaries

01m 21s

Formatting A Box

02m 16s

Controlling A Box's Behaviour

01m 58s

Controlling The Size And Position Of A Box

01m 54s

Adding A Company Logo Or Other Image

03m 27s

Removing A Non Data Item

00m 51s

Chapter: Sorting Data In A Report

How To Sort By A Field On The Report

02m 19s

Sorting By More Than One Field

02m 32s

Sorting By Data Fields Not Visible On The Report

01m 57s

Removing Or Changing The Sort Criteria

01m 27s

Chapter: Filtering The Data That A Report Is Using

The Basics Of Filtering The Data

02m 36s

Filtering A Field By Existing Values

03m 14s

Filtering A Field By More Than One Value

02m 51s

Filtering The Data By Dates

05m 27s

Filtering Numeric Fields

03m 38s

Filtering Field Criteria Using And

03m 8s

Filtering Field Criteria Using Or

03m 2s

Editing Filters With The Select Expert

03m 25s

Removing Filters From The Report

01m 25s

Other Text Data Field Filter Options

03m 1s

Filtering For Nulls

04m 1s

Using A Wildcard In Filter Criteria

04m 19s

Chapter: Reporting By Groups

Understanding Grouping

02m 9s

How To Add A Group

03m 58s

Group Labels And Headings

02m 32s

Creating A Multiple Level Group

03m 38s

Removing A Group

01m 51s

Changing The Group Sort Order

03m 23s

Changing The Group Name That Is Displayed

02m 8s

Group Preview Options

04m 6s

Utilizing The Group Tree Navigation Panel

02m 19s

Specifying Your Own Groups

05m 49s

Swapping The Data Field For A Group

02m 35s

Chapter: Summarizing Data

Insert A Grand Total Field

03m 51s

Insert A Sub Total Field

02m 25s

Moving Summary Fields Within The Report

02m 42s

Displaying Sub Totals As A Percentage Of Grand Totals

03m 44s

Summary Fields Using Average, Min Or Max

04m 20s

Creating A Summary Report By Hiding Details

03m 11s

Creating A Drilldown Report

03m 28s

Refreshing A Drilldown Report

01m 51s

Sorting A Group With Summary Fields

02m 40s

Using Top N To Filter Summary Data

03m 24s

Creating A Top 10 List Of Products

04m 17s

Chapter: Using Parameters In Reports

The Benefits Of Using Parameters

01m 30s

How To Add A Free Text Parameter Field

04m 53s

Using A String Parameter To Filter Data Records

03m 17s

Using A Numeric Parameter To Filter Data Records

03m 48s

Using A Date Parameter To Filter Data Records

04m 30s

Using A Parameter Field With Wildcards

04m 1s

Creating And Using A Pick List Parameter Field

05m 17s

Creating A Dynamic Pick List

03m 24s

Deleting A Parameter Field

02m 11s

Controlling The Request Order For Parameters

01m 39s

The Parameter View Panel

02m 31s

Chapter: Formula Fields

How To Create Your Own Fields

05m 13s

A Basic Formula To Enhance The Report

05m 34s

Altering Or Renaming A Formula Field

02m 35s

Deleting A Formula

02m 3s

Creating A Formula To Concatenate Part 1

03m 50s

Creating A Formula To Concatenate Part 2

01m 56s

String Manipulation Formulas In Action

07m 58s

Date Formulas At Their Best

06m 26s

Calculating Age With Crystal Reports

05m 13s

Using Formula Fields In The Sort Expert And The Select Expert

02m 35s

Using Formula Fields While Grouping

05m 32s

Making The Formula Field Work With If And Else

06m 49s

Converting Datetime To Date Format To Improve Parameters

03m 30s

Creating An Address Formula With Carriage Returns

09m 13s

Chapter: Section Formatting

The Report Header And Report Footer Options

05m 29s

Exploring The Formatting Options Of The Page Header And Footer

03m 7s

The Details Section Expert

05m 14s

How To Add A Watermark To A Report

03m 19s

Improving Headings In Drilldowns Using The Section Expert

04m 58s

Chapter: The Standard Report Wizard

The Steps Involved In The Standard Report Wizard

05m 28s

The Report Template Expert

04m 7s

Chapter: Data Table Linking

Quick Overview Of Relational Databases

12m 49s

Visual Linking In Crystal Reports

05m 37s

How To Identify Key Fields

03m 4s

Link Types And Their Effects When Used

05m 14s

Removing Links And Tables From The Report

02m 4s

Chapter: Distributing The Report

Choosing Your Export Format

03m 43s

Export Directly To An Email

01m 53s

Export Directly To Microsoft Excel

03m 59s

Other Export Destinations

03m 10s

Chapter: The Workbench

Opening The Workbench

01m 1s

Adding Projects To The Workbench

01m 11s

Managing Your Reports Using The Workbench

02m 2s

Removing Reports From The Workbench

01m 21s

Chapter: Credits And Beyond

About The Author

01m 26s

Using The Files Included With This Course

00m 43s

Further Practice Part 1

04m 43s

Further Practice Part 2

04m 32s

What's Next?

02m 20s