Description

SAP Crystal Reports helps analyze and highlight relevant metrics based on information from multiple data sources. Thanks to this course, you will learn how to enrich your reports, make them configurable and optimize the presentation of the returned data.

Who is this training for ?

For whom ?

Developers and decision-making consultants, responsible for reporting and analysis.

Prerequisites

Training objectives

Create custom formulas in a SAP Crystal Reports report Add dynamic functions and variables Define a report with multiple parameters and interactive filters Use report templates Creating a report with conditional sections Improve a state to optimize data restitution time

Training program

• Reminders of the basics and exploration of the Formula Workshop
  • Reminder of the basics of SAP Crystal Reports.
  • The process of creating a report.
  • Execution phases and calculation of a Crystal Reports report.
  • Database folder objects.
  • The Data Explorer.
  • Standard and custom functions and operators.
  • Creating custom formulas.
  • The types of errors possible when creating formulas.
  • Creating additional functions (UFL).
  • Exercise: Creating a report with groupings and subtotals.
  • Creating custom formulas.
  • Advanced calculations.
  • Using dynamic variables.
  • Added features to Crystal Reports
• Using Parameters in the Report
  • Parameter definitions.
  • Static and dynamic parameters.
  • Lists of values, parameter groups, inherited parameters.
  • Prompt text to fill in the parameters.
  • Interactive filters.
  • Exercise: Preparing a report with several parameters and interactive filters.
• Using templates and sections
  • Creating a report from a template.
  • The report repository.
  • Data mapping.
  • Report templates multilingual reports.
  • Reports with several sections.
  • Avoid empty spaces.
  • Hide or show according to a condition.
  • Control of displaying the results in a text box.
  • Exercise: Managing the use of report templates.
  • Creating reports with conditional sections.
• Advanced functions
  • Analysis of the SQL query.
  • Study of execution statistics.
  • Optimization of number of sub-reports.
  • Addition of hyperlinks, from images to a state.
  • Use externalized dynamic images.
  • Manage alerts in a state.
  • Change the source database of a report.
  • Update the database when running a report.
  • Advanced reporting on the Web.
  • Exercise: Detection of the most consuming objects.
  • Modification of filters to optimize a state, improve response times.
  • Manipulation of advanced functions.