BOCE20 – SAP Crystal Reports for Enterprise: Advanced Report Design

BOCE20 SAP Crystal Reports for Enterprise: Advanced Report Design

Contents

Course Overview

Unit 1: Running Totals

  • Lesson: Creating a Report with Running Totals

Unit 2: Formulas and Functions

  • Lesson: Using String Functions and Operators
  • Lesson: Using Date and Time Functions

Unit 3: Control Structures

  • Lesson: Creating Control Structures

Unit 4: Variables

  • Lesson: Creating Variables

Unit 5: Arrays and User Functions

  • Lesson: Creating Arrays and User Functions

Unit 6: Loops

  • Lesson: Describing Loops in Reports

Unit 7: Parameters, Filters, and Prompt Panels

  • Lesson: Using Parameters, Filters, and Prompts

Unit 8: Additional Parameter Types

  • Lesson: Using Different Types of Parameters

Unit 9: Cascading Prompts and Multiple Parameters

  • Lesson: Using a Cascading Prompt
  • Lesson: Building a Report with Multiple Parameters

Unit 10: Crosstabs

  • Lesson: Defining Crosstabs
  • Lesson: Formatting Crosstabs
  • Lesson: Formatting Crosstabs Conditionally

Unit 11: Crosstab Formulas and Calculated Members

  • Lesson: Using Calculated Members
  • Lesson: Adding Formulas to Calculated Members
  • Lesson: Displaying Hierarchies in Crosstabs

Unit 12: Multi-Pass Reporting

  • Lesson: Using the Report Processing Model

Unit 13: Subreports

  • Lesson: Defining Subreports

Unit 14: Subreports Usage

  • Lesson: Using Subreports

Unit 15: Linked and On-Demand Subreports

  • Lesson: Linking a Subreport to the Main Report
  • Lesson: Creating On-Demand Subreports

Unit 16: Advanced Subreport Usage

  • Lesson: Using Advanced Subreport Features

Unit 17: Report Hierarchical Data

  • Lesson: Grouping Hierarchical Data

Unit 18: Form Letters, Dynamic Graphics and Hyperlinks

  • Lesson: Using Form Letters, Dynamic Graphics and Hyperlinks

Unit 19: Additional Specialized Reports

  • Lesson: Using Additonal Report Features

Course Overview

TARGET AUDIENCE

This course is intended for the following audiences:

  • Project Stakeholder
  • Developer
  • System Administrator

 

Unit 1 Running Totals

Lesson 1: Creating a Report with Running Totals

Lesson Objectives

After completing this lesson, you will be able to:

  • Create Running Totals

 

Unit 2 Formulas and Functions

Lesson 1: Using String Functions and Operators

Lesson Objectives

After completing this lesson, you will be able to:

  • Use string functions and operators

Lesson 2: Using Date and Time Functions

Lesson Objectives

After completing this lesson, you will be able to:

  • Use date and time functions

 

Unit 3 Control Structures

Lesson 1: Creating Control Structures

Lesson Objectives

After completing this lesson, you will be able to:

  • Create control structures

 

Unit 4 Variables

Lesson 1: Creating Variables

Lesson Objectives

After completing this lesson, you will be able to:

  • Create variables

 

Unit 5 Arrays and User Functions

Lesson 1: Creating Arrays and User Functions

Lesson Objectives

After completing this lesson, you will be able to:

  • Create arrays and user functions

 

Unit 6 Loops

Lesson 1: Describing Loops in Reports

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe loops in reports

 

Unit 7 Parameters, Filters, and Prompt Panels

Lesson 1: Using Parameters, Filters, and Prompts

Lesson Objectives

After completing this lesson, you will be able to:

  • Create a report with a Static parameter

 

Unit 8 Additional Parameter Types

Lesson 1: Using Different Types of Parameters

Lesson Objectives

After completing this lesson, you will be able to:

  • Use different types of parameters

 

Unit 9 Cascading Prompts and Multiple Parameters

Lesson 1: Using a Cascading Prompt

Lesson Objectives

After completing this lesson, you will be able to:

  • Use a Cascading Prompt

Lesson 2: Building a Report with Multiple Parameters

Lesson Objectives

After completing this lesson, you will be able to:

  • Use Multiple Parameters

 

Unit 10 Crosstabs

