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

This course is also available as a test system within SAP Live Access

Learn more

Register your interest for taking this course

Let us know when and where you'd like to attend and we'll notify you when sessions become available.

Note: Location can be for a public classroom or a virtual that meets your prefered timezone.

Register Interest