• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z

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.

Course Crystal Reports XI: Beginner Author Kurt Dunlap SKU 33966 ISBN 1-935320-29-7 Release Date 2009-02-10 Duration 6.50 hrs / 95 tutorials Work files Yes Price $ 49.95 Retail price $ 99.95 Language Tags Crystal Reports,

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 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