Lesson 1: Defining Crosstabs

Lesson Objectives

After completing this lesson, you will be able to:

  • Build a crosstab

Lesson 2: Formatting Crosstabs

Lesson Objectives

After completing this lesson, you will be able to:

  • Format crosstabs

Lesson 3: Formatting Crosstabs Conditionally

Lesson Objectives

After completing this lesson, you will be able to:

  • Format acrosstabfield conditionally

 

Unit 11 Crosstab Formulas and Calculated Members

Lesson 1: Using Calculated Members

Lesson Objectives

After completing this lesson, you will be able to:

  • Use calculated members

Lesson 2: Adding Formulas to Calculated Members

Lesson Objectives

After completing this lesson, you will be able to:

  • Add calculation formulas

Lesson 3: Displaying Hierarchies in Crosstabs

Lesson Objectives

After completing this lesson, you will be able to:

  • Select a hierarchy object

 

Unit 12 Multi-Pass Reporting

Lesson 1: Using the Report Processing Model

Lesson Objectives

After completing this lesson, you will be able to:

  • Use the Report Processing Model

 

Unit 13 Subreports

Lesson 1: Defining Subreports

Lesson Objectives

After completing this lesson, you will be able to:

  • Define subreports

 

Unit 14 Subreports Usage

Lesson 1: Using Subreports

Lesson Objectives

After completing this lesson, you will be able to:

  • Use subreports

 

Unit 15 Linked and On-Demand Subreports

Lesson 1: Linking a Subreport to the Main Report

Lesson Objectives

After completing this lesson, you will be able to:

  • Link a subreport to the main report

Lesson 2: Creating On-Demand Subreports

Lesson Objectives

After completing this lesson, you will be able to:

  • Create an on-demand subreport
  • Add captions to subreports

 

Unit 16 Advanced Subreport Usage

Lesson 1: Using Advanced Subreport Features

Lesson Objectives

After completing this lesson, you will be able to:

  • Use advanced subreport features

 

Unit 17 Report Hierarchical Data

Lesson 1: Grouping Hierarchical Data

Lesson Objectives

After completing this lesson, you will be able to:

  • Group data hierarchically

 

Unit 18 Form Letters, Dynamic Graphics and Hyperlinks

Lesson 1: Using Form Letters, Dynamic Graphics and Hyperlinks

Lesson Objectives

After completing this lesson, you will be able to:

  • Use form letters, dynamic graphics and hyperlinks

 

Unit 19 Additional Specialized Reports

Lesson 1: Using Additonal Report Features

Lesson Objectives

After completing this lesson, you will be able to:

  • Use additional report features

Submit your request

Is the course not scheduled? Let us know what works for you by clicking the button below and select your Interest. We will do our best to consider your request.

Note: Location can be for a Virtual Classroom

Register Interest

BOCE20 - SAP Crystal Reports for Enterprise: Advanced Report Design

Very Helpfull

User Rating: Be the first one !

