Crystal Reports 2011

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