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

Submit your request

Is the course not scheduled? Or looking for other dates and locations that fit your schedule? Let us know what works for you by clicking the button below and select your preferred location. We will do our best to consider your request.

Note: Location can be for a Virtual Classroom, Public Classroom or Any location (Any Physical location except Virtual Classroom.)

Register Interest