Related Courses

  • BOCE20 – SAP Crystal Reports for Enterprise: Advanced Report Design | SAP TRAINING COURSES BOCE20SAP Crystal Reports for Enterprise: Advanced Report DesignArea of Interest:Business Intelligence (BI)Software Solution:Crystal ReportsLevel:Details, Configuration & TransactionLanguages:English GoalsThis is a 3-day instructor-led classroom training that provides you with hands-on experience to creating complex reports. You will also get a comprehensive overview of the functionality of Crystal Reports for Enterprise.AudienceBusiness AnalystDeveloperSystem AdministratorPrerequisitesEssentialBOCE10RecommendedBasic knowledge of database conceptsBasic programming […]
  • BOC320 – SAP Crystal Reports – Business Reporting and Report Processing Strategies BOC320 SAP Crystal Reports - Business Reporting and Report Processing Strategies Contents Course Overview Unit 1: Report Wizard Lesson: Creating a Report Using the Report Wizard Unit 2: Running Totals Lesson: Building a Report with Running Totals Unit 3: Alerts Lesson: Building a Report with Alerts Unit 4: Functions Lesson: Using Functions and Operators in a Formula Unit 5: Control Structures Lesson: Writing Control Structures Unit 6: Variables Lesson: Creating Variables Unit 7: Templates Lesson: Applying Predefined […]
  • BOCE10 – SAP Crystal Reports for Enterprise: Fundamentals of Report Design BOCE10 SAP Crystal Reports for Enterprise: Fundamentals of Report Design Contents Course Overview Unit 1: Report Planning Lesson: Describing Database Concepts Lesson: Planning and Developing a Report Prototype Unit 2: SAP Business Objects BI Platform and Data Source Connection Lesson: Logging On to SAP BusinessObjects BI Platform Lesson: Defining a Data Source Unit 3: Report Creation Lesson: Connecting to a Data Source Lesson: Creating a Query Lesson: Describing the Report Design Environment Lesson: Setting Up Report Sections Lesson: […]
  • BOC310 – SAP Crystal Reports: Fundamentals of Report Design BOC310 SAP Crystal Reports: Fundamentals of Report Design Contents Course Overview Unit 1: Report Concepts Lesson: Describing Reporting Concepts Unit 2: Report Creation Lesson: Choosing a Report Creation Method Lesson: Connecting to Data Sources Lesson: Navigating in the Design Environment Lesson: Inserting Objects in a Report Lesson: Previewing a Report Lesson: Saving a Report Lesson: Setting the Position and Size of Objects Lesson: Formatting Objects Unit 3: Record Selection Lesson: Setting Records Using Select Expert Lesson: […]
  • BOC320 – SAP Crystal Reports – Business Reporting and Report Processing Strategies | SAP TRAINING COURSES BOC320SAP Crystal Reports - Business Reporting and Report Processing StrategiesArea of Interest:Business Intelligence (BI)Software Solution:Crystal ReportsLevel:Details, Configuration & TransactionLanguages:English GoalsApply advanced concepts of report designAudienceApplication ConsultantBusiness AnalystBusiness Process Owner / Team Lead / Power UserPrerequisitesEssentialWindows conventionsBasic computer skills and database conceptsRecommendedBOC310--SAP Crystal Reports: Fundamentals of Report DesignCourse based on software releaseSAP BusinessObjects Business Intelligence […]
  • HOBOW1 – Hands-On: Web Intelligence Formula Deep Dive Level:Details, Configuration & Transaction Languages:English Course included in the following training paths:Web Intelligence
  • BOW320 – SAP BusinessObjects Web Intelligence: Report Design II BOW320 SAP BusinessObjects Web Intelligence: Report Design II Contents Course Overview Unit 1: Web Intelligence Core Report Design Lesson: Reviewing Core Report Design Concepts Unit 2: Multiple Data Sources Lesson: Synchronizing Data from Multiple Data Sources Lesson: Creating Multiple Queries in a Document Lesson: Synchronizing Data with Merged Dimensions Lesson: Interacting with Other Data Providers Unit 3: Advanced Query Techniques Lesson: Implementing Combined Queries Lesson: Implementing Subqueries Lesson: Creating a Query Based on […]
  • BOCREC – SAP Crystal Reports for Enterprise Compact Course Level:Details, Configuration & Transaction Languages:English
  • BOD405 – SAP Lumira 2.1 Discovery BOD405 SAP Lumira Discovery - Basic Training Contents Course Overview Unit 1: Positioning and Overview of SAP Lumira Discovery Lesson: Positioning of SAP Lumira, Discovery Edition Lesson: Getting an Overview of SAP Lumira, Discovery Edition Unit 2: Navigating the BI Launchpad Lesson: Describing the SAP BusinessObjects Business Intelligence (BI) Platform Lesson: Navigating in the BI Launchpad Lesson: Viewing SAP Lumira Stories Lesson: Using Bookmarks Lesson: Scheduling an SAP Lumira Story Lesson: Setting Preferences in the BI Launchpad Unit 3: […]
  • S4605 – Sales Processing in SAP S/4HANA S4605 Sales Processing in SAP S/4HANA Contents Course Overview Unit 1: Course Overview Lesson: Course Overview Unit 2: Introduction Lesson: Introduction to the Sales and Distribution Process Unit 3: Enterprise Structures in Sales and Distribution Lesson: Enterprise Structures in Sales and Distribution Unit 4: Sales Order Processing Lesson: Source of Data Lesson: Order Processing – Special Features Unit 5: Controlling Sales Documents Lesson: Basic Principles of Business Process Control Lesson: Controlling Sales Documents - Sales […]