Online Courses to Develop Yourself & Advance Your Career at CareerBuilder Institute.

Crystal Reports

Learn to create informational reports, output from a database, create custom reports, lists, and more. Get started today!

Price:  $49.00

Availability:  Unlimited use for 90 Days!

Learn to create informational reports, output from a database, create custom reports, lists, and more. Get started today!

500MHz Pentium or faster with 512MB Ram (1GB recommended) 1024 x 768 minimum monitor screen resolution with 16-bit video card Windows 2000, XP or later MAC Compatible Broadband connection (256 kbps or greater) connection recommended Internet Explorer 6.0+ or Firefox 2.0+ Flash Player 9.0+ required for most courses Sound card with speakers or headphones for audio playback Browser JavaScript must be enabled

Crystal Reports 10: Level 1

TOPICS COVERED:

Course Introduction
  • 104018 - Course Introduction
Creating a Report
  • 104019 - Lesson Introduction
  • 104020 - Set Default Report Settings
  • 104021 - Specify Fields for a New Report
  • 104022 - Preview the Report
  • 104023 - Modify Field Display
  • 104024 - Add a Report Title
  • 104025 - Position Fields
  • 104026 - Add Fields from Additional Tables
  • 104027 - Lesson Lab Creating a Report
  • 104028 - Lesson Follow Up
Displaying Specific Report Data
  • 104029 - Lesson Introduction
  • 104030 - Find Data
  • 104031 - Sort Data
  • 104032 - Filter Data by Single Criteria
  • 104033 - Lesson Lab Sorting and Filtering Data
  • 104034 - Lesson Follow Up
Grouping Report Data
  • 104035 - Lesson Introduction
  • 104036 - Insert a Group
  • 104037 - Add Summaries
  • 104038 - Format Summary Information
  • 104039 - Change Group Options
  • 104040 - Add an Additional Group
  • 104041 - Filter by Group
  • 104042 - Create a Top N Sort Group
  • 104043 - Lesson Lab Updating a Report with Grouping
  • 104044 - Lesson Follow Up
Building Formulas
  • 104045 - Lesson Introduction
  • 104046 - Write a Formula
  • 104047 - Edit a Formula
  • 104048 - Group by Formula
  • 104049 - Delete a Formula
  • 104050 - Build a Filter by Multiple Criteria
  • 104051 - Modify a Filter with Multiple Criteria to Create an OR Condition
  • 104052 - Create a Parameter Field
  • 104053 - Write a Formula that Incorporates Null Fields
  • 104054 - Lesson Lab Creating Formulas
  • 104055 - Lesson Follow Up
Formatting Reports
  • 104056 - Lesson Introduction
  • 104057 - Remove White Space
  • 104058 - Insert Page Header/Footer Data
  • 104059 - Add Borders and Lines
  • 104060 - Change the Background Color
  • 104061 - Change the Margins
  • 104062 - Lesson Lab Applying Various Formatting
  • 104063 - Lesson Follow Up
Enhancing Reports
  • 104064 - Lesson Introduction
  • 104065 - Create a Section to Contain a Watermark
  • 104066 - Insert Objects Using Object Linking and Embedding
  • 104067 - Modify Format Based on Data Value
  • 104068 - Conditionally Suppress Data
  • 104069 - Insert Hyperlinks
  • 104070 - Hide Blank Report Sections
  • 104071 - Lesson Lab Enhancing a Report
  • 104072 - Lesson Follow Up
Creating and Modifying Pie Charts
  • 104073 - Lesson Introduction
  • 104074 - Create a Pie Chart with a Drill-down
  • 104075 - Modify Chart Text
  • 104076 - Format a Chart
  • 104077 - Present a Chart by Group
  • 104078 - Lesson Lab Creating a Pie Chart
  • 104079 - Lesson Follow Up
Distributing Data
  • 104080 - Lesson Introduction
  • 104081 - Export to PDF
  • 104082 - Export to Excel
  • 104083 - Export to an Access Database
  • 104084 - Create a Report Definition
  • 104085 - Create Mailing Labels
  • 104086 - Lesson Lab Exporting Reports and Creating Report Definitions
  • 104087 - Lesson Follow Up
Course Follow Up
  • 104088 - Course Follow Up

Course Length:  498 minutes


