Crystal Reports 2008 Training Video

expand all / collapse all

• 00. Free Videos From This Course

  • Filtering the Data by Dates
  • Creating a Drilldown Report in Crystal
  • Using Parameter Fields with Wild Cards
  • String Manipulation Formulas in Action
  • Calculating Age with Crystal Reports
  • Converting DateTime to Date Format to Improve Parameters
  • Improving Headings in Drilldowns Using the Section Expert
  • Visual Linking in Crystal Reports
  • Link types and their Effects when Used

• 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

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

• 4. Formatting The Report

  • 0401 Selecting Objects For Formatting Or Resizing
  • 0402 Moving Objects
  • 0403 Resizing Objects
  • 0404 Using The Guides
  • 0405 Using The Grid
  • 0406 Changing The Font Style, Size And Colour Part 1
  • 0407 Changing The Font Style, Size And Colour Part 2
  • 0408 Adding A Colour Border Or Background To Controls
  • 0409 Adding A Hyperlink To A Control
  • 0410 Changing The Paragraph Settings
  • 0411 Number Formatting For Numerical Data Fields
  • 0412 Currency Formatting For Money Data Fields
  • 0413 Date Formatting For Date Data Fields
  • 0414 Using The Format Painter
  • 0415 Aligning And Resizing Multiple Controls On A Report
  • 0416 Setting Default Formatting For Reports
  • 0417 Editing The Layout Default Options

• 5. Using The Special Data Fields

  • 0501 Adding Data Date And Data Time Fields
  • 0502 Using The Print Date And Print Time Fields
  • 0503 Inserting Page Numbering
  • 0504 Adding The File Path To The Page Footer
  • 0505 Overview Of The Remaining Special Fields

• 6. Adding Non Data Items To A Report

  • 0601 Inserting And Editing Text Objects
  • 0602 Format Options For A Text Box
  • 0603 Adding Labels To Special Fields
  • 0604 Adding A Horizontal Line
  • 0605 Adding A Vertical Line
  • 0606 Formatting A Line
  • 0607 Controlling A Lines Behaviour
  • 0608 Controlling A Lines Position
  • 0609 Adding A Box
  • 0610 Adding A Box That Crosses Section Boundaries
  • 0611 Formatting A Box
  • 0612 Controlling A Box's Behaviour
  • 0613 Controlling The Size And Position Of A Box
  • 0614 Adding A Company Logo Or Other Image
  • 0615 Removing A Non Data Item

• 7. Sorting Data In A Report

  • 0701 How To Sort By A Field On The Report
  • 0702 Sorting By More Than One Field
  • 0703 Sorting By Data Fields Not Visible On The Report
  • 0704 Removing Or Changing The Sort Criteria

• 8. Filtering The Data That A Report Is Using

  • 0801 The Basics Of Filtering The Data
  • 0802 Filtering A Field By Existing Values
  • 0803 Filtering A Field By More Than One Value
  • 0804 Filtering The Data By Dates
  • 0805 Filtering Numeric Fields
  • 0806 Filtering Field Criteria Using And
  • 0807 Filtering Field Criteria Using Or
  • 0808 Editing Filters With The Select Expert
  • 0809 Removing Filters From The Report
  • 0810 Other Text Data Field Filter Options
  • 0811 Filtering For Nulls
  • 0812 Using A Wildcard In Filter Criteria

• 9. Reporting By Groups

  • 0901 Understanding Grouping
  • 0902 How To Add A Group
  • 0903 Group Labels And Headings
  • 0904 Creating A Multiple Level Group
  • 0905 Removing A Group
  • 0906 Changing The Group Sort Order
  • 0907 Changing The Group Name That Is Displayed
  • 0908 Group Preview Options
  • 0909 Utilizing The Group Tree Navigation Panel
  • 0910 Specifying Your Own Groups
  • 0911 Swapping The Data Field For A Group

