Crystal Reports 2008 Training DVD - UK Delivery Only

Learn how to take your skills to the next level. This Crystal Reports 2008 training Video on DVD is the ultimate in comprehensive learning for the discerning professional.

The training uses broadcast quality audio and video to deliver concise and informative training right to your desktop. The Tutorial comes complete with practical working files and presented via an intuitive, easy-to-use interface.

These Crystal Reports 2008 tutorials make learning simple, quick and enjoyable. All training courses are authored by professional instructors who have a passion for teaching.

View Sample from Crystal Reports 2008 Training DVD
(sample may be at reduced resolution)

1. 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?
• 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?

2. 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

3. Report Navigation

• Paging Through The Report
• Searching For Text Within The Report
• Group Navigation
• Changing The Zoom In Preview And Design Mode

4. 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 Part 1
• Changing The Font Style, Size And Colour Part 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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

11. 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

12. 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 Part 1
• Creating A Formula To Concatenate Part 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

13. 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

14. The Standard Report Wizard

• The Steps Involved In The Standard Report Wizard
• The Report Template Expert

15. 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

16. Distributing The Report

• Choosing Your Export Format
• Export Directly To An Email
• Export Directly To Microsoft Excel
• Other Export Destinations

17. The Workbench

• Opening The Workbench
• Adding Projects To The Workbench
• Managing Your Reports Using The Workbench
• Removing Reports From The Workbench

18. Credits And Beyond

• About The Author
• Using The Files Included With This Course
• Further Practice Part 1
• Further Practice Part 2
• What's Next?