Comprehensive Video Tutorials

Crystal Reports 2011 Training Bundle

CareerVision Training
Online

£120 - (R$528)

Informação importante

  • Curso
  • Online
  • Duração:
    Flexible
  • Quando:
    à escolha
  • Campus online
Descrição

  The following course, offered by Career vision, will help you improve your skills and achieve your professional goals. During the program you will study different subjects which are deemed to be useful for those who want to enhance their professional career. Sign up for more information!

Informação importante
Instalações

Instalações e datas

Início Localização
à escolha
Online

O que se aprende nesse curso?

Crystal Reports
IT

Programa

 

 •  Format: DVD or Instant Download
 •  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.

By the completion of these computer training videos for Crystal Reports 2011, you will bee fully capable of creating advanced reports from your data that not only contain the information you want to convey, but look good doing it! Working files are included in both courses to allow you to work alongside the author with the same materials he using in the training course..


Benefits of this Software Training:
 •  Tuition by expert tutors.
 •  Narrated training videos demonstrate the key tools and professional techniques
        helping you to work faster and smarter.
 •  Learning is fast as the trainers guide you using simplistic terms and minimal jargon.
 •  Personal Tutoring - Step-by-step video training from your own desktop.
        Delivered via DVD/CD training or online tuition.
 •  The tutor transfers knowledge to you quickly and effectively.
 •  All the concepts of each application are explained clearly and precisely.
 •  Course works on PC and Mac.
 •  Alternative to a boring book or manual and expensive training courses,
        seminars and amp; classes.
 •  Jump to and from lessons - learn at your own pace.
 •  The visual and practical nature shortens the learning curve compared to standard
        training manuals.


 

The following sections are available for free viewing. Click on the links below to get started.

00. Free Videos - Learning SAP Crystal Reports 2011 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 00. Free Videos - Advanced SAP Crystal Reports 2011 Training 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. 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?