Goals

  • This is a 3-day instructor-led classroom training that provides you with hands-on experience to creating complex reports. You will also get a comprehensive overview of the functionality of Crystal Reports for Enterprise.

Audience

  • Business Analyst
  • Developer
  • System Administrator

Prerequisites

Essential

Recommended

  • Basic knowledge of database concepts
  • Basic programming knowledge”

Course based on software release

  • SAP Crystal Reports for Enterprise
  • SAP BusinessObjects BI platform 4.1

Content

  • Running Totals
    • Creating a Report with Running Totals
  • Formulas and Functions
    • Using String Functions and Operators
    • Using Date and Time Functions
  • Control Structures
    • Creating Control Structures
  • Variables
    • Creating Variables
  • Arrays and User Functions
    • Creating Arrays
    • Creating User Functions
  • Loops
    • Describing Loops in Reports
  • Parameters, Filters, and Prompt Panels
    • Examining Standard Parameters
    • Using Interactive Filters
    • Using Prompt Panels and Responding to Parameters
  • Additional Parameter Types
    • Using Different Types of Parameters
    • Creating Date Range Parameters
    • Using Edit Mask and Description Fields
  • Cascading Prompts and Multiple Parameters
    • Using a Cascading Prompt
    • Building a Report with Multiple Parameters
  • Crosstabs
    • Defining Crosstabs
    • Formatting a Crosstab
    • Formatting Crosstabs Conditionally
  • Crosstab Formulas and Calculated Members
    • Using Calculated Members
    • Adding Formulas to Calculated Members
    • Displaying Hierarchies in Crosstabs
  • Multi-Pass Reporting
    • Using the Report Processing Model
  • Subreports
    • Defining Subreports
    • Creating Subreports
  • Subreports Usage
    • Using Subreports
  • Linked and On-Demand Subreports
    • Linking a Subreport to the Main Report
    • Creating On-Demand Subreports
  • Advanced Subreport Usage
    • Passing Data Between Subreports and Main Reports
    • Linking Unlinkable Data Using Subreports
  • Report Hierarchical Data
    • Grouping Hierarchical Data
  • Report Form Letters, Hyperlinks, and Dynamic Graphics
    • Building a Form Letter Report
    • Building a Report with Hyperlinks
    • Using Dynamic Graphic Locations
  • Additional Specialized Reports
    • Building a Report with Alerts
    • Building Top N and Bottom N Reports
    • Integrating Flash Objects