Crystal Reports 2011 Video Tutorial Course Bundle

CareerVision Training

£ 114 - (135 )
inkl. MwSt.

Wichtige informationen

  • Training
  • Beginner
  • Fernunterricht
  • Dauer:
  • Wann:
    Freie Auswahl
  • Versendung von Lernmaterial

• Format: DVD-ROM
• Duration: 16.5 Hours (207 lessons)
• Instructor: Guy Vaccaro
• Platform: Windows PC or Mac

This SAP Crystal Reports 2011 Training Bundle contains:

Learning SAP Crystal Reports 2011
Advanced SAP Crystal Reports 2011 Training

Expert author and trainer Guy Vaccaro takes you right from the basics of Crystal Reports to an advanced level of use in these video based training courses. In the beginners training, you will cover topics such as selecting your tables and views from a database, basic report formatting, sorting data, filtering data, grouping reports and more. In the advanced training course, you will cover advanced report formatting, working with parameter fields, report alerts, advanced charting and formulas and so much more.

Wichtige informationen

Voraussetzungen: This is a DVD Video Tutorial Course which is shipped to you. Work through the video tutorials at your own pace. If you have the software you can practice along with the instructor using the same exercise files as the instructor which are included on the DVD. The narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter. All the concepts of each application are explained clearly and precisely. The DVD works on PC and Mac. You can jump to and from lessons and work at your own pace.


Wo und wann

Beginn Lage
Freie Auswahl
Distance Learning

Was lernen Sie in diesem Kurs?

Report Formatting
Sorting Data
Charting and Formulas
Parameter Fields


01. Learning SAP Crystal Reports 2011 - 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. Learning SAP Crystal Reports 2011 - 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. Learning SAP Crystal Reports 2011 - 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. Learning SAP Crystal Reports 2011 - 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. Learning SAP Crystal Reports 2011 - 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. Learning SAP Crystal Reports 2011 - 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. Learning SAP Crystal Reports 2011 - 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. Learning SAP Crystal Reports 2011 - 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. Learning SAP Crystal Reports 2011 - 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. Learning SAP Crystal Reports 2011 - 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. Learning SAP Crystal Reports 2011 - 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.Learning SAP Crystal Reports 2011 -  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. Learning SAP Crystal Reports 2011 - 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. Learning SAP Crystal Reports 2011 - 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. Learning SAP Crystal Reports 2011 - 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. Learning SAP Crystal Reports 2011 - 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. Learning SAP Crystal Reports 2011 - The Workbench
1701 Opening The Workbench
1702 Adding Projects And Reports To The Workbench
1703 Managing Reports Within The Workbench
01. Advanced SAP Crystal Reports 2011 Training - 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. Advanced SAP Crystal Reports 2011 Training - 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. Advanced SAP Crystal Reports 2011 Training - 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. Advanced SAP Crystal Reports 2011 Training - 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. Advanced SAP Crystal Reports 2011 Training - 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. Advanced SAP Crystal Reports 2011 Training - 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. Advanced SAP Crystal Reports 2011 Training - Advanced SAP Crystal Reports 2011 Training - 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. Advanced SAP Crystal Reports 2011 Training - 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. Advanced SAP Crystal Reports 2011 Training - 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 SAP Crystal Reports 2011 Training - 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. Advanced SAP Crystal Reports 2011 Training - 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. Advanced SAP Crystal Reports 2011 Training - Summary and Beyond
1201 Investigating The Data Map Tool
1202 Distribute Crystal Reports Viewer To Non Developers
1203 Were You Ready?