 Learn how to take your skills to the next level. This Crystal Reports 2008 Advanced Tutorial Video 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 training comes complete with practical working files and presented via an intuitive, easy-to-use interface, allowing you to learn at your own pace. These Crystal Reports 2008 Advanced Tutorials make learning simple, quick and enjoyable. All Training Videos are authored by professional instructors who have a passion for teaching. 01 Before We Start 0101 What Will I Be Able To Do At The End Of This Course Demo 0102 Using The Files Included With This Course 0103 Installing The SQL Server Sample Databases 0104 About The Author 02 Getting Up To Speed 0201 Creating A Report From Scratch Demo 0202 Adding And Linking Additional Database Tables Demo 0203 Creating A Formula Field Demo 0204 Sorting Data Within A Report Demo 0205 Grouping Reports Demo 0206 Adding Summary Functions Demo 0207 Filtering Data In The Report Demo 0208 Swapping The Data-source Of A Report Demo 03 Conditional Formatting 0301 Using The Highlighting Expert Demo 0302 Changing The Order That Conditions Are Met Demo 0303 Removing Highlighting Expert Conditions Demo 0304 Applying ON/OFF Conditional Formatting Demo 0305 Removing Conditional ON/OFF Formatting Demo 0306 Font Color Controlled By A Condition Demo 0307 Font Style Controlled By A Condition Demo 0308 Removing Or Disabling Conditional Formatting Demo 0309 Clever Conditional Formatting Alternating Page Numbers Demo 0310 Clever Conditional Formatting Banded Report Demo 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 | 
