00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful

BOC310: SAP Crystal Reports: Fundamentals of Report Design

 

COURSE OBJECTIVES

  • Participants will gain the fundamentals of report design.
  • Participants will acquire the basis for more advanced courses in the SAP BI curriculum.

Price €1,330 per person

Dates

  • 2 Day course – Please contact us regarding scheduling.

SAPBusinessObjects

TARGET AUDIENCE

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

PREREQUISITES

  • Basic knowledge of database concepts
Notes
  • The course works with a SAP ERP 6.0 system on Enhancement Package 5 and active new general ledger (new G/L)
  • Please note that the course also takes the functions into consideration on earlier releases (and on classic GL)

Course based on software release

  • SAP Crystal Reports 2011
Course Outline

Report Planning

  • Describing Database Concepts
  • Planning and Developing a Report Prototype

SAP Business Objects BI Platform and Data Source Connection

  • Logging On to SAP BusinessObjects BI Platform
  • Defining a Data Source

Report Creation

  • Connecting to a Data Source
  • Creating a Query
  • Describing the Report Design Environment
  • Setting Up Report Sections
  • Describing the Field Objects Controls
  • Saving a Report

Report Layout and Formatting

  • Setting Page Properties
  • Applying Report Formatting Options

Data Selection

  • Editing a Query
  • Inserting Additional Filter Conditions
  • Modifying Query Filters
  • Applying Time-Based Filters


Sorting, Grouping, and Totaling

  • Sorting Data
  • Grouping Data
  • Creating Nested and Multiple Groups
  • Creating a Custom Group
  • Grouping on Time-Based Data
  • Totaling Grouped Data
  • Totaling Column Data

Additional Report Objects

  • Inserting Predefined Objects
  • Adding Graphical Objects

Formulas

  • Defining Formulas
  • Using the Formula Workshop
  • Creating and Modifying Formulas
  • Applying Boolean Formulas
  • Applying If-Then-Else Formulas
  • Applying Date Calculations + Applying Numeric Calculations + Applying String Manipulation

Conditional Formatting

  • Formatting Objects Conditionally
  • Formatting Fields Conditionally with Formulas
  • Formatting Sections
  • Formatting Sections Conditionally
  • Drilling Down on Sections

Charting

  • Describing Charting Concepts
  • Charting On Data
  • Formatting Charts

Report Distribution

  • Exporting a Report
  • Saving Reports to SAP BusinessObjects Business Intelligence Platform
Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.