30% OFF Marked Prices & FREE Shipping!   -   ENDS 5PM FRIDAY!   -   Use Discount Code 303

Crystal Reports 2011 Beginner to Advanced Tutorial

This discounted bundle includes:
Beginners Crystal Reports 2011 Tutorial
Duration: 9.5 Hours
Video lessons: 128

Advanced Crystal Reports 2011 Tutorial
Duration: 7 hours
Video lessons: 79
A professionally created, self-study video training course
Includes 17 hours of easy to follow Crystal Reports 2011 Beginner to Advanced video tutorials presented by an industry expert.
The training is delivered to your desktop allowing you to learn at a time that suits you and at your own pace.
You can start learning online right away. Sample Crystal Reports 2011 Beginner to Advanced tutorial videos by clicking a blue link below:
COMPLETE COURSE CONTENTS
Free Sample
Section

Click a blue link to evaluate!
Sample Videos from Beginners 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 SAP CR 2011 Tutor
Starting Crystal Reports And A New Report
Setting Page Size Orientation For The Report
Connecting To The Sample Access Databases
Making A Connection To The Sample Excel Files
Connecting 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
Sample Videos from Advanced Crystal Reports 2011
Am I Ready For This Advanced Course
About The CR Tutor
Filtering Data To Reduce The Quantity
Adding Summary Functions
Letting The User Change Color Of Banded Reports
Using A Parameter Value With A Report Alert
Different Headers & Footers On Odd & 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
We hope you enjoyed the free lessons. To view the complete contents, including all lessons below & above, please purchase the course via DVD or Download.
Paid Content
Section

Get all lessons with purchase
Contents from Beginners Crystal Reports 2011
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
Contents from the Advanced Crystal Reports 2011
Introduction
Am I Ready For This Advanced Course
Installing And Connecting To The Sample Databases Provided
Using The Working Files Effectively
About The CR 2011 Tutor
Swapping The Data Source Of A Report

Revision
Creating A Report Without The Wizard
Adding And Linking Multiple Database Tables
Making Use Of Formula Fields
Overriding The Database Default Sort
Filtering Data To Reduce The Quantity
Grouping Data In Reports
Special User Defined Groups
Adding Summary Functions

Conditional Formatting
Using The Highlighting Expert
Changing The Order That Conditions Are Effective
Removing The Highlighting Expert Conditions
Applying On/Off Conditional Formatting
Font Color And Typeface Controlled By A Condition
Edit/Remove/Copy/Disable Conditional Formatting
Create Alternate Page Numbers Through Conditional Formatting
Creating A Banded Report
Formatting Controlled By Summary Values

Parameter Fields
Creating A Parameter Field To Filter Data
Parameter Fields Used To Customize Formatting
Letting The User Change The Color Of Banded Reports
Parameter Controlled Order By
Parameter Masks To Control User Input

Report Alerts
Adding And Triggering A Report Alert
Editing Alerts And Viewing Triggered Values
Use A Formula In The Alert Message
Using A Parameter Value With A Report Alert

Multiple Sections
Creating And Managing Extra Report Sections
Different Headers And Footers On Odd And Even Pages
Use Split Sections To Add A Watermark
Column Headings In Drilldown Reports
Add Continued To Page Header For Multiple Page Groups

Sub Reports
What Is A Sub Report
Creating And Importing Unlinked Sub Reports
Create And Insert A Linked Sub Report
On Demand Sub Reports
Hiding Sub Reports That Contain No Data
Dealing With Overlapping Sub Reports
Methods For Updating Changes Made To Sub Reports

Charting
Creating A Chart
Changing The Chart Type Of Your Chart
Chart Formatting And Label Editing
Multiple Series Of Data In A Chart
Special Groups Within A Chart To Improve Appearance
Using Top N In Charts
Placing Charts In Group Headers And Footers
Managing Multiple Charts In A Report
A Special Chart Type The Pie
Multiple Series Data Using Pie Charts

Cross-Tabs
Adding A Cross Tab To A Report
Generating The Month Name As A Heading
Totals On Or Off Top Or Bottom
Formatting A Cross Tab And Its Components
Use Of Conditional Formatting In A Cross Tab
Cross-Tabs With Group Headers Or Footers
Placing More Than One Cross Tab On A Report
Sorting A Cross Tab By Its Summarized Data
Changing The Calculation Within The Data Area
Use Of A Parameter To Allow User Choice Of Grouping
Insert Multiple Grouping
Cross Tab Wizard Vs Manually Creation
A Quick Chart From A Cross Tab

Advanced Formulas
Declaring Variables To Use In Formulas
Application Of A Variable In A Report
Multi Pass Reporting Explained
Altering The Multi Pass In A Formula
Outputting Multiple Variable Values From One Formula
Using Shared Variables To Exchange Data With A Sub Report
User Defined Functions

