Introduction
Course Introduction (01:52)
What Crystal is and What It is Not (02:37)
What You Will Need (02:55)
A Few Words on Versions (03:23)
CRXI Installation Options (04:28)
Course Overview (02:52)
Create a Basic Report
Data Connections pt. 1 - ODBC (04:28)
Data Connections pt. 2 - Direct (04:04)
Getting to Know Your Data Source (03:47)
Report Wizard pt. 1 - Tables & Fields (03:38)
Report Wizard pt. 2 - Group & Filter (06:05)
Designing a Basic Report
The CRXI Work Area (04:04)
Layout & Presentation (04:49)
Basic Formatting (04:33)
Basic Grouping & Sorting (05:04)
Summary Functions (04:48)
Inserting Objects into Reports (04:33)
Previewing & Exporting Reports (05:49)
Create a Report Beyond the Basics
Report Wizard pt. 3 - Multiple Tables (04:40)
Report Wizard pt. 4 - Multiple Filtering (05:52)
Grouping Data pt. 1 (06:06)
????: AllOutWarez.com http://www.alloutwarez.com/showthread.php?t=47712
????: AllOutWarez.com http://www.alloutwarez.com/showthread.php?t=47712
Grouping Data pt. 2 (04:18)
Inserting Summaries (05:39)
Fields - Dimensions vs. Metrics (03:13)
Select Expert (04:29)
Export Options (03:34)
Design a Report Beyond the Basics 1
Report Options (02:33)
Crystal Options pt. 1 (04:48)
Crystal Options pt. 2 (04:33)
Grids & Layout Options (05:52)
Section Expert (04:35)
Colors/Fonts/Borders (06:39)
Design a Report Beyond the Basics 2
Graphs & Charts pt. 1 (05:46)
Graphs & Charts pt. 2 (04:42)
Graphic Files (06:25)
Drawing Lines (05:35)
Field Options (03:33)
Special Fields (05:19)
Design Tips pt. 1 (05:39)
Design Tips pt. 2 (05:17)
Report Exercise 1 (03:07)
Report Solution 1 (06:33)
Fields/Dimensions/Metrics 1
Database Fields (03:52)
User Defined Fields (03:21)
The Formula Editor (03:47)
String Functions (06:50)
Date Funtions (06:58)
Metric Functions (05:37)
Conversion Functions (04:07)
Formula Problem 1 (01:07)
Formula Solution 1 pt. 1 (05:56)
Formula Solution 1 pt. 2 (02:35)
Fields/Dimensions/Metrics 2
Modifying Fields - Two Methods (05:30)
Working with Dates (04:24)
Working with Strings (04:39)
Working with Numbers (04:20)
Conditional Formula Pitfalls (03:44)
Conditional Formula Problem 1 (01:14)
Conditional Formula Solution 1 pt. 1 (04:27)
Conditional Formula Solution 1 pt. 2 (02:42)
Filtering Data
Select Expert Reintroduction (03:43)
The Formula Editor for Select Expert (03:51)
Filter Formulas pt. 1 - AND (02:38)
Filter Formulas pt. 2 - OR (04:20)
Filter Formulas pt. 3 - AND & OR (03:30)
Filters - Database vs. User Fields (05:35)
Select Statement Considerations (02:35)
Filter Formula Problem 1 (01:35)
Filter Formula Solution 1 (04:47)
Report Templates
Template Expert (03:03)
Templates Review (02:55)
Template Limitations (02:02)
Modifing Templates (03:25)
Exporting Template Reports (05:20)
Modifying a Report
Changing Groups (03:19)
Changing Fields (03:00)
The Database Expert - Adding Tables (02:55)
Database Changes pt. 1 (02:43)
Database Changes pt. 2 (04:26)
Report Performance (03:58)
Database Change Problem 1 (02:13)
Database Change Solution 1 (03:47)
The Cross Tab Report
Cross Tab pt. 1 - Layout (05:18)
Cross Tab pt. 2 - Functions (02:53)
Cross Tab pt. 3 - Options (04:48)
Cross Tab Formatting (03:43)
Cross Tab Limitations (03:15)
Cross Tab Problem 1 (01:21)
Cross Tab Solution 1 (04:05)
Excel Export
Preparing Reports for Excel (06:30)
Field Layout & Design (04:05)
Cross Tabs & Excel (04:25)
Exporting to Excel Options (05:12)
Wrap Up
Crystal Resources (01:09)
About the Author (01:04)


Links checked on 02/07/09 by link checker bot
Links checked on 07/08/09 by Maintenance Bot