Crystal Reports 2011 – Level One

Course Number:

N/A

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.

Audience:

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.

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

 

Share on facebook
Share on twitter
Share on linkedin
Share on email

Related Posts

About Us

IT Training, Agile Ways of Working and High Impact Talent Development Strategies

Let Us Come to You!

Classes recently delivered in: Atlanta, Boston, Chicago, Columbus, Dallas, Detroit, Indianapolis, Jerusalem, London, Milan, New York, Palo Alto, Phoenix, Pittsburgh, Portland, Raleigh, San Antonio, San Diego, San Francisco, San Jose, Seattle, Springfield, Mass., St. Louis, Tampa and more!