Crystal Reports

Course Overview

Crystal Reports XI – 7hrs, 23 mins
Crystal Reports is a business intelligence application that is used to design and generate reports from a wide range of data sources. This class will arm you with the knowledge you need to run sophisticated reports.

Course Outline

Level 1

  • What is Crystal Reports?
  • Setting up Before You Build Reports
  • Building a Report
  • Finding, Sorting, and Filtering
  • Grouping
  • Using Basic Formulas
  • Using the Help Section

Level 2

  • Working with Advanced Formulas
  • Creating Parameters
  • Formatting Sections
  • Working with Charts
  • Exporting Data
  • Using the Report Wizard

Level 3

  • Working with Running Totals
  • Utilizing Variables and Arrays
  • Understanding Report Processing
  • Working with Cross-Tab Reports
  • Utilizing Subreports
  • Creating Custom Groups

Level 4

  • Using ODBC Drivers
  • Comparing Inner and Outer Joins
  • Introducing SQL with Crystal Reports
  • Updating and Verifying Data Sources
  • Generating Report Alerts
  • Using Templates

Crystal Reports 2011

  • Installing and Configuring Crystal Reports 2011
  • Introduction to Reporting Concepts
  • Using Crystal Reports 2011
  • Business Objects Repository
  • Reports and the Web
  • Data Selection
  • Sorting, Grouping, and Totaling
  • Multi-Section Reports
  • OLE
  • Cross-tab Objects
  • Building Queries
  • Printing, Exporting, and Viewing Reports

Crystal Reports 2008 – Basic

  • Creating A Report
  • Formatting Features
  • Database Filters
  • Report Grouping
  • Multiple Table Joins
  • Creating Formulas
  • Conditional Formatting
  • Summary Reports and Charts
  • Enhancing Report Processing by Writing SQL Statements
  • Enhancing Report Processing by Writing SQL Statements

Crystal Reports 2008 – Advanced

  • Refresher Exercise
  • Improving Report Appearance with Multiple Sections
  • Running Totals
  • Prompts
  • Advanced Formulas
  • Enhancing Report Functionality
  • Subreporting
  • Using Cross-Tab Reports