Description

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

Prerequisites

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

Need custom training for your team?

Get a quote

Inquire about this course

CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
Related articles

Coronavirus (COVID-19)

Outline

 
 
 
 
 
 
 
 
 
 

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

Dates

22 Jul24 Jul
's-Hertogenbosch

Pricing

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

Copyright ©2020 quest for knowledge