Crystal Reports 2008 tutorials : learn quickly/cost-effectively with this 'Crystal Reports 2008' training cour

Crystal Reports 2008 CD Training Course 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