Beginners Crystal Reports 2013 & 2011 Tutorial Video

Course Curriculum

Chapter 1: In The Beginning

Lecture 1: Working Files – Download These First

Lecture 2: 0101 What Will I Be Able To Do With Crystal Reports

Lecture 3: 0102 Quick Tour Of Crystal Reports Interface And Toolbars

Lecture 4: 0103 Making Use Of The Included Working Files

Lecture 5: 0104 Installing The Sample Databases Provided

Lecture 6: 0105 Changing The Datasource Of The Working Files

Chapter 2: Setting Up A New Report

Lecture 1: 0201 Starting Crystal Reports And A New Report

Lecture 2: 0202 Setting Page Size Orientation For The Report

Lecture 3: 0203 Making A Connection To The Sample Access Databases

Lecture 4: 0204 Making A Connection To The Sample Excel Files

Lecture 5: 0205 Making A Connection To The Sample SQL Server Database

Lecture 6: 0206 Selecting The Correct Tables or Views

Lecture 7: 0207 Field Explorer And Sections Overview

Lecture 8: 0208 Adding And Removing Fields On The Report

Lecture 9: 0209 Field Masks And Column Header Control

Lecture 10: 0210 Browsing The Data Before Insertion

Lecture 11: 0211 Previewing The Report For The First Time

Lecture 12: 0212 Refreshing The Reports Data

Lecture 13: 0213 Saving The Report

Lecture 14: 0214 Saving The Report Without The Data

Chapter 3: Report Navigation

Lecture 1: 0301 Paging Through The Report

Lecture 2: 0302 Searching For Text Within The Report

Lecture 3: 0303 Changing The Zoom In Preview And Design

Lecture 4: 0304 Using The Group Navigation Pane

Chapter 4: Formatting The Report

Lecture 1: 0401 Moving And Resizing Objects On The Report

Lecture 2: 0402 Using The Guides And Other Alignment Options

Lecture 3: 0403 Snap To Grid Saves The Day

Lecture 4: 0404 Changing The Font Style, Size And Color

Lecture 5: 0405 Adding A Color Border Or Background To Controls

Lecture 6: 0406 Paragraph Settings

Lecture 7: 0407 Number Formatting For Numerical Data Fields

Lecture 8: 0408 Currency Formatting For Money Data Fields

Lecture 9: 0409 Date Formatting Options

Lecture 10: 0410 Using The Format Painter

Lecture 11: 0411 Adding A Hyperlink To A Field

Lecture 12: 0412 Lock The Format Size And Position Of An Object

Lecture 13: 0413 Default Font Formatting Options

Lecture 14: 0414 Default Data Formatting Options

Lecture 15: 0415 Background Colors

Chapter 5: Using The Special Data Fields

Lecture 1: 0501 Adding Special Date Fields

Lecture 2: 0502 Inserting Page Numbers

Lecture 3: 0503 Adding The File Path To The Page Footer

Lecture 4: 0504 Report Author And Title Fields

Lecture 5: 0505 Of What Use Are The Remaining Special Fields

Chapter 6: Adding Non Data Items To A Report

Lecture 1: 0601 Inserting And Editing Text Objects

Lecture 2: 0602 Format Options For A Text Object

Lecture 3: 0603 Adding A Horizontal Or Vertical Line

Lecture 4: 0604 Formatting A Line And Controlling Its Behaviour

Lecture 5: 0605 Adding And Formatting A Box

Lecture 6: 0606 Adding A Box That Crosses Section Boundaries

Lecture 7: 0607 Adding A Company Logo Or Other Image

Lecture 8: 0608 Adding Data Fields To Non Data Text Boxes

Lecture 9: 0609 Removing Non Data Items

Chapter 7: Sorting Data

Lecture 1: 0701 How To Sort By A Field On The Report

Lecture 2: 0702 Sorting By More Than One Field

Lecture 3: 0703 Sorting By Fields NOT Visible On The Report

Lecture 4: 0704 Removing Sort Criteria

Chapter 8: Filtering Report Data

Lecture 1: 0801 Filtering A Field By Existing Values

Lecture 2: 0802 Using The Different Comparison Operators With Text Fields

Lecture 3: 0803 Filtering The Data By Date Fields

Lecture 4: 0804 Filtering Numeric Fields

Lecture 5: 0805 Removing Filters From The Report

Lecture 6: 0806 Filtering By More Than One Field

Lecture 7: 0807 Multiple Field Criteria And/Or

Lecture 8: 0808 Using A Wildcard In Filter Criteria

Lecture 9: 0809 Filtering For Empty(NULL) Fields

Chapter 9: Grouping Reports

Lecture 1: 0901 What Is Grouping

Lecture 2: 0902 How To Add A Group

Lecture 3: 0903 Formatting The Group Name

Lecture 4: 0904 Enhancing The Group Header

Lecture 5: 0905 Grouping A Report On Dates Or Time

Lecture 6: 0906 Creating Multiple Level Groups

Lecture 7: 0907 Removing A Group

Lecture 8: 0908 Changing The Group Sort Order

Lecture 9: 0909 Customizing Group Heading Labels

Lecture 10: 0910 Group Preview Options

Lecture 11: 0911 Specifying Your Own Groups

Lecture 12: 0912 Swapping The Data Field For A Group

Chapter 10: Summarizing Data

Lecture 1: 1001 Inserting A Grand Total Field

Lecture 2: 1002 Insert A Sub Total Field

Lecture 3: 1003 The Effects Of Moving Summary Fields Within A Report

Lecture 4: 1004 Displaying Sub Totals As A Percentage Of Grand Totals

Lecture 5: 1005 Summary Fields Using Average Minimum Or Maximum

Lecture 6: 1006 Creating A Summary Report By Hiding Details

Lecture 7: 1007 Creating A Drilldown Report

Lecture 8: 1008 Refreshing A Drilldown Report

Lecture 9: 1009 Sorting Group Based On Summary Values Not Group Values

Lecture 10: 1010 Using Top Or Bottom N To Filter Summary Data

Chapter 11: Using Parameters In Reports

Lecture 1: 1101 What Are Parameters