Crystal Reports 10: Level 2

TOPICS COVERED:

Course Introduction
  • 108325 - Course Introduction
Creating Running Totals
  • 108326 - Lesson Introduction
  • 108327 - Create a Running Total Field
  • 108328 - Modify a Running Total Field
  • 108329 - Create a Manual Running Total on Detail Data
  • 108330 - Create a Manual Running Total on Summary Data
  • 108331 - Lesson Lab Creating Running Totals
  • 108332 - Lesson Followup
Building Cross-tabs in a Report
  • 108333 - Lesson Introduction
  • 108334 - Create a Cross-tab
  • 108335 - Create a Specified Group Order
  • 108336 - Filter a Cross-tab by Group
  • 108337 - Change the Cross-tab Format
  • 108338 - Conditionally Format Rows and Columns
  • 108339 - Keep Groups Together
  • 108340 - Lesson Lab Building Cross-tabs in a Report
  • 108341 - Lesson Followup
Adding Subreports
  • 108342 - Lesson Introduction
  • 108343 - Insert a Subreport
  • 108344 - Link a Subreport to Data in a Primary Report
  • 108345 - Edit a Subreport
  • 108346 - Format a Subreport Using the Format Editor
  • 108347 - Share Formulas Between Main and Subreports
  • 108348 - Create an On-demand Subreport
  • 108349 - Lesson Lab Adding Subreports
  • 108350 - Lesson Followup
Creating Drill-downs
  • 108351 - Lesson Introduction
  • 108352 - Create a Drill-down
  • 108353 - Create Separate Headings for Drill-down Data
  • 108354 - Lesson Lab Creating a Drill-down
  • 108355 - Lesson Followup
Enhancing Report Processing Using SQL
  • 108356 - Lesson Introduction
  • 108357 - Create a Report Using SQL Queries
  • 108358 - Summarize Report Data Using SQL Aggregate Functions
  • 108359 - Create Joins Using SQL
  • 108360 - Create Subqueries
  • 108361 - Create a SQL Expression Field to Promote Server-side Processing
  • 108362 - Lesson Lab Enhancing Report Processing Using SQL
  • 108363 - Lesson Followup
Charting Data
  • 108364 - Lesson Introduction
  • 108365 - Create a Chart
  • 108366 - Modify a Chart
  • 108367 - Create a Top N Chart
  • 108368 - Format a Chart
  • 108369 - Create a Chart Template
  • 108370 - Lesson Lab Creating Multiple Data Series Charts
  • 108371 - Lesson Followup
Reporting on Excel Data
  • 108372 - Lesson Introduction
  • 108373 - Create a Report Based on Excel Data
  • 108374 - Modify a Report Generated from Excel Data
  • 108375 - Update Data in a Report Based on Excel Data
  • 108376 - Lesson Lab Reporting on Excel Data
  • 108377 - Lesson Followup
Course Follow Up
  • 108378 - Course Follow Up

Course Length:  418 minutes


Crystal Reports 8.0: Advanced

TOPICS COVERED:

Conditional Formatting
  • 23809 - Conditional Formatting
  • 23810 - Using the Highlighting Expert and Removing Conditional Formats
Advanced Totals
  • 23811 - Using Variables and Creating Running Total Formulas
  • 23812 - Multiple-Pass Reporting and Using Multiple Variables
Multiple Sections
  • 23813 - Multiple Sections
  • 23814 - Multiple Sections and Conditional Formats
Parameter Fields
  • 23815 - Parameter Fields
  • 23816 - Using Parameter Fields
  • 23817 - Using Parameter Fields to Apply Conditional Formatting
Advanced Cross-Tabs
  • 23818 - Multiple Field Cross-tab Reports
  • 23819 - Using Parameter Fields and Groups with Cross-Tabs
Subreports
  • 23820 - Using Linked and Unlinked Subreports
  • 23821 - Using On-Demand Subreports
SQL/ODBC and Crystal SQL Designer
  • 23822 - SQL/ODBC and Crystal SQL Designer
Crystal Dictionaries and Graphing
  • 23823 - Defining, Using, and Creating Crystal Dictionaries
  • 23824 - Enhancing and Modifying a Dictionary
  • 23825 - Graphing

Course Length:  425 minutes


