SAP CRYSTAL REPORTS IN BUSINESS INTELLIGENCE (BI) TRAINING

Fundamentals of Report Design

Report Concepts

• Describing Reporting Concepts

Report Creation

• Choosing a Report Creation Method
• Connecting to Data Sources
• Navigating in the Design Environment
• Inserting Objects in a Report
• Previewing a Report
• Saving a Report
• Setting the Position and Size of Objects
• Formatting Objects

Record Selection

• Setting Records Using Select Expert
• Saving and Refreshing Data in Reports
• Setting Additional Criteria
• Applying Time-Based Record Selection

Report Data Sorting, Grouping, and Summarizing

• Sorting Records
• Creating a Grand Total
• Grouping Records
• Managing Multiple Groups
• Grouping on Time-Based Data
• Summarizing Data
• Sorting and Filtering Groups
• Sorting Groups using Specified Order

Graphics and Special Fields

• Adding Graphical Elements
• Adding Special Fields

Section Formatting

• Formatting Sections
• Controlling Page Breaks
• Creating Summary Reports

Basic Formulas

• Defining a Formula
• Creating If-Then-Else Formulas
• Creating Boolean Formulas
• Creating Formulas with Dates
• Creating Summary Functions in Formulas
• Applying String Manipulation

Conditional Reporting

• Highlighting Data in a Report
• Formatting Data Conditionally

Charts

• Creating Charts Without Groups
• Creating Charts Based on Existing Groups and Summaries
• Customizing a Chart on a Simple Report with No Groups

Report Distribution

• Exporting a Report
• Saving a Report to SAP BusinessObjects Business Intelligence Platform

Business Reporting and Report Processing Strategies

• Report Wizard
• Running Totals
• Alerts
• Functions
• Control Structures
• Variables
• Templates
• Parameters
• Additional Parameters Properties
• Additional Applications for Parameters
• Dynamic List of Values for Parameters
• Arrays
• Crosstabs
• Custom Functions
• Sections
• Introduction to Subreports
• Linked Subreports
• Report Linking Report Processing

Optimizing Report Data Processing

• Identification of link and join types
• Setup and configuration of data sources
• Updating a report for database changes
• Server-side data processing
• Report data validation
• Problem detection and fixes

Fundamentals of Report Design

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