SQL And Commands
Standard Query Language (SQL)
Using Your Own SQL As A Reports Data Source
Adding Parameters To User Defined SQL Commands

Summary and Beyond
Investigating The Data Map Tool
Distribute Crystal Reports Viewer To Non Developers
Were You Ready?
  • Tutor: Guy Vaccaro
  • Duration: 17 hours
  • Video lessons: 207
  • Product code: 01716
  • In stock: YES
  • Available on: DVD & Download
  • Work files included: YES
  • Works on: MS Windows PC & Mac
  • Date Released: 21st August 2012
Learn how to create complex reports from your data that contain exactly the data you wish to convey, and also look attractive doing it with the help of these beginner to advanced Crystal Reports 2011 tutorials.

Commencing from the absolute basics and continuing to the advanced techniques, expert CR reporting tutor Guy Vaccaro presents step-by-step training videos that help explain and demonstrate how to use the complete toolset, how to make use of the powerful new features for the 2011 release, and some great workflow techniques that will boost your skills and productivity.

Through over sixteen hours of professionally created video training, the beginner tuition includes a tour of the new interface, how to set up a new script, lessons on sorting data and learning how to group reports. The Advanced course moves onto more complex concepts such as conditional formatting, help with parameter fields, report alerts explained, best practices for multiple sections and a whole lot more.

The complete video training contents is listed below and you can start learning "CR" right away, click any of the blue linked lessons to sample FREE Crystal Reports 2011 training videos and discover how effective this teaching guide is...
What Our Customers Are Saying

"Your training cds have been invaluable and i am going to be ordering some more. I have developed new skills really fast at a low cost. Once again, thanks a lot."Andrew Fast, Freelance Photographer
 
Purchase Info - 30% OFF MARKED PRICE!
The DVD and Download options include the same training contents and both priced as below:
PRICE
CURRENCY
   
 
 
  Item(s):
   
Once purchased, you will receive 207 Crystal Reports 2011 Beginner to Advanced training videos (listed left), lasting a total of 17 hours and the working files.

Worldwide
Shipping
Delivery Details
Download Course downloadable when payment processed (within one hour average)

CD/DVDs No shipping charges. Please allow 2-3 days for UK, Europe, US & Canada. 3-5 days rest of world.
WE AIM TO PLEASE
All DVD courses have a 100% money back guarantee. If you are not happy with your course contact us within 30 days of purchase for a refund.
View our full product guarantee
|
Need to Train Multiple Users?
This Crystal Reports 2011 Beginner to Advanced course is available in multi-user format ideal for corporate users, schools and universities.

The course loads directly onto your server and delivered to multiple users over your network.

An unlimited number of users can access the training with a pre-determined number viewing the tuition at any one time.

Training Multiple Users

Load onto your server
Deliver on your network or existing learning management system


USING THE SAME EXCELLENT CONTENT AS SINGLE USER COURSES
For companies and educational establishments wanting multi user access to training resources, we offer this Crystal Reports 2011 Beginner to Advanced course to do just that.
Now you can integrate training or technical support within your own computer network, or allow employees or students to gain access to training and support from home or any other location that they can gain access to your organizations network.

EASILY VIEWED OVER A NETWORK
The courses can be played over a LAN using a standard browser such as Microsoft Internet Explorer, Safari or Firefox.
The movies are viewed using Adobe Flash (same method as YouTube) and are slightly compressed in order to not clog the network.
All advanced and the "for dummies" courses are available via this multi user solution and can be copied directly to a hard disk for faster access and the access page may be customized, if needed, using a html editor.

ADDITIONAL USERS AND TITLES CAN BE ADDED
More than one title can exist on your server and the supplied player will automatically show titles that are available.
Simply purchase more user licences (supplied as files) and drop them into the folder. This will automatically increase the number of users allowed onto the system. All purchases are backed up by excellent after-sales support team and easy to follow instruction manual.
You can order multi user online or speak to our knowledgeable sales team.
PRICE
(Per 10 user concurrent licence)
Closely Related Courses
See our complete range of Microsoft Office 2013 Tutorials
See our complete range of Microsoft Project Tutorials
See our complete range of Microsoft Access Tutorials
See our complete range of Microsoft Excel Tutorials
Prove Your Capabilities
Once a course is completed you can download a free certificate.

This certifies that you have started from the beginners level, have now viewed all instruction. The certificate advises you now possess essential skills and an in-depth knowledge of Crystal Reports 2011 Beginner to Advanced. Show your boss or potential employer!
Weekly Special
Promoted Course
View sample videos from the new
AutoCAD 2016
A recent customer speaks out...
"One of the MOST EFFECTIVE training tools out on the market today, BAR NONE!!!!!! (and at an affordable price)."Robert McClain Kansas City, KS