This 3-day instructor led course is designed to give you comprehensive skills and in-depth knowledge to create advanced reports that will help you analyze and interpret data. As a business benefit, you will be able to increase your understanding of formulas, variables, templates, parameters, report processing and subreports, which will help you make more effective report design decisions and create more efficient reports.

Why attend

This course prepares you to gain advance concepts of report design

Who should attend

The target audience for this course is report designers who are responsible for creating and distributing advanced reports and have completed Crystal Reports: Fundamentals of Report Design (or have the equivalent knowledge). This course is intended for the following audiences:

  • Business Analysts
  • Report Writers
  • Report Designers
  • Application Developers
  • BI System Administrators


  • Completion of Crystal Reports: Fundamentals of Report Design (BOCE310) or have the equivalent knowledge

Code: BOCE20
Price: 2.175 EUR

Inquire about this course

Related articles

Coronavirus (COVID-19)



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


  • Creating Variables

Arrays and User Functions

  • Creating Arrays
  • Creating User Functions


  • 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


  • 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


  • 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


The fee for this 3-day course is EUR 2.175,00 (+VAT) per person.

Copyright ©2021 quest for knowledge