MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Beginners Crystal Reports 2013 & 2011 Tutorial Video

Course Summary

Learn How To Use Crystal Reports Quickly. A Comprehensive Crystal Reports Tutorial for Beginners. Covers 2013 & 2011


  • +

    Course Syllabus

    • In The Beginning
      • Working Files - Download These First
      • How To Obtain Your Certificate of Completion
      • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • The Workbench
      • 1701 Opening The Workbench
      • 1702 Adding Projects And Reports To The Workbench
      • 1703 Managing Reports Within The Workbench
      • 1704 Thanks You And Good Bye


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Industry Specific Applications and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top