Crystal Reports 2008 Advanced Training Video

expand all / collapse all

• 01. Before We Start

  • What Will I Be Able To Do At The End Of This Course
  • 0102 Using The Files Included With This Course
  • 0103 Installing The SQL Server Sample Databases
  • 0104 About The Author

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

• 03. 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 Numbers
  • Clever Conditional Formatting Banded Report

• 04. Advanced Formulas Using Variables

  • 0401 Declaring Variables To Use In Reports
  • 0402 Understanding The Multiple Pass Report Generation
  • 0403 Making Use Of Multi-Pass In A Report
  • 0404 Using And Outputting Multiple Variables At Once
  • 0405 Using Variables In Multiple Formulas And Locations
  • 0406 Creating And Using User Defined Functions

• 05. SQL And Commands

  • 0501 Standard Query Language (SQL)
  • 0502 Defining Your Own SQL As The Data Source
  • 0503 Adding Parameters To Your Own SQL Statement

• 06. Parameter Fields

  • 0601 Creating A Parameter Field And Using It To Filter Data
  • 0602 Parameter Fields To Customize Formatting
  • 0603 Letting The User Change The Color Of Banded Reports
  • 0604 Parameter Controlled Sort Order
  • 0605 Making Use Of Masks In Parameters

• 07. Report Alerts

  • 0701 Adding An Alert To A Report
  • 0702 Triggering A Report Alert
  • 0703 Viewing Record Sets Created By Alerts
  • 0704 Add A Formula To Generate The Alert Message
  • 0705 Using A Parameter Value With A Report Alert

• 08. Multiple Sections

  • 0801 Inserting Extra Sections By Dividing Existing Sections
  • 0802 Deleting And Merging Sections
  • 0803 Splitting Existing Content Between Sections
  • 0804 Moving A Sections Position In A Report
  • 0805 Uses For Multiple Page Header Footer Sections
  • 0806 Multiple Sections Can Provide Column Headings In Drilldown Reports
  • 0807 Adding Continued To Page Heading When Required

• 09. Sub Reports

  • 0901 What Is A Sub Report
  • 0902 Creating And Importing An Unlinked Sub Report
  • 0903 Create And Insert A Linked Sub Report
  • 0904 On Demand Sub Reports
  • 0905 Hiding Sub Reports That Contain No Data
  • 0906 Dealing With Overlapping Sub Reports
  • 0907 Methods For Updating Changes Made To The Sub Report
  • 0908 Pass Data Between Sub And Main Report Using Variables

• 10. Cross Tabs

  • 1001 Adding A Cross Tab To A Report
  • 1002 Cross Tabs Within Group Headers Or Footers
  • 1003 Generating A Month Name Instead Of A Number
  • 1004 Making Use Of Formulas In Cross Tabs
  • 1005 Utilizing A Parameter Field To Control A Cross Tab
  • 1006 Formatting A Cross Tab And Its Components
  • 1007 Turning On And Off Totals
  • 1008 Change The Calculation Between The Rows And Columns
  • 1009 Placing More Than One Cross Tab On A Report
  • 1010 Sorting A Crosstab By The Summarized Data
  • 1011 Insert Multiple Rows And Or Columns
  • 1012 Use The Step By Step Crosstab Wizard

• 11. Charting

  • 1101 Creating A Chart
  • 1102 Changing The Chart Type
  • 1103 Formatting And Renaming The Chart Labels
  • 1104 Customize The Appearance Of A Given Chart
  • 1105 Sorting And Top N In Charts
  • 1106 Placing Charts Within Group Headers Or Footers
  • 1107 Managing Multiple Charts In A Report
  • 1108 A Special Case The Pie Chart
  • 1109 Charts Based On Cross Tabs

• 12. Crystal Reports Reader And Automated Report Distributor

  • 1201 Downloading The Reader And The Automated Report Distributor
  • 1202 Installing The Reader And The Distributor (CRD)
  • 1203 Report Viewer File Management
  • 1204 Running Reports In The Viewer
  • 1205 Exporting Data From The Reader
  • 1206 Filtering Data With The Reader
  • 1207 Setup And Configure CRD
  • 1208 Create A Simple Single Report Daily Schedule

In this Advanced Crystal Reports 2008 training video, expert author Guy Vaccaro picks up where he left off in the Crystal Reports Fundamentals tutorial. It is recommended that you have a fundamental knowledge of Crystal Reports 2008, or have previously viewed the Infinite Skills Crystal Reports 2008 Fundamentals course before continuing with this training course.

After a brief review of material covered in the basics, Guy jumps in with both feet to walk you through the advanced features and report building capabilities of Crystal Reports. You will learn how to use conditions to control formatting, using variables for advanced reporting, multiple pass reports, creating your own SQL statements for reports, as well as covering parameter fields and their powerful uses. This computer based training video will also instruct you on creating alerts, sub reports, creating and inserting cross tabs, and so much more!

By the completion of this advanced tutorial video, you will be creating and formatting reports like a master, using Crystal Reports 2008! The full complement of working files that the authors uses are included, so you can work on the same material that is being taught in the video course.