• 10. Summarizing Data

  • 1001 Insert A Grand Total Field
  • 1002 Insert A Sub Total Field
  • 1003 Moving Summary Fields Within The Report
  • 1004 Displaying Sub Totals As A Percentage Of Grand Totals
  • 1005 Summary Fields Using Average, Min Or Max
  • 1006 Creating A Summary Report By Hiding Details
  • 1007 Creating A Drilldown Report
  • 1008 Refreshing A Drilldown Report
  • 1009 Sorting A Group With Summary Fields
  • 1010 Using Top N To Filter Summary Data
  • 1011 Creating A Top 10 List Of Products

• 11. Using Parameters In Reports

  • 1101 The Benefits Of Using Parameters
  • 1102 How To Add A Free Text Parameter Field
  • 1103 Using A String Parameter To Filter Data Records
  • 1104 Using A Numeric Parameter To Filter Data Records
  • 1105 Using A Date Parameter To Filter Data Records
  • 1106 Using A Parameter Field With Wildcards
  • 1107 Creating And Using A Pick List Parameter Field
  • 1108 Creating A Dynamic Pick List
  • 1109 Deleting A Parameter Field
  • 1110 Controlling The Request Order For Parameters
  • 1111 The Parameter View Panel

• 12. Formula Fields

  • 1201 How To Create Your Own Fields
  • 1202 A Basic Formula To Enhance The Report
  • 1203 Altering Or Renaming A Formula Field
  • 1204 Deleting A Formula
  • 1205 Creating A Formula To Concatenate Part 1
  • 1206 Creating A Formula To Concatenate Part 2
  • 1207 String Manipulation Formulas In Action
  • 1208 Date Formulas At Their Best
  • 1209 Calculating Age With Crystal Reports
  • 1210 Using Formula Fields In The Sort Expert And The Select Expert
  • 1211 Using Formula Fields While Grouping
  • 1212 Making The Formula Field Work With If And Else
  • 1213 Converting Datetime To Date Format To Improve Parameters
  • 1214 Creating An Address Formula With Carriage Returns

• 13. Section Formatting

  • 1301 The Report Header And Report Footer Options
  • 1302 Exploring The Formatting Options Of The Page Header And Footer
  • 1303 The Details Section Expert
  • 1304 How To Add A Watermark To A Report
  • 1305 Improving Headings In Drilldowns Using The Section Expert

• 14. The Standard Report Wizard

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

• 15. Data Table Linking

  • 1501 Quick Overview Of Relational Databases
  • 1502 Visual Linking In Crystal Reports
  • 1503 How To Identify Key Fields
  • 1504 Link Types And Their Effects When Used
  • 1505 Removing Links And Tables From The Report

• 16. Distributing The Report

  • 1601 Choosing Your Export Format
  • 1602 Export Directly To An Email
  • 1603 Export Directly To Microsoft Excel
  • 1604 Other Export Destinations

• 17. The Workbench

  • 1701 Opening The Workbench
  • 1702 Adding Projects To The Workbench
  • 1703 Managing Your Reports Using The Workbench
  • 1704 Removing Reports From The Workbench

• 18. Credits And Beyond

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

Crystal Reports 2008 is the market leading report writing package that allows users to create custom reports from a massive array of data storage systems.

This Crystal Reports 2008 Tutorial Video is presented by Guy Vaccaro, who has many years experience with database report writing, with and without Crystal Reports. He will help you traverse through the report writing process and build your skills so that you too can create your very own custom reports that actually tell you what you need to know rather than relying on anything supplied by any database provider. By the end of this Crystal Reports training video you will understand the concepts involved and feel fully able to connect to databases of all kinds, from text files such as Excel to server based databases such as Microsoft SQL Server and Oracle. You will be able to extract the requisite information from your databases by filtering and sorting the data as needed, and then present it in a meaningful and concise format, making full use of Crystal Reports formatting, drawing and graphics import tools. Guy helps to explain the processes involved in a very straightforward way without the use of IT jargon, which makes the learning process as painless and fruitful as possible.

By the conclusion of this Crystal Reports tutorial you will have gained the skills required to design and create reports that present information in a pleasing and informative manner, and be able to use Crystal Reports confidently in a commercial environment. Working files accompany the training, allowing you to follow along with the trainer at your own pace.