Crystal Reports 8.0: Basic Skills

TOPICS COVERED:

Overview
  • 23973 - Launching Crystal Reports and Setting Preferences
Creating Basic Reports
  • 23974 - Creating a Report
  • 23975 - Previewing and Formatting Reports
Sorting and Selecting Data
  • 23976 - Sorting and Selecting Data
Grouping and Summarizing Data
  • 23977 - Grouping Data
  • 23978 - Summarizing Data
Using the Report Expert
  • 23979 - Using the Report Expert
  • 23980 - Using the Mail Label Report Expert
Cross-Tab Reports
  • 23981 - Creating a Cross-Tab Report
  • 23982 - Working with Existing Cross-Tabs
Linking
  • 23983 - Creating Links with the Visual Linking Expert
  • 23984 - Understanding Link Options
Creating Formulas
  • 23985 - Creating Formulas
  • 23986 - Creating String and Date Formulas
  • 23987 - Creating Summary Calculations and If Statements
Formatting Sections
  • 23988 - Formatting Sections
  • 23989 - Distributing Data

Course Length:  425 minutes


Crystal Reports 8.5: Advanced

TOPICS COVERED:

Conditional Formatting
  • 36763 - Conditional Formatting
  • 36764 - Using the Highlighting Expert and Removing Conditional Formats
Advanced Formulas
  • 36765 - Using Variables and Creating Running Total Formulas
  • 36766 - Multiple-Pass Reporting and Using Multiple Variables
Multiple Sections
  • 36767 - Creating Multiple Sections
  • 36768 - Multiple Sections and Conditional Formats
Parameter Fields
  • 36769 - Parameter Fields
  • 36770 - Using Parameter Fields
  • 36771 - Using the Like Statement and Applying Conditional Formatting
Report Alerts
  • 36772 - Using Report Alerts
Advanced Cross-Tabs
  • 36773 - Multiple Field Cross-Tab Reports
  • 36774 - Using Parameter Fields and Groups with Cross-Tabs
Subreports
  • 36775 - Using Linked and Unlinked Subreports
  • 36776 - Using On-Demand Subreports
SQL/ODBC and Crystal SQL Designer
  • 36777 - Using SQL/ODBC and Crystal SQL Designer
Crystal Dictionaries and Graphing
  • 36778 - Defining, Using, and Creating Crystal Dictionaries
  • 36779 - Enhancing and Modifying Crystal Dictionaries
  • 36780 - Graphing

Course Length:  216 minutes


Crystal Reports 8.5: Basic Skills

TOPICS COVERED:

Introduction to Crystal Reports
  • 36312 - Report Overview
Creating Basic Reports
  • 36313 - Generating a Report
  • 36314 - Formatting Your Report
  • 36315 - Finalizing Your Report
Sorting and Selecting Data
  • 36316 - Using the Sort Option and Select Expert
Grouping and Summarizing
  • 36317 - Working with Grouping Components and Options
  • 36318 - Summarizing Group Data
Using the Report Expert
  • 36319 - Working with the Report Expert
Cross-Tab Reports
  • 36320 - Creating a Cross-Tab Report
  • 36321 - Working with Cross-Tab Reports
Linking
  • 36322 - Using the Visual Linking Expert
  • 36323 - Link Options
Formulas and Functions
  • 36324 - Working with Formulas
  • 36325 - Working with String and Date/Time Functions
  • 36326 - Working with If Statements and Summary Calculations
Formatting Sections
  • 36327 - Working with Report Sections
Distributing Data
  • 36328 - Report Data Export and Import Options

Course Length:  425 minutes


Crystal Reports 9.0: Level 1

TOPICS COVERED:

Course Introduction
  • 71430 - Course Introduction
Creating a List Report
  • 71431 - Lesson Introduction
  • 71432 - Set Default Report Settings
  • 71433 - Build the Report
  • 71434 - Preview the Report
  • 71435 - Add a Report Title
  • 71436 - Align Fields
  • 71437 - Lesson Lab Creating a Report
  • 71438 - Lesson Followup
Displaying Data in a Report
  • 71439 - Lesson Introduction
  • 71440 - Find Data
  • 71441 - Sort Data
  • 71442 - Filter Data by Single Criteria
  • 71443 - Lesson Lab Sorting and Filtering Data
  • 71444 - Lesson Followup
