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



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.


  • Business analyst
  • Developer
  • System administrator


  • Basic knowledge of database concepts
  • Basic programming knowledge

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