by Guy Vaccaro | Publisher: Infinite Skills | Release Date: August 2012 | ISBN: 9781771370257

In this Advanced Crystal Reports 2011 training course, expert trainer and author Guy Vaccaro covers advanced topics and tools available to you in Crystal Reports. This course is for users that are already familiar with the basic operation of Crystal Reports, and want to get more in-depth with its capabilities.Guys starts you off easy, with a quick review of some of the basics of Crystal Reports, and then take you right into some of the more complex features. You begin with conditional formatting then move on to working with parameter fields and report alerts. You will learn how to create multiple sections, and sub reports. Advanced charting is covered, along with cross-tabs, formulas, even a chapter on SQL commands. You finish the training course with a quick look at the data map tool and how to distribute your reports.By the completion of this computer based training video on SAP Crystal Reports 2011, you will have a deeper grasp of the advanced features that are available to you, allowing you to present your data in easy to understand and visually appealing ways. Working files are included to allow you to work with the author throughout this training course.

1. Introduction
   • Am I Ready For This Advanced Course 00:03:33
   • Installing And Connecting To The Sample Databases Provided 00:04:15
   • Using The Working Files Effectively 00:02:55
   • About The Author 00:01:20
   • Swapping The Data Source Of A Report 00:04:04
2. Revision
   • Creating A Report Without The Wizard 00:06:12
   • Adding And Linking Multiple Database Tables 00:03:49
   • Making Use Of Formula Fields 00:08:23
   • Overriding The Database Default Sort 00:03:48
   • Filtering Data To Reduce The Quantity 00:08:40
   • Grouping Data In Reports 00:08:07
   • Special User Defined Groups 00:04:38
   • Adding Summary Functions 00:08:36
3. Conditional Formatting
   • Using The Highlighting Expert 00:05:09
   • Changing The Order That Conditions Are Effective 00:03:13
   • Removing The Highlighting Expert Conditions 00:01:59
   • Applying On/Off Conditional Formatting 00:04:56
   • Font Color And Typeface Controlled By A Condition 00:05:56
   • Edit/Remove/Copy/Disable Conditional Formatting 00:05:23
   • Create Alternate Page Numbers Through Conditional Formatting 00:04:21
   • Creating A Banded Report 00:03:22
   • Formatting Controlled By Summary Values 00:06:10
4. Parameter Fields
   • Creating A Parameter Field To Filter Data 00:03:22
   • Parameter Fields Used To Customize Formatting 00:08:07
   • Letting The User Change The Color Of Banded Reports 00:08:25
   • Parameter Controlled Order By 00:06:13
   • Parameter Masks To Control User Input 00:06:58
5. Report Alerts
   • Adding And Triggering A Report Alert 00:04:13
   • Editing Alerts And Viewing Triggered Values 00:03:08
   • Use A Formula In The Alert Message 00:02:51
   • Using A Parameter Value With A Report Alert 00:08:13
6. Multiple Sections
   • Creating And Managing Extra Report Sections 00:05:31
   • Different Headers And Footers On Odd And Even Pages 00:09:19
   • Use Split Sections To Add A Watermark 00:02:49
   • Column Headings In Drilldown Reports 00:05:13
   • Add Continued To Page Header For Multiple Page Groups 00:04:14
7. Sub Reports
   • What Is A Sub Report 00:04:40
   • Creating And Importing Unlinked Sub Reports 00:08:30
   • Create And Insert A Linked Sub Report 00:05:17
   • On Demand Sub Reports 00:05:30
   • Hiding Sub Reports That Contain No Data 00:05:59
   • Dealing With Overlapping Sub Reports 00:02:30
   • Methods For Updating Changes Made To Sub Reports 00:04:01
8. Charting
   • Creating A Chart 00:05:46
   • Changing The Chart Type Of Your Chart 00:07:29
   • Chart Formatting And Label Editing 00:06:40
   • Multiple Series Of Data In A Chart 00:08:15
   • Special Groups Within A Chart To Improve Appearance 00:04:16
   • Using Top N In Charts 00:05:37
   • Placing Charts In Group Headers And Footers 00:06:35
   • Managing Multiple Charts In A Report 00:06:46
   • A Special Chart Type The Pie 00:08:03
   • Multiple Series Data Using Pie Charts 00:06:56
9. Cross-Tabs
   • Adding A Cross Tab To A Report 00:06:29
   • Generating The Month Name As A Heading 00:03:26
   • Totals On Or Off Top Or Bottom 00:02:23
   • Formatting A Cross Tab And Its Components 00:04:41
   • Use Of Conditional Formatting In A Cross Tab 00:04:42
   • Cross-Tabs With Group Headers Or Footers 00:04:51
   • Placing More Than One Cross Tab On A Report 00:03:39
   • Sorting A Cross Tab By Its Summarized Data 00:04:20
   • Changing The Calculation Within The Data Area 00:06:18
   • Use Of A Parameter To Allow User Choice Of Grouping 00:06:28
   • Insert Multiple Grouping 00:04:37
   • Cross Tab Wizard Vs Manually Creation 00:04:32
   • A Quick Chart From A Cross Tab 00:04:44
10. Advanced Formulas
    • Declaring Variables To Use In Formulas 00:05:15
    • Application Of A Variable In A Report 00:03:12
    • Multi Pass Reporting Explained 00:05:27
    • Altering The Multi Pass In A Formula 00:05:13
    • Outputting Multiple Variable Values From One Formula 00:07:27
    • Using Shared Variables To Exchange Data With A Sub Report 00:06:13
    • User Defined Functions 00:06:57
11. SQL And Commands
    • Standard Query Language (SQL) 00:07:20
    • Using Your Own SQL As A Reports Data Source 00:06:05
    • Adding Parameters To User Defined SQL Commands 00:07:42
12. Summary and Beyond
    • Investigating The Data Map Tool 00:06:06
    • Distribute Crystal Reports Viewer To Non Developers 00:01:39
    • Were You Ready? 00:03:22