Learning SAP Crystal Reports 2011 Training Video

expand all / collapse all

• 00. Free Videos From This Course

  • What Will I Be Able To Do With Crystal Reports
  • Quick Tour Of Crystal Reports Interface And Toolbars
  • Making Use Of The Included Working Files
  • Installing The Sample Databases Provided
  • Changing The Datasource Of The Working Files
  • About The Author
  • Starting Crystal Reports And A New Report
  • Setting Page Size Orientation For The Report
  • Making A Connection To The Sample Access Databases
  • Making A Connection To The Sample Excel Files
  • Making A Connection To The Sample SQL Server Database
  • Selecting The Correct Tables or Views
  • Field Explorer And Sections Overview
  • Adding And Removing Fields On The Report
  • Field Masks And Column Header Control
  • Browsing The Data Before Insertion
  • Previewing The Report For The First Time
  • Refreshing The Reports Data
  • Saving The Report
  • Saving The Report Without The Data
  • Paging Through The Report
  • Searching For Text Within The Report
  • Changing The Zoom In Preview And Design
  • Using The Group Navigation Pane

• 01. In The Beginning

  • 0101 What Will I Be Able To Do With Crystal Reports
  • 0102 Quick Tour Of Crystal Reports Interface And Toolbars
  • 0103 Making Use Of The Included Working Files
  • 0104 Installing The Sample Databases Provided
  • 0105 Changing The Datasource Of The Working Files
  • 0106 About The Author

• 02. Setting Up A New Report

  • 0201 Starting Crystal Reports And A New Report
  • 0202 Setting Page Size Orientation For The Report
  • 0203 Making A Connection To The Sample Access Databases
  • 0204 Making A Connection To The Sample Excel Files
  • 0205 Making A Connection To The Sample SQL Server Database
  • 0206 Selecting The Correct Tables or Views
  • 0207 Field Explorer And Sections Overview
  • 0208 Adding And Removing Fields On The Report
  • 0209 Field Masks And Column Header Control
  • 0210 Browsing The Data Before Insertion
  • 0211 Previewing The Report For The First Time
  • 0212 Refreshing The Reports Data
  • 0213 Saving The Report
  • 0214 Saving The Report Without The Data

• 03. Report Navigation

  • 0301 Paging Through The Report
  • 0302 Searching For Text Within The Report
  • 0303 Changing The Zoom In Preview And Design
  • 0304 Using The Group Navigation Pane

• 04. Formatting The Report

  • 0401 Moving And Resizing Objects On The Report
  • 0402 Using The Guides And Other Alignment Options
  • 0403 Snap To Grid Saves The Day
  • 0404 Changing The Font Style, Size And Color
  • 0405 Adding A Color Border Or Background To Controls
  • 0406 Paragraph Settings
  • 0407 Number Formatting For Numerical Data Fields
  • 0408 Currency Formatting For Money Data Fields
  • 0409 Date Formatting Options
  • 0410 Using The Format Painter
  • 0411 Adding A Hyperlink To A Field
  • 0412 Lock The Format Size And Position Of An Object
  • 0413 Default Font Formatting Options
  • 0414 Default Data Formatting Options
  • 0415 Background Colors

• 05. Using The Special Data Fields

  • 0501 Adding Special Date Fields
  • 0502 Inserting Page Numbers
  • 0503 Adding The File Path To The Page Footer
  • 0504 Report Author And Title Fields
  • 0505 Of What Use Are The Remaining Special Fields

• 06. Adding Non Data Items To A Report

  • 0601 Inserting And Editing Text Objects
  • 0602 Format Options For A Text Object
  • 0603 Adding A Horizontal Or Vertical Line
  • 0604 Formatting A Line And Controlling Its Behaviour
  • 0605 Adding And Formatting A Box
  • 0606 Adding A Box That Crosses Section Boundaries
  • 0607 Adding A Company Logo Or Other Image
  • 0608 Adding Data Fields To Non Data Text Boxes
  • 0609 Removing Non Data Items

• 07. Sorting Data

  • 0701 How To Sort By A Field On The Report
  • 0702 Sorting By More Than One Field
  • 0703 Sorting By Fields NOT Visible On The Report
  • 0704 Removing Sort Criteria

• 08. Filtering Report Data

  • 0801 Filtering A Field By Existing Values
  • 0802 Using The Different Comparison Operators With Text Fields
  • 0803 Filtering The Data By Date Fields
  • 0804 Filtering Numeric Fields
  • 0805 Removing Filters From The Report
  • 0806 Filtering By More Than One Field
  • 0807 Multiple Field Criteria And/Or
  • 0808 Using A Wildcard In Filter Criteria
  • 0809 Filtering For Empty(NULL) Fields

