Crystal Reports 2011 TrainingCareerVision Training
£ 72 - (Rs 6,223)
- Online campus
What you'll learn on the course
• Format: DVD or Instant Download
• Duration: 9.5 Hours (128 lessons)
• Instructor: Guy Vaccaro
• Platform: Windows PC or Mac
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.
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
The following sections are available for free viewing. Click on the links below to get started.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 In The Beginning What Will I Be Able To Do With Crystal Reports Quick Tour Of The SAP 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 Crystal Reports Tutor Setting Up A New Report 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 Report Navigation Paging Through The Report Searching For Text Within The Report Changing The Zoom In Preview And Design Using The Group Navigation Pane Formatting The Report Moving And Resizing Objects On The Report Using The Guides And Other Alignment Options Snap To Grid Saves The Day Changing The Font Style, Size And Color Adding A Color Border Or Background To Controls Paragraph Settings Number Formatting For Numerical Data Fields Currency Formatting For Money Data Fields Date Formatting Options Using The Format Painter Adding A Hyperlink To A Field Lock The Format Size And Position Of An Object Default Font Formatting Options Default Data Formatting Options Background Colors Using The Special Data Fields Adding Special Date Fields Inserting Page Numbers Adding The File Path To The Page Footer Report Author And Title Fields Of What Use Are The Remaining Special Fields Adding Non Data Items To A Report Inserting And Editing Text Objects Format Options For A Text Object Adding A Horizontal Or Vertical Line Formatting A Line And Controlling Its Behaviour Adding And Formatting A Box Adding A Box That Crosses Section Boundaries Adding A Company Logo Or Other Image Adding Data Fields To Non Data Text Boxes Removing Non Data Items Sorting Data How To Sort By A Field On The Report Sorting By More Than One Field Sorting By Fields NOT Visible On The Report Removing Sort Criteria Filtering Report Data Filtering A Field By Existing Values Using The Different Comparison Operators With Text Fields Filtering The Data By Date Fields Filtering Numeric Fields Removing Filters From The Report Filtering By More Than One Field Multiple Field Criteria And/Or Using A Wildcard In Filter Criteria Filtering For Empty(NULL) Fields Grouping Reports What Is Grouping How To Add A Group Formatting The Group Name Enhancing The Group Header Grouping A Report On Dates Or Time Creating Multiple Level Groups Removing A Group Changing The Group Sort Order Customizing Group Heading Labels Group Preview Options Specifying Your Own Groups Swapping The Data Field For A Group Summarizing Data Inserting A Grand Total Field Insert A Sub Total Field The Effects Of Moving Summary Fields Within A Report Displaying Sub Totals As A Percentage Of Grand Totals Summary Fields Using Average Minimum Or Maximum Creating A Summary Report By Hiding Details Creating A Drilldown Report Refreshing A Drilldown Report Sorting Group Based On Summary Values Not Group Values Using Top Or Bottom N To Filter Summary Data Using Parameters In Reports What Are Parameters Adding A Free Text Parameter Field Using A Text Parameter To Filter Data Number Parameter Fields For Filtering Date Fields Used In Parameters Creating And Using A Pick List Parameter Creating And Using A Dynamic Pick List Multiple Parameter Fields Deleting Parameter Fields Formula Fields Creating A Formula To Enhance A Report Altering And Renaming A Formula Field Deleting A Formula Field Creating A Formula To Concatenate String Manipulation Formula In Action Date Formula In Action Calculating Age With Crystal Reports Sorting And Filtering With A Formula Field Using Formula Fields While Grouping Formula And Parameter Fields Working Together Conditions Within Formulas Using IF To Negate A NULL Concatenation Section Formatting Report Header And Footer Options Formatting Options Of The Page Header And Footer Group Header And Footer Settings Details Section Formatting Including Multiple Columns The Standard Report Wizard The Steps Involved In The Standard Report Wizard Editing A Report Generated By The Wizard Using The Report Templates On Your Own Reports Data Table Linking Quick Overview Of Relational Databases Visual Linking In Crystal Reports Warning Watch For Cartesian Joins Link Types And Their Effect Removing Tables From A Report Distributing The Report Choosing The Appropriate Export Format Export Directly To Email Exporting Data Into / Excel xlsx Format Exporting To The New Read Only Format To Protect Report Design The Workbench Opening The Workbench Adding Projects And Reports To The Workbench Managing Reports Within The Workbench