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

Crystal Reports 2008 Beginner to Advanced Tutorial

This discounted bundle includes:
Beginners Crystal Reports 2008 Tutorial
Duration: 7.5 Hours
Video lessons: 152

Advanced Crystal Reports 2008 Tutorial
Duration: 6.5 hours
Video lessons: 85
A professionally created, self-study video training course
Includes 14 hours of easy to follow Crystal Reports 2008 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 2008 Beginner to Advanced tutorial videos by clicking a blue link below:
COMPLETE COURSE CONTENTS
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 2008
Formatting The Report
Selecting Objects For Formatting Or Resizing
Moving Objects
Resizing Objects
Using The Guides
Using The Grid
Changing The Font Style, Size And Colour - Lesson 1
Changing The Font Style, Size And Colour - Lesson 2
Adding A Colour Border Or Background To Controls
Adding A Hyperlink To A Control
Changing The Paragraph Settings
Number Formatting For Numerical Data Fields
Currency Formatting For Money Data Fields
Date Formatting For Date Data Fields
Using The Format Painter
Aligning And Resizing Multiple Controls On A Report
Setting Default Formatting For Reports
Editing The Layout Default Options

Using The Special Data Fields
Adding Data Date And Data Time Fields
Using The Print Date And Print Time Fields
Inserting Page Numbering
Adding The File Path To The Page Footer
Overview Of The Remaining Special Fields

Adding Non Data Items To A Report
Inserting And Editing Text Objects
Format Options For A Text Box
Adding Labels To Special Fields
Adding A Horizontal Line
Adding A Vertical Line
Formatting A Line
Controlling A Lines Behaviour
Controlling A Lines Position
Adding A Box
Adding A Box That Crosses Section Boundaries
Formatting A Box
Controlling A Box's Behaviour
Controlling The Size And Position Of A Box
Adding A Company Logo Or Other Image
Removing A Non Data Item

Sorting Data In A Report
How To Sort By A Field On The Report
Sorting By More Than One Field
Sorting By Data Fields Not Visible On The Report
Removing Or Changing The Sort Criteria

Filtering The Data That A Report Is Using
The Basics Of Filtering The Data
Filtering A Field By Existing Values
Filtering A Field By More Than One Value
Filtering The Data By Dates
Filtering Numeric Fields
Filtering Field Criteria Using And
Filtering Field Criteria Using Or
Editing Filters With The Select Expert
Removing Filters From The Report
Other Text Data Field Filter Options
Filtering For Nulls
Using A Wildcard In Filter Criteria

Reporting By Groups
Understanding Grouping
How To Add A Group
Group Labels And Headings
Creating A Multiple Level Group
Removing A Group
Changing The Group Sort Order
Changing The Group Name That Is Displayed
Group Preview Options
Utilizing The Group Tree Navigation Panel
Specifying Your Own Groups
Swapping The Data Field For A Group

Summarizing Data
Insert A Grand Total Field
Insert A Sub Total Field
Moving Summary Fields Within The Report
Displaying Sub Totals As A Percentage Of Grand Totals
Summary Fields Using Average, Min Or Max
Creating A Summary Report By Hiding Details
Creating A Drilldown Report
Refreshing A Drilldown Report
Sorting A Group With Summary Fields
Using Top N To Filter Summary Data
Creating A Top 10 List Of Products

Using Parameters In Reports
The Benefits Of Using Parameters
How To Add A Free Text Parameter Field
Using A String Parameter To Filter Data Records
Using A Numeric Parameter To Filter Data Records
Using A Date Parameter To Filter Data Records
Using A Parameter Field With Wildcards
Creating And Using A Pick List Parameter Field
Creating A Dynamic Pick List
Deleting A Parameter Field
Controlling The Request Order For Parameters
The Parameter View Panel

Formula Fields
How To Create Your Own Fields
A Basic Formula To Enhance The Report
Altering Or Renaming A Formula Field
Deleting A Formula
Creating A Formula To Concatenate - Lesson 1
Creating A Formula To Concatenate - Lesson 2
String Manipulation Formulas In Action
Date Formulas At Their Best
Calculating Age With Crystal Reports
Using Formula Fields In The Sort Expert And The Select Expert
Using Formula Fields While Grouping
Making The Formula Field Work With If And Else
Converting Datetime To Date Format To Improve Parameters
Creating An Address Formula With Carriage Returns

Section Formatting
The Report Header And Report Footer Options
Exploring The Formatting Options Of The Page Header And Footer
The Details Section Expert
How To Add A Watermark To A Report
Improving Headings In Drilldowns Using The Section Expert

The Standard Report Wizard
The Steps Involved In The Standard Report Wizard
The Report Template Expert

Data Table Linking
Quick Overview Of Relational Databases
Visual Linking In Crystal Reports
How To Identify Key Fields
Link Types And Their Effects When Used
Removing Links And Tables From The Report

