by Guy Vaccaro | Publisher: Infinite Skills | Release Date: January 2011 | ISBN: 9781926873299

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.

1. Before We Start
   • What Will I Be Able To Do At The End Of This Course 00:06:59
   • Using The Files Included With This Course 00:01:49
   • Installing The SQL Server Sample Databases 00:07:25
   • About The Author 00:01:18
2. Getting Up To Speed
   • Creating A Report From Scratch 00:04:30
   • Adding And Linking Additional Database Tables 00:02:58
   • Creating A Formula Field 00:04:26
   • Sorting Data Within A Report 00:02:39
   • Grouping Reports 00:03:58
   • Adding Summary Functions 00:04:08
   • Filtering Data In The Report 00:04:31
   • Swapping The Data-source Of A Report 00:04:14
3. Conditional Formatting
   • Using The Highlighting Expert 00:04:50
   • Changing The Order That Conditions Are Met 00:02:49
   • Removing Highlighting Expert Conditions 00:01:02
   • Applying ON/OFF Conditional Formatting 00:04:42
   • Removing Conditional ON/OFF Formatting 00:01:40
   • Font Color Controlled By A Condition 00:05:29
   • Font Style Controlled By A Condition 00:02:25
   • Removing Or Disabling Conditional Formatting 00:03:08
   • Clever Conditional Formatting Alternating Page Numbers 00:04:13
   • Clever Conditional Formatting Banded Report 00:03:14
4. Advanced Formulas Using Variables
   • Declaring Variables To Use In Reports 00:06:10
   • Understanding The Multiple Pass Report Generation 00:03:19
   • Making Use Of Multi-Pass In A Report 00:05:50
   • Using And Outputting Multiple Variables At Once 00:05:25
   • Using Variables In Multiple Formulas And Locations 00:08:55
   • Creating And Using User Defined Functions 00:06:05
5. SQL And Commands
   • Standard Query Language (SQL) 00:05:01
   • Defining Your Own SQL As The Data Source 00:03:54
   • Adding Parameters To Your Own SQL Statement 00:04:40
6. Parameter Fields
   • Creating A Parameter Field And Using It To Filter Data 00:04:27
   • Parameter Fields To Customize Formatting 00:04:23
   • Letting The User Change The Color Of Banded Reports 00:07:32
   • Parameter Controlled Sort Order 00:07:10
   • Making Use Of Masks In Parameters 00:05:27
7. Report Alerts
   • Adding An Alert To A Report 00:03:48
   • Triggering A Report Alert 00:02:31
   • Viewing Record Sets Created By Alerts 00:02:18
   • Add A Formula To Generate The Alert Message 00:02:41
   • Using A Parameter Value With A Report Alert 00:04:52
8. Multiple Sections
   • Inserting Extra Sections By Dividing Existing Sections 00:03:37
   • Deleting And Merging Sections 00:03:21
   • Splitting Existing Content Between Sections 00:02:47
   • Moving A Sections Position In A Report 00:02:12
   • Uses For Multiple Page Header Footer Sections 00:08:50
   • Multiple Sections Can Provide Column Headings In Drilldown Reports 00:04:02
   • Adding Continued To Page Heading When Required 00:05:01
9. Sub Reports
   • What Is A Sub Report 00:04:00
   • Creating And Importing An Unlinked Sub Report 00:06:49
   • Create And Insert A Linked Sub Report 00:08:15
   • On Demand Sub Reports 00:05:23
   • Hiding Sub Reports That Contain No Data 00:07:05
   • Dealing With Overlapping Sub Reports 00:03:25
   • Methods For Updating Changes Made To The Sub Report 00:04:16
   • Pass Data Between Sub And Main Report Using Variables 00:06:30
10. Cross Tabs
    • Adding A Cross Tab To A Report 00:07:36
    • Cross Tabs Within Group Headers Or Footers 00:03:59
    • Generating A Month Name Instead Of A Number 00:02:51
    • Making Use Of Formulas In Cross Tabs 00:05:53
    • Utilizing A Parameter Field To Control A Cross Tab 00:07:08
    • Formatting A Cross Tab And Its Components 00:05:47
    • Turning On And Off Totals 00:03:34
    • Change The Calculation Between The Rows And Columns 00:04:25
    • Placing More Than One Cross Tab On A Report 00:05:14
    • Sorting A Crosstab By The Summarized Data 00:03:40
    • Insert Multiple Rows And Or Columns 00:06:33
    • Use The Step By Step Crosstab Wizard 00:04:13
11. Charting
    • Creating A Chart 00:04:19
    • Changing The Chart Type 00:05:15
    • Formatting And Renaming The Chart Labels 00:05:24
    • Customize The Appearance Of A Given Chart 00:04:12
    • Sorting And Top N In Charts 00:03:55
    • Placing Charts Within Group Headers Or Footers 00:04:29
    • Managing Multiple Charts In A Report 00:04:25
    • A Special Case The Pie Chart 00:06:29
    • Charts Based On Cross Tabs 00:03:48
12. Crystal Reports Reader And Automated Report Distributor
    • Downloading The Reader And The Automated Report Distributor 00:02:12
    • Installing The Reader And The Distributor (CRD) 00:05:26
    • Report Viewer File Management 00:04:57
    • Running Reports In The Viewer 00:04:12
    • Exporting Data From The Reader 00:01:52
    • Filtering Data With The Reader 00:02:40
    • Setup And Configure CRD 00:02:26
    • Create A Simple Single Report Daily Schedule 00:07:52