About this Course

This two-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, arrays, templates, parameters, summaries and sections, which will help you to make more effective report design decisions and create more efficient reports.

Audience Profile

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

Course Outline

Unit 1: Building Reports from Repository Objects

• Organizing Repository Objects
• Building a Report Based on Repository Objects

Unit 2: Creating Formulas

• Adding Functions and Operators to a Formula
• Writing Control Structures in Crystal Syntax

Unit 3: Managing Reports

• Organizing Reports in the Workbench
• Publishing Reports to SAP BusinessObjects Business Intelligence Platform

Unit 4: Creating Variables and Arrays

• Creating Variables
• Creating Arrays

Unit 5: Building Report Templates

• Building a Template Based on a Report
• Building a Template without a Data Source
• Removing an Applied Template

Unit 6: Building Parameterized Reports

• Creating a Parameter
• Build a Report with Multiple Parameters

Unit 7: Summarizing Data with Crosstabs

• Creating a Basic Crosstab
• Formatting a Crosstab

Unit 8: Dividing a Report into Sections

• Inserting Sections
• Formatting Sections

Unit 9: Building Specialized Reports

• Building a Report with Running Totals
• Building a Report with Linking
• Building a Report with Alerts
• Building a Top N Report
• Building a Report with Flash Integration

Unit 10: Understanding Report Processing

• Multi-pass Reporting
• Applying Evaluation Time Functions
• Using a Dynamic Array

Unit 11: Using Subreports

• Defining Subreports
• Creating an unlinked subreport
• Creating a Linked Subreport
• Creating on-demand subreports
• Using shared variables with subreports
• Linking unlinkable data

Unit 12: Using Functions

• Using Print State Functions
• Describing a Custom Function
• Using functions