Distributing The Report
Choosing Your Export Format
Export Directly To An Email
Export Directly To Microsoft Excel
Other Export Destinations

The Workbench
Opening The Workbench
Adding Projects To The Workbench
Managing Your Reports Using The Workbench
Removing Reports From The Workbench

Credits And Beyond
About The Trainer
Using The Files Included With This Course
Further Practice - Lesson 1
Further Practice - Lesson 2
What's Next?
CR 2008 Tutorial Wrap Up
Contents from the Advanced Crystal Reports 2008
Advanced Formulas Using Variables
Declaring Variables To Use In Reports
Understanding The Multiple Pass Report Generation
Making Use Of Multi-Pass In A Report
Using And Outputting Multiple Variables At Once
Using Variables In Multiple Formulas And Locations
Creating And Using User Defined Functions

SQL And Commands
Standard Query Language (SQL)
Defining Your Own SQL As The Data Source
Adding Parameters To Your Own SQL Statement

Parameter Fields
Creating A Parameter Field And Using It To Filter Data
Parameter Fields To Customize Formatting
Letting The User Change The Color Of Banded Reports
Parameter Controlled Sort Order
Making Use Of Masks In Parameters

Report Alerts
Adding An Alert To A Report
Triggering A Report Alert
Viewing Record Sets Created By Alerts
Add A Formula To Generate The Alert Message
Using A Parameter Value With A Report Alert

Multiple Sections
Inserting Extra Sections By Dividing Existing Sections
Deleting And Merging Sections
Splitting Existing Content Between Sections
Moving A Sections Position In A Report
Uses For Multiple Page Header Footer Sections
Multiple Sections Can Provide Column Headings In Drilldown Reports
Adding Continued To Page Heading When Required

Sub Reports
What Is A Sub Report
Creating And Importing An Unlinked Sub Report
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 The Sub Report
Pass Data Between Sub And Main Report Using Variables

Cross Tabs
Adding A Cross Tab To A Report
Cross Tabs Within Group Headers Or Footers
Generating A Month Name Instead Of A Number
Making Use Of Formulas In Cross Tabs
Utilizing A Parameter Field To Control A Cross Tab
Formatting A Cross Tab And Its Components
Turning On And Off Totals
Change The Calculation Between The Rows And Columns
Placing More Than One Cross Tab On A Report
Sorting A Crosstab By The Summarized Data
Insert Multiple Rows And Or Columns
Use The Step By Step Crosstab Wizard

Charting
Creating A Chart in CR 2008
Changing The Chart Type
Formatting And Renaming The Chart Labels
Customize The Appearance Of A Given Chart
Sorting And Top N In Charts
Placing Charts Within Group Headers Or Footers
Managing Multiple Charts In A Report
A Special Case The Pie Chart
Charts Based On Cross Tabs

Crystal Reports Reader And Automated Report Distributor
Downloading The Reader And The Automated Report Distributor
Installing The Reader And The Distributor (CRD)
Report Viewer File Management
Running Reports In The Viewer
Exporting Data From The Reader
Filtering Data With The Reader
Setup And Configure CRD
Create A Simple Single Report Daily Schedule
  • Tutor: Guy Vaccaro
  • Duration: 14 hours
  • Video lessons: 237
  • Product code: 01619
  • In stock: YES
From the absolute basics to the advanced and powerful features, these Crystal Reports training videos will teach you all you need to need to know and more! Presented by expert tutor Guy Vaccaro, he uses easy-to-follow video training movies to help break down and demonstrate the complexities of Crystal Reports 2008, helping you to create incredibly complex and beautiful reports and help you to become comfortable with the advanced uses of this powerful reporting software. In over 14 hours of professionally created video training, the tuition includes a tour of the interface, lessons on importing data into CR 2008, setting up your report, how to format your report, knowing your way round your report, formula fields, charting, lessons on Sub Reports and so much more. You can view the full 237 training movies below and start learning right away, click any of the blue linked lessons to sample FREE Crystal Reports training videos...
What Our Customers Are Saying

"By the way I did try one of your sample demos and I really like how the lessons are presented, LOVE the background info provided on the lesson. I am a 'Dinosaur' in this business that needs to retrain, (darn!) and I was able to follow the instructor no problem. Thanks."Mayra Rosas, Indiana
 
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 237 Crystal Reports 2008 Beginner to Advanced training videos (listed left), lasting a total of 14 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 2008 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 2008 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 2008 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...
"I'm very happy that i bought this training for Pro Tools. Before i purchased this, i was very undecided what to buy, there are so many out there. But I'm glad that i decided on this one, it's very nice & clear, and above all his sense of humor...I would defiantly recommend this to other people."Solomon Wechter, New York