Grouping Report Data
  • 71445 - Lesson Introduction
  • 71446 - Insert a Group
  • 71447 - Add Summaries
  • 71448 - Change Group Options
  • 71449 - Add an Additional Group
  • 71450 - Format a Group Header
  • 71451 - Filter by Group
  • 71452 - Create a Top N Sort Group
  • 71453 - Lesson Lab Updating a Report with Grouping
  • 71454 - Lesson Followup
Building Formulas
  • 71455 - Lesson Introduction
  • 71456 - Write a Formula
  • 71457 - Edit a Formula
  • 71458 - Group by Formula
  • 71459 - Delete a Formula
  • 71460 - Build a Filter by Multiple Criteria
  • 71461 - Modify a Filter with Multiple Criteria to Create an OR Condition
  • 71462 - Create a Parameter Field
  • 71463 - Write a Formula that Incorporates Null Fields
  • 71464 - Lesson Lab Working with Formulas
  • 71465 - Lesson Followup
Formatting Reports
  • 71466 - Lesson Introduction
  • 71467 - Remove White Space
  • 71468 - Insert Page Header/Footer Data
  • 71469 - Add Borders and Lines
  • 71470 - Change the Background Color
  • 71471 - Change the Margins
  • 71472 - Lesson Lab Applying Various Formatting
  • 71473 - Lesson Followup
Enhancing Reports
  • 71474 - Lesson Introduction
  • 71475 - Create a Watermark
  • 71476 - Add Bulleted Lists
  • 71477 - Modify Format Based on Data Value
  • 71478 - Conditionally Suppress Data
  • 71479 - Insert Hyperlinks
  • 71480 - Hide Report Objects
  • 71481 - Lesson Lab Enhancing a Report
  • 71482 - Lesson Followup
Creating and Modifying Pie Charts
  • 71483 - Lesson Introduction
  • 71484 - Create a Pie Chart with a Drill-down
  • 71485 - Change the Chart Title
  • 71486 - Format a Chart
  • 71487 - Present a Chart by Group
  • 71488 - Lesson Lab Creating a Pie Chart
  • 71489 - Lesson Followup
Distributing Data
  • 71490 - Lesson Introduction
  • 71491 - Export to Excel
  • 71492 - Export to an Access Database
  • 71493 - Create a Report Definition
  • 71494 - Create Mailing Labels
  • 71495 - Lesson Lab Exporting Reports and Creating Report Definitions
  • 71496 - Lesson Followup
Course Follow Up
  • 71497 - Course Follow Up

Course Length:  426 minutes


Crystal Reports 9.0: Level 2

TOPICS COVERED:

Course Introduction
  • 70591 - Course Introduction
Creating Running Totals
  • 70592 - Lesson Introduction
  • 70594 - Create a Running Total Field
  • 70595 - Modify a Running Total Field
  • 70596 - Create a Manual Running Total on Detail Data
  • 70597 - Create a Manual Running Total on Summary Data
  • 70593 - Lesson Lab Creating Running Totals
  • 70598 - Lesson Follow Up
Building Cross-tabs in Your Report
  • 70599 - Lesson Introduction
  • 70601 - Create a Cross-tab
  • 70602 - Create a Specified Group Order
  • 70603 - Filter Cross-tab by Group
  • 70604 - Change the Cross-tab Format
  • 70605 - Format Rows and Columns
  • 70606 - Keep Groups Together
  • 70600 - Lesson Lab Building Cross-tabs in Your Report
  • 70607 - Lesson Follow Up
Adding Subreports
  • 70608 - Lesson Introduction
  • 70610 - Insert a Subreport
  • 70611 - Link a Subreport to Data in a Primary Report
  • 70612 - Edit a Subreport
  • 70613 - Format a Subreport
  • 70614 - Share Formulas Between Main and Subreports
  • 70615 - Create an On-demand Subreport
  • 70609 - Lesson Lab Adding Subreports
  • 70616 - Lesson Follow Up
Improving Report Processing Speed
  • 70617 - Lesson Introduction
  • 70619 - Create a SQL Expression
  • 70620 - Select Records on the Server
  • 70621 - Write a SQL Query
  • 70622 - Edit a SQL Query
  • 70623 - Build a Report on a SQL Query
  • 70624 - Create SQL Commands in the Crystal Reports Environment
  • 70618 - Lesson Lab Improving Report Processing Speed
  • 70625 - Lesson Follow Up
