O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Crystal Reports XI: Beginner

Video Description

Crystal is a userfriendly 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 handson 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.

Table of Contents

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