Advanced Crystal Reports 2011 Training Video

expand all / collapse all

• 00. Free Videos From This Course

  • Am I Ready For This Advanced Course
  • About The Author
  • Filtering Data To Reduce The Quantity
  • Adding Summary Functions
  • Letting The User Change The Color Of Banded Reports
  • Using A Parameter Value With A Report Alert
  • Different Headers And Footers On Odd And Even Pages
  • Creating And Importing Unlinked Sub Reports
  • Changing The Chart Type Of Your Chart
  • A Special Chart Type The Pie
  • Adding Parameters To User Defined SQL Commands
  • Investigating The Data Map Tool

• 01. Introduction

  • 0101 Am I Ready For This Advanced Course
  • 0102 Installing And Connecting To The Sample Databases Provided
  • 0103 Using The Working Files Effectively
  • 0104 About The Author
  • 0105 Swapping The Data Source Of A Report

• 02. Revision

  • 0201 Creating A Report Without The Wizard
  • 0202 Adding And Linking Multiple Database Tables
  • 0203 Making Use Of Formula Fields
  • 0204 Overriding The Database Default Sort
  • 0205 Filtering Data To Reduce The Quantity
  • 0206 Grouping Data In Reports
  • 0207 Special User Defined Groups
  • 0208 Adding Summary Functions

• 03. Conditional Formatting

  • 0301 Using The Highlighting Expert
  • 0302 Changing The Order That Conditions Are Effective
  • 0303 Removing The Highlighting Expert Conditions
  • 0304 Applying On/Off Conditional Formatting
  • 0305 Font Color And Typeface Controlled By A Condition
  • 0306 Edit/Remove/Copy/Disable Conditional Formatting
  • 0307 Create Alternate Page Numbers Through Conditional Formatting
  • 0308 Creating A Banded Report
  • 0309 Formatting Controlled By Summary Values

• 04. Parameter Fields

  • 0401 Creating A Parameter Field To Filter Data
  • 0402 Parameter Fields Used To Customize Formatting
  • 0403 Letting The User Change The Color Of Banded Reports
  • 0404 Parameter Controlled Order By
  • 0405 Parameter Masks To Control User Input

• 05. Report Alerts

  • 0501 Adding And Triggering A Report Alert
  • 0502 Editing Alerts And Viewing Triggered Values
  • 0503 Use A Formula In The Alert Message
  • 0504 Using A Parameter Value With A Report Alert

• 06. Multiple Sections

  • 0601 Creating And Managing Extra Report Sections
  • 0602 Different Headers And Footers On Odd And Even Pages
  • 0603 Use Split Sections To Add A Watermark
  • 0604 Column Headings In Drilldown Reports
  • 0605 Add Continued To Page Header For Multiple Page Groups

• 07. Sub Reports

  • 0701 What Is A Sub Report
  • 0702 Creating And Importing Unlinked Sub Reports
  • 0703 Create And Insert A Linked Sub Report
  • 0704 On Demand Sub Reports
  • 0705 Hiding Sub Reports That Contain No Data
  • 0706 Dealing With Overlapping Sub Reports
  • 0707 Methods For Updating Changes Made To Sub Reports

• 08. Charting

  • 0801 Creating A Chart
  • 0802 Changing The Chart Type Of Your Chart
  • 0803 Chart Formatting And Label Editing
  • 0804 Multiple Series Of Data In A Chart
  • 0805 Special Groups Within A Chart To Improve Appearance
  • 0806 Using Top N In Charts
  • 0807 Placing Charts In Group Headers And Footers
  • 0808 Managing Multiple Charts In A Report
  • 0809 A Special Chart Type The Pie
  • 0810 Multiple Series Data Using Pie Charts

• 09. Cross-Tabs

  • 0901 Adding A Cross Tab To A Report
  • 0902 Generating The Month Name As A Heading
  • 0903 Totals On Or Off Top Or Bottom
  • 0904 Formatting A Cross Tab And Its Components
  • 0905 Use Of Conditional Formatting In A Cross Tab
  • 0906 Cross-Tabs With Group Headers Or Footers
  • 0907 Placing More Than One Cross Tab On A Report
  • 0908 Sorting A Cross Tab By Its Summarized Data
  • 0909 Changing The Calculation Within The Data Area
  • 0910 Use Of A Parameter To Allow User Choice Of Grouping
  • 0911 Insert Multiple Grouping
  • 0912 Cross Tab Wizard Vs Manually Creation
  • 0913 A Quick Chart From A Cross Tab

• 10. Advanced Formulas

  • 1001 Declaring Variables To Use In Formulas
  • 1002 Application Of A Variable In A Report
  • 1003 Multi Pass Reporting Explained
  • 1004 Altering The Multi Pass In A Formula
  • 1005 Outputting Multiple Variable Values From One Formula
  • 1006 Using Shared Variables To Exchange Data With A Sub Report
  • 1007 User Defined Functions

• 11. SQL And Commands

  • 1101 Standard Query Language (SQL)
  • 1102 Using Your Own SQL As A Reports Data Source
  • 1103 Adding Parameters To User Defined SQL Commands

• 12. Summary and Beyond

  • 1201 Investigating The Data Map Tool
  • 1202 Distribute Crystal Reports Viewer To Non Developers
  • 1203 Were You Ready?

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.