Building Dictionaries
  • 70626 - Lesson Introduction
  • 70628 - Create a Dictionary
  • 70629 - Organize the View of Data in a Dictionary
  • 70630 - Adding Graphics to the Dictionary
  • 70631 - Build a Report Based on a Dictionary
  • 70627 - Lesson Lab Building Dictionaries
  • 70632 - Lesson Follow Up
Charting Data
  • 70633 - Lesson Introduction
  • 70635 - Create a Chart
  • 70636 - Modify a Chart
  • 70637 - Create a Top N Chart
  • 70638 - Format a Chart
  • 70639 - Create a Chart Template
  • 70634 - Lesson Lab Creating Multiple Data Series Charts
  • 70640 - Lesson Follow Up
Reporting on Excel Data
  • 70641 - Lesson Introduction
  • 70643 - Create a Report
  • 70644 - Modify a Report
  • 70645 - Update a Report
  • 70642 - Lesson Lab Reporting on Excel Data
  • 70646 - Lesson Follow Up
Course Follow Up
  • 70647 - Course Follow Up

Course Length:  443 minutes


Crystal Reports XI: Arranging and Displaying Report Data

TOPICS COVERED:

Grouping Report Data
  • 145548 - Lesson Introduction
  • 145549 - Insert a Group
  • 145550 - Add Summaries
  • 145551 - Format Summary Information
  • 145552 - Change Group Options
  • 145553 - Add a Second-Level Grouping
  • 145554 - Filter Records by Group
  • 145555 - Create a Top N Sort Group
  • 145556 - Lesson Lab
  • 145557 - Lesson Follow Up
Building Formulas
  • 145558 - Lesson Introduction
  • 145559 - Create a Formula
  • 145560 - Edit a Formula
  • 145561 - Combine Fields by Formula
  • 145562 - Delete a Formula
  • 145563 - Filter Data by Multiple Criteria
  • 145564 - Modify a Filter Using an OR Operator
  • 145565 - Create a Parameter Field
  • 145566 - Account for Null Fields in a Formula
  • 145567 - Lesson Lab
  • 145568 - Lesson Follow Up

Course Length:  135 minutes


Crystal Reports XI: Charting and Distributing Data

TOPICS COVERED:

Creating Pie Charts
  • 152360 - Lesson Introduction
  • 152361 - Create a Pie Chart with a Drill-Down
  • 152362 - Modify Chart Text
  • 152363 - Format a Chart
  • 152364 - Present a Chart by Group
  • 152365 - Lesson Lab
  • 152366 - Lesson Follow Up
Distributing Data
  • 152367 - Lesson Introduction
  • 152368 - Export to a PDF File
  • 152369 - Export to a Microsoft Excel File
  • 152370 - Export to an Access Database File
  • 152371 - Export a Report Definition
  • 152372 - Create Mailing Labels
  • 152373 - Lesson Lab
  • 152374 - Lesson Follow Up

Course Length:  105 minutes


Crystal Reports XI: Creating Reports

TOPICS COVERED:

Creating a Report
  • 143562 - Lesson Introduction
  • 143563 - Set Default Report Settings
  • 143564 - Specify Fields for a New Report
  • 143565 - Preview a Report
  • 143566 - Modify Field Display
  • 143567 - Add a Report Title
  • 143568 - Position Fields
  • 143569 - Add Fields from Other Tables
  • 143570 - Lesson Lab
  • 143571 - Lesson Follow Up
Displaying Specific Report Data
  • 143572 - Lesson Introduction
  • 143573 - Find Data
  • 143574 - Sort Data
  • 143575 - Filter Data by a Single Criterion
  • 143576 - Lesson Lab
  • 143577 - Lesson Follow Up

Course Length:  120 minutes


Crystal Reports XI: Data Access Techniques

TOPICS COVERED:

Creating Drill-downs
  • 147873 - Lesson Introduction
  • 147874 - Create a Drill-down
  • 147875 - Create Separate Headings for Drill-down Data
  • 147876 - Lesson Lab
  • 147877 - Lesson Follow Up
