BOCE20 – SAP Crystal Reports for Enterprise: Advanced Report Design is an instructor led SAP training program.

Radiant Techlearning offers “BOCE20 – SAP Crystal Reports for Enterprise: Advanced Report Design” training program in Classroom & Virtual Instructor Led / Online mode.


Duration: 3 days


Learning Objectives

This course will prepare professionals to:

  • Provides hands-on experience to creating complex reports. 
  • Provide comprehensive overview of the functionality of Crystal Reports for Enterprise.


  • BOCE10
  • Basic knowledge of database concepts
  • Basic programming knowledge”

Audience Profile

  • Business Analyst
  • Developer
  • System Administrator

Course Details

Module 1: Running Totals

  • Creating a Report with Running Totals

Module 2: Formulas and Functions

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

Module 3: Control Structures

  • Creating Control Structures

Module 4: Variables

  • Creating Variables

Module 5: Arrays and User Functions

  • Creating Arrays
  • Creating User Functions

Module 6: Loops

  • Describing Loops in Reports

Module 7: Parameters, Filters, and Prompt Panels

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

Module 8: Additional Parameter Types

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

Module 9: Cascading Prompts and Multiple Parameters

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

Module 10: Crosstabs

  • Defining Crosstabs
  • Formatting a Crosstab
  • Formatting Crosstabs Conditionally

Module 11: Crosstab Formulas and Calculated Members

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

Module 12: Multi-Pass Reporting

  • Using the Report Processing Model

Module 13: Subreports

  • Defining Subreports
  • Creating Subreports

Module 14: Subreports Usage

  • Using Subreports

Module 15: Linked and On-Demand Subreports

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

Module 16: Advanced Subreport Usage

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

Module 17: Report Hierarchical Data

  • Grouping Hierarchical Data

Module 18: Report Form Letters, Hyperlinks, and Dynamic Graphics

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

Module 19: Additional Specialized Reports

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


Q: What is Advance Reporting?


A: Advanced Reporting & Online Report Designer are Success Factors for Crystal reports. The Online Report Designer (ORD) is an embedded Reporting Tool in Success Factors. It is a part of the Success Factors Foundation package, and is available for every customer no matter what module one have purchased.


Q: What are the components of Report?


A: The components are :

  • Pie charts -2D and 3D
  • Bar and stacked bar charts – 2D and 3D
  • Category and value line Graphs
  • Area and stacked area charts
  • Candlestick charts
  • Gauge charts


Q: What is the importance of cells in a report?


A:  Cells can contain text, images, charts, gauges, maps, GeoCharts, and formulas.

  • The cells may contain multiple rows of data.
  • A cell in a Detailsection will expand into as many rows as are needed to show all the data.
  • A cell in a Groupsection will repeat for every group.
  • And a cell in a Pagesection will repeat for every page on the report.


Q: When would the training be conducted?


A : Once we receive your enrollment request, we will share the enrollment details with you to select and complete the enrollment process.

You can always email us on the below email address (whichever applicable) to know the upcoming schedule for a specific technology training program.


Q: What do you mean by Report Wizard?


A: The Report Wizard is a tool that guides you through the process of creating complex reports. Once you’ve created a report you can then easily format it to make it look exactly how you want i.e. you can change its design. Access provised several advanced options for modifying and creating reports.


Q: What are the steps involved in creating the Report Wizard ?


A: The steps are:

  • Select the fields to include in your report
  • Organize the report
  • Sort your report data
  • Select a layout and title


Q: Who all can pursue this course?


A: The following can pursue this course:

  • Business Analyst
  • Developer
  • System Administrator


Q: What will be the fees of this course?


A: To know about the fees details you can email us on with your requirement in details containing the below information

In case of Self / Individual

  • Training Program
  • Training Mode (Online/ Classroom)
  • Location (in case of classroom):
  • Background (Education/ Technology/ Year of experience, etc. )
  • Training Timeline

In case of Corporate Training

  • Training Program
  • No. of Participants
  • Training Mode (Online/ Classroom)
  • Location (in case of classroom):
  • Participant’s Background (Education/ Technology/ Year of experience, etc.)
  • Training Timeline
  • Expectations form the training program


Q:  How is the Radiant Techlearning verified certificate awarded?


A: Radiant awards course completion certificate to all the participants who have completed the training program which includes various real time projects, assignments, quizzes and some other tasks.  Once the course is done you would be assigned with a project which you would have to submit in 2 weeks’ time.

Radiant Techlearning experts will be evaluating the project on various parameter. To be eligible for the verified certificate you would have to score more than 60% marks.

Only after completion of these criteria you would be awarded with Radiant verified certificate and which the participants can use for their future job purpose.

Participants will be awarded with grades according to the following criteria:

  • 90% – 100% – AAA+
  • 80% – 90% – AA+
  • 70% – 80% – A+
  • 60% – 70% – A


Q: Will I get the course completion certificate?


A: The course completion certification would be awarded to all the professionals, who have completed the training program and the project assignment given by your instructor.

You can use the certificate in your future job interviews will surely help you to land in your dream job.

Unble To Find a Batch..?

Request a Batch