Tutorials and Online Training Videos

Crystal Reports XI: Beginner Tutorial


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.

Introduction

Course Introduction
What Crystal is and What It is Not
What You Will Need
A Few Words on Versions
CRXI Installation Options
Course Overview

Create a Basic Report

Data Connections pt. 1 - ODBC
Data Connections pt. 2 - Direct
Getting to Know Your Data Source
Report Wizard pt. 1 - Tables & Fields
Report Wizard pt. 2 - Group & Filter

Designing a Basic Report

The CRXI Work Area
Layout & Presentation
Basic Formatting
Basic Grouping & Sorting
Summary Functions
Inserting Objects into Reports
Previewing & Exporting Reports

Create a Report Beyond the Basics

Report Wizard pt. 3 - Multiple Tables
Report Wizard pt. 4 - Multiple Filtering
Grouping Data pt. 1
Grouping Data pt. 2
Inserting Summaries
Fields - Dimensions vs. Metrics
Select Expert
Export Options

Design a Report Beyond the Basics 1

Report Options
Crystal Options pt. 1
Crystal Options pt. 2
Grids & Layout Options
Section Expert
Colors/Fonts/Borders

Design a Report Beyond the Basics 2

Graphs & Charts pt. 1
Graphs & Charts pt. 2
Graphic Files
Drawing Lines
Field Options
Special Fields
Design Tips pt. 1
Design Tips pt. 2
Report Exercise 1
Report Solution 1

Fields/Dimensions/Metrics 1

Database Fields
User Defined Fields
The Formula Editor
String Functions
Date Funtions
Metric Functions
Conversion Functions
Formula Problem 1
Formula Solution 1 pt. 1
Formula Solution 1 pt. 2

Fields/Dimensions/Metrics 2

Modifying Fields - Two Methods
Working with Dates
Working with Strings
Working with Numbers
Conditional Formula Pitfalls
Conditional Formula Problem 1
Conditional Formula Solution 1 pt. 1
Conditional Formula Solution 1 pt. 2

Filtering Data

Select Expert Reintroduction
The Formula Editor for Select Expert
Filter Formulas pt. 1 - AND
Filter Formulas pt. 2 - OR
Filter Formulas pt. 3 - AND & OR
Filters - Database vs. User Fields
Select Statement Considerations
Filter Formula Problem 1
Filter Formula Solution 1

Report Templates

Template Expert
Templates Review
Template Limitations
Modifing Templates
Exporting Template Reports

Modifying a Report

Changing Groups
Changing Fields
The Database Expert - Adding Tables
Database Changes pt. 1
Database Changes pt. 2
Report Performance
Database Change Problem 1
Database Change Solution 1

The Cross Tab Report

Cross Tab pt. 1 - Layout
Cross Tab pt. 2 - Functions
Cross Tab pt. 3 - Options
Cross Tab Formatting
Cross Tab Limitations
Cross Tab Problem 1
Cross Tab Solution 1

Excel Export

Preparing Reports for Excel
Field Layout & Design
Cross Tabs & Excel
Exporting to Excel Options

Wrap Up

Crystal Resources
About the Author


Related Books on Crystal Reports XI: Beginner







Save $80 on the
DROID BIONIC
by Motorola with Verizon Wireless service for less than from Verizon Wireless directly.
Save $80 on DROID BIONIC
More Cell Phone Discounts