SAP Crystal Reports for Enterprise: Advanced Report Design (BOCE20v15)

  • Business analyst
  • Developer
  • System administrator


  • Basic knowledge of database concepts
  • Basic programming knowledge

Expected Duration
3 day


In this course, you will learn how to create complex reports. You will also get a comprehensive overview of the functionality of Crystal Reports for Enterprise. This course is based on software release SAP Crystal Reports for Enterprise and SAP BusinessObjects BI platform 4.1.


1. Running Totals

  • Creating a Report with Running Totals

2. Formulas and Functions

  • Using String Functions and Operators
  • Using Date and Time Functions

3. Control Structures

  • Creating Control Structures

4. Variables

  • Creating Variables

5. Arrays and User Functions

  • Creating Arrays
  • Creating User Functions

6. Loops

  • Describing Loops in Reports

7. Parameters, Filters, and Prompt Panels

  • Examining Standard Parameters
  • Using Interactive Filters
  • Using Prompt Panels and Responding to Parameters

8. Additional Parameter Types

  • Using Different Types of Parameters
  • Creating Date Range Parameters
  • Using Edit Mask and Description Fields

9. Cascading Prompts and Multiple Parameters

  • Using a Cascading Prompt
  • Building a Report with Multiple Parameters

10. Crosstabs

  • Defining Crosstabs
  • Formatting a Crosstab
  • Formatting Crosstabs Conditionally

11. Crosstab Formulas and Calculated Members

  • Using Calculated Members
  • Adding Formulas to Calculated Members
  • Displaying Hierarchies in Crosstabs

12. Multi-Pass Reporting

  • Using the Report Processing Model

13. Subreports

  • Defining Subreports
  • Creating Subreports

14. Subreports Usage

  • Using Subreports

15. Linked and On-Demand Subreports

  • Linking a Subreport to the Main Report
  • Creating On-Demand Subreports

16. Advanced Subreport Usage

  • Passing Data Between Subreports and Main Reports
  • Linking Unlinkable Data Using Subreports

17. Report Hierarchical Data

  • Grouping Hierarchical Data

18. Report Form Letters, Hyperlinks, and Dynamic Graphics

  • Building a Form Letter Report
  • Building a Report with Hyperlinks
  • Using Dynamic Graphic Locations

19. Additional Specialized Reports

  • Building a Report with Alerts
  • Building Top N and Bottom N Reports
  • Integrating Flash Objects



Select Course Options