Enhancing Report Processing By Writing SQL Statements
  • 147878 - Lesson Introduction
  • 147879 - Create a Report Using SQL Queries
  • 147880 - Summarize Report Data Using SQL Aggregate Functions
  • 147881 - Create Joins Using SQL
  • 147882 - Create Subqueries
  • 147883 - Create a SQL Expression Field
  • 147884 - Lesson Lab
  • 147885 - Lesson Follow Up
Charting Data
  • 147886 - Lesson Introduction
  • 147887 - Create a Bar Chart
  • 147888 - Modify a Chart
  • 147889 - Format a Chart
  • 147890 - Create a Chart Template
  • 147891 - Create a Top N Chart
  • 147892 - Create a Cross-tab Chart
  • 147893 - Lesson Lab
  • 147894 - Lesson Follow Up
Reporting on Excel Data With Crystal Reports
  • 147895 - Lesson Introduction
  • 147896 - Create a Report Based on Excel Data
  • 147897 - Modify a Report Generated from Excel Data
  • 147898 - Update Data in a Report Based on Excel Data
  • 147899 - Lesson Lab
  • 147900 - Lesson Follow Up

Course Length:  195 minutes


Crystal Reports XI: Formatting Reports

TOPICS COVERED:

Formatting Reports
  • 150701 - Lesson Introduction
  • 150702 - Remove White Space
  • 150703 - Insert Page Header/Footer Data
  • 150704 - Add Borders, Boxes, and Lines
  • 150705 - Change Field Background Color
  • 150706 - Change the Margins
  • 150707 - Lesson Lab
  • 150708 - Lesson Follow Up
Enhancing Reports
  • 150709 - Lesson Introduction
  • 150710 - Add a Watermark
  • 150711 - Insert Objects Using Object Linking and Embedding
  • 150712 - Modify Formatting Based on Data Value
  • 150713 - Suppress Report Sections
  • 150714 - Insert Hyperlinks
  • 150715 - Hide Blank Report Sections
  • 150716 - Lesson Lab
  • 150717 - Lesson Follow Up

Course Length:  105 minutes


Crystal Reports XI: Report Enhancements

TOPICS COVERED:

Working with Prompts
  • 149360 - Lesson Introduction
  • 149361 - Create a Static Prompt
  • 149362 - Create a Dynamic Prompt
  • 149363 - Lesson Lab
  • 149364 - Lesson Follow Up
Enhancing Report Functionality
  • 149365 - Lesson Introduction
  • 149366 - Group Data Hierarchically
  • 149367 - Create a Dynamic Image
  • 149368 - Create a Report Alert
  • 149369 - Create a Geographic Map
  • 149370 - Lesson Lab
  • 149371 - Lesson Follow Up

Course Length:  105 minutes


Crystal Reports XI: Report Manipulation in Crystal Reports XI

TOPICS COVERED:

Creating Running Totals
  • 143534 - Lesson Introduction
  • 143535 - Create a Running Total Field
  • 143536 - Modify a Running Total Field
  • 143537 - Create a Manual Running Total on Detail Data
  • 143538 - Create a Manual Running Total on Summary Data
  • 143539 - Lesson Lab
  • 143540 - Lesson Follow Up
Building Cross-tabs in Your Report
  • 143541 - Lesson Introduction
  • 143542 - Create a Cross-tab
  • 143543 - Create a Specified Group Order
  • 143544 - Filter a Cross-tab by Group
  • 143545 - Change the Cross-tab Format
  • 143546 - Conditionally Format Rows and Columns
  • 143547 - Keep Groups Together
  • 143548 - Lesson Lab
  • 143549 - Lesson Follow Up
Adding Subreports
  • 143550 - Lesson Introduction
  • 143551 - Insert a Subreport
  • 143552 - Link a Subreport to a Primary Report
  • 143553 - Edit a Subreport's Structure
  • 143554 - Format a Subreport Using the Format Editor
  • 143555 - Share Variables Between Subreports and Primary Reports
  • 143556 - Create an On-demand Subreport
  • 143557 - Lesson Lab
  • 143558 - Lesson Follow Up

Course Length:  195 minutes

Related Articles

© 2008 - 2009 CareerBuilder Institute, all rights reserved