• 09. Grouping Reports

  • 0901 What Is Grouping
  • 0902 How To Add A Group
  • 0903 Formatting The Group Name
  • 0904 Enhancing The Group Header
  • 0905 Grouping A Report On Dates Or Time
  • 0906 Creating Multiple Level Groups
  • 0907 Removing A Group
  • 0908 Changing The Group Sort Order
  • 0909 Customizing Group Heading Labels
  • 0910 Group Preview Options
  • 0911 Specifying Your Own Groups
  • 0912 Swapping The Data Field For A Group

• 10. Summarizing Data

  • 1001 Inserting A Grand Total Field
  • 1002 Insert A Sub Total Field
  • 1003 The Effects Of Moving Summary Fields Within A Report
  • 1004 Displaying Sub Totals As A Percentage Of Grand Totals
  • 1005 Summary Fields Using Average Minimum Or Maximum
  • 1006 Creating A Summary Report By Hiding Details
  • 1007 Creating A Drilldown Report
  • 1008 Refreshing A Drilldown Report
  • 1009 Sorting Group Based On Summary Values Not Group Values
  • 1010 Using Top Or Bottom N To Filter Summary Data

• 11. Using Parameters In Reports

  • 1101 What Are Parameters
  • 1102 Adding A Free Text Parameter Field
  • 1103 Using A Text Parameter To Filter Data
  • 1104 Number Parameter Fields For Filtering
  • 1105 Date Fields Used In Parameters
  • 1106 Creating And Using A Pick List Parameter
  • 1107 Creating And Using A Dynamic Pick List
  • 1108 Multiple Parameter Fields
  • 1109 Deleting Parameter Fields

• 12. Formula Fields

  • 1201 Creating A Formula To Enhance A Report
  • 1202 Altering And Renaming A Formula Field
  • 1203 Deleting A Formula Field
  • 1204 Creating A Formula To Concatenate
  • 1205 String Manipulation Formula In Action
  • 1206 Date Formula In Action
  • 1207 Calculating Age With Crystal Reports
  • 1208 Sorting And Filtering With A Formula Field
  • 1209 Using Formula Fields While Grouping
  • 1210 Formula And Parameter Fields Working Together
  • 1211 Conditions Within Formulas
  • 1212 Using IF To Negate A NULL Concatenation

• 13. Section Formatting

  • 1301 Report Header And Footer Options
  • 1302 Formatting Options Of The Page Header And Footer
  • 1303 Group Header And Footer Settings
  • 1304 Details Section Formatting Including Multiple Columns

• 14. The Standard Report Wizard

  • 1401 The Steps Involved In The Standard Report Wizard
  • 1402 Editing A Report Generated By The Wizard
  • 1403 Using The Report Templates On Your Own Reports

• 15. Data Table Linking

  • 1501 Quick Overview Of Relational Databases
  • 1502 Visual Linking In Crystal Reports
  • 1503 Warning Watch For Cartesian Joins
  • 1504 Link Types And Their Effect
  • 1505 Removing Tables From A Report

• 16. Distributing The Report

  • 1601 Choosing The Appropriate Export Format
  • 1602 Export Directly To Email
  • 1603 Exporting Data Into 2007/2010 Excel xlsx Format
  • 1604 Exporting To The New Read Only Format To Protect Report Design

• 17. The Workbench

  • 1701 Opening The Workbench
  • 1702 Adding Projects And Reports To The Workbench
  • 1703 Managing Reports Within The Workbench

In this SAP Crystal Reports 2011 Training Video, veteran trainer Guy Vaccaro teaches you how to use this powerful enterprise-level business intelligence software. You will learn how to connect to your data sources, design reports, and distribute your reports as required.

You start by learning the basics of creating a report - making a connection to a database, selecting your tables and views, adding fields, and finally, saving your report. From there, using audio and video training techniques in this computer based training course, Guy teaches you how to format your report, and deal with special field data such as dates, non-data items, and sorting your data. You will continue to learn the features of SAP Crystal Reports 2011 with subjects such as filtering your data, grouping reports together, and using paramaters. Finally, you will explore some more advanced features such as formula fields, using the report wizard, linking data tables, and distributing your report via email, Excel, and more. As a bonus, Guy has included a chapter on how to use the Workbench, included with Crystal Reports.

By the conclusion of this video based training course for SAP Crystal Reports 2011, you will be fully capable of connecting to your data source, and creating rich, informative reports, and distributing these reports. Working files are included, to allow you to work alongside the author as he teaches you the software.