United States Crystal Reports XI: Beginner Tutorials
Online Contents For This Course
We have made some of the video tutorials for
Crystal Reports XI: Beginner
freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
Course Description
Crystal is a user-friendly database reporting tool that allows users to visually create reports and change them to virtually any format imaginable. This allows users with little to no knowledge of SQL or databases to quickly create, distribute, and analyze reports from virtually any data source. In addition, the multiple export formats can ensure that your data can get from point A to point B in almost any format needed. This hands-on Crystal Reports XI: Beginner course by expert instructor Kurt Dunlap will teach you what is needed to start creating reports in Crystal XI right away. The source reports and test database are also provided so that users can follow along with ease. To begin learning today, simply click on the movie links.
Choose your media type:
|
Introduction
|
|||
| Course Introduction | (01:52) | T | |
| What Crystal is and What It is Not | (02:37) | T | |
| What You Will Need | (02:55) | T | |
| A Few Words on Versions | (03:23) | T | |
| CRXI Installation Options | (04:28) | T | |
| Course Overview | (02:52) | T | |
|
Create a Basic Report
|
|||
| Data Connections pt. 1 - ODBC | (04:28) | T | |
| Data Connections pt. 2 - Direct | (04:04) | T | |
| Getting to Know Your Data Source | (03:47) | T | |
| Report Wizard pt. 1 - Tables & Fields | (03:38) | T | |
| Report Wizard pt. 2 - Group & Filter | (06:05) | T | |
|
Designing a Basic Report
|
|||
| The CRXI Work Area | (04:04) | T | |
| Layout & Presentation | (04:49) | T | |
| Basic Formatting | (04:33) | T | |
| Basic Grouping & Sorting | (05:04) | T | |
| Summary Functions | (04:48) | T | |
| Inserting Objects into Reports | (04:33) | T | |
| Previewing & Exporting Reports | (05:49) | T | |
|
Create a Report Beyond the Basics
|
|||
| Report Wizard pt. 3 - Multiple Tables | (04:40) | T | |
| Report Wizard pt. 4 - Multiple Filtering | (05:52) | T | |
| Grouping Data pt. 1 | (06:06) | T | |
| Grouping Data pt. 2 | (04:18) | T | |
| Inserting Summaries | (05:39) | T | |
| Fields - Dimensions vs. Metrics | (03:13) | T | |
| Select Expert | (04:29) | T | |
| Export Options | (03:34) | T | |
|
Design a Report Beyond the Basics 1
|
|||
| Report Options | (02:33) | T | |
| Crystal Options pt. 1 | (04:48) | T | |
| Crystal Options pt. 2 | (04:33) | T | |
| Grids & Layout Options | (05:52) | T | |
| Section Expert | (04:35) | T | |
| Colors/Fonts/Borders | (06:39) | T | |
|
Design a Report Beyond the Basics 2
|
|||
| Graphs & Charts pt. 1 | (05:46) | T | |
| Graphs & Charts pt. 2 | (04:42) | T | |
| Graphic Files | (06:25) | T | |
| Drawing Lines | (05:35) | T | |
| Field Options | (03:33) | T | |
| Special Fields | (05:19) | T | |
| Design Tips pt. 1 | (05:39) | T | |
| Design Tips pt. 2 | (05:17) | T | |
| Report Exercise 1 | (03:07) | T | |
| Report Solution 1 | (06:33) | T | |
|
Fields/Dimensions/Metrics 1
|
|||
| Database Fields | (03:52) | T | |
| User Defined Fields | (03:21) | T | |
| The Formula Editor | (03:47) | T | |
| String Functions | (06:50) | T | |
| Date Funtions | (06:58) | T | |
| Metric Functions | (05:37) | T | |
| Conversion Functions | (04:07) | T | |
| Formula Problem 1 | (01:07) | T | |
| Formula Solution 1 pt. 1 | (05:56) | T | |
| Formula Solution 1 pt. 2 | (02:35) | T | |
|
Fields/Dimensions/Metrics 2
|
|||
| Modifying Fields - Two Methods | (05:30) | T | |
| Working with Dates | (04:24) | T | |
| Working with Strings | (04:39) | T | |
| Working with Numbers | (04:20) | T | |
| Conditional Formula Pitfalls | (03:44) | T | |
| Conditional Formula Problem 1 | (01:14) | T | |
| Conditional Formula Solution 1 pt. 1 | (04:27) | T | |
| Conditional Formula Solution 1 pt. 2 | (02:42) | T | |
|
Filtering Data
|
|||
| Select Expert Reintroduction | (03:43) | T | |
| The Formula Editor for Select Expert | (03:51) | T | |
| Filter Formulas pt. 1 - AND | (02:38) | T | |
| Filter Formulas pt. 2 - OR | (04:20) | T | |
| Filter Formulas pt. 3 - AND & OR | (03:30) | T | |
| Filters - Database vs. User Fields | (05:35) | T | |
| Select Statement Considerations | (02:35) | T | |
| Filter Formula Problem 1 | (01:35) | T | |
| Filter Formula Solution 1 | (04:47) | T | |
|
Report Templates
|
|||
| Template Expert | (03:03) | T | |
| Templates Review | (02:55) | T | |
| Template Limitations | (02:02) | T | |
| Modifing Templates | (03:25) | T | |
| Exporting Template Reports | (05:20) | T | |
|
Modifying a Report
|
|||
| Changing Groups | (03:19) | T | |
| Changing Fields | (03:00) | T | |
| The Database Expert - Adding Tables | (02:55) | T | |
| Database Changes pt. 1 | (02:43) | T | |
| Database Changes pt. 2 | (04:26) | T | |
| Report Performance | (03:58) | T | |
| Database Change Problem 1 | (02:13) | T | |
| Database Change Solution 1 | (03:47) | T | |
|
The Cross Tab Report
|
|||
| Cross Tab pt. 1 - Layout | (05:18) | T | |
| Cross Tab pt. 2 - Functions | (02:53) | T | |
| Cross Tab pt. 3 - Options | (04:48) | T | |
| Cross Tab Formatting | (03:43) | T | |
| Cross Tab Limitations | (03:15) | T | |
| Cross Tab Problem 1 | (01:21) | T | |
| Cross Tab Solution 1 | (04:05) | T | |
|
Excel Export
|
|||
| Preparing Reports for Excel | (06:30) | T | |
| Field Layout & Design | (04:05) | T | |
| Cross Tabs & Excel | (04:25) | T | |
| Exporting to Excel Options | (05:12) | T | |
|
Wrap Up
|
|||
| Crystal Resources | (01:09) | T | |
| About the Author | (01:04) | T | |
Email this Page
Send us FeedbackCourse Information
| Course: | Crystal Reports XI: Beginner |
| Author: | Kurt Dunlap |
| SKU: | 33966 |
| ISBN: | 1-935320-29-7 |
| Release Date: | 2009-02-10 |
| Duration: | 6.5 hrs / 95 tutorials |
| Work Files: |
Yes |
| Captions: | Available on CD and Online University |
Search within Captions
Subscription / Purchase Information
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Sign up for a Free Trial
Full Access Members have full access to VTC.com’s entire library of video tutorials.
If you are already a member, please login here.