In this course, students will learn to connect to a database, extract data and present it as a report. Content is designed for people who need output from a database when the database programs have limited reporting tools or such tools may not be accessible.

Course Duration: 2 days
Prerequisites:

Before taking this course, students should be familiar with the basic functions such as creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files in Microsoft Windows. In addition, students should been familiar Microsoft Office Access 2010 and basic database concepts.

Hardware and Software Requirements:

For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware configuration:

  • 1 GHz Pentium®-class processor or faster.
  • A minimum of 1 GB of RAM is recommended.
  • 20 GB hard disk or larger if you use Windows XP Professional as your operating system. You should have at least 1 GB of free hard disk space available for Office 2010 installation.
  • Access to one of the following: a local CD-ROM drive, a local DVD drive, or access to a networked CD-ROM drive.
  • A keyboard and mouse or other pointing device.
  • A 1024 x 768 resolution SVGA monitor is recommended.
  • Network cards and cabling for local network access
  • Internet access (check with your local network administrator).
  • A printer (optional) or an installed printer driver.
  • A projection system to display the instructor’s computer screen

Each computer requires the following software:

  • Microsoft® Windows® XP SP2 or Vista
  • Custom installation of Crystal Reports 2011
  • Default installation of Microsoft® Office 2010
  • Printer driver (Printers are not required; however, each PC must have an installed printer driver to use Print Preview.)
  • Adobe® Reader® 9.0 and above
Course Objectives:

Upon successful completion of this course, students will be able to:

  • Identify the elements of the Crystal Reports interface
  • Create and modify a basic report
  • Use formulas to calculate and filter data
  • Build a parameterized report
  • Group report data
  • Enhance a report
  • Create a report using data from an Excel workbook
  • Distribute data
Course Outline:
  • Exploring the SAP Crystal Reports 2011 Interfac
    • Explore Crystal Reports
    • Use Crystal Reports Help
    • Customize the Report Settings

 

  • Working with Reports
    • Create a Report
    • Modify a Report
    • Display Specific Report Data
    • Work with Report Sections

 

  • Using Formulas in Reports
    • Create a Formula
    • Edit a Formula
    • Filter Data Using a Formula
    • Work with Advanced Formulas and Functions
    • Handle Null Values

 

  • Building Parameterized Reports
    • Create a Parameter Field
    • Use a Range Parameter in a Report
    • Create a Prompt

 

  • Grouping Report Data
    • Group Report Data
    • Modify a Group Report
    • Group Using Parameters
    • Create a Parameterized Top N Report

 

  • Enhancing a Report
    • Format a Report
    • Insert Objects in a Report
    • Suppress Report Sections
    • Use Report Templates

 

  • Creating a Report from Excel Data
    • Create a Report Based on Excel Data
    • Modify a Report Generated from Excel Data
    • Update Data in a Report Based on Excel Data

 

  • Distributing Data
    • Export Data
    • Create Mailing Labels

 

  • Appendix A: Setting Up and Configuring Data Sources
  • Appendix B: Using Report Processing Techniques
  • Appendix C: Using Functions in Formulas