Event Details



course contents:

Ecorp Trainings, one of the best institute providing quality level of training in E-learning & Corporate Services.

We offer instructor led online training. Classroom trainings are conducted in Hyderabad , India.

We provide training for almost all IT technologies,i.e : Documentum, SAP , ORACLE , JAVA , DOTNET , STORAGE products ,HYPERION etc.

for more details please visit-


Course Contents 

Introduction to Oracle Reports Developer

Business Intelligence

Enterprise Reporting

Oracle Reports Developer

Oracle Database 10g

Oracle Developer Suite 10g

Oracle Application Server 10g

OracleAS Reports Services

OracleAS Reports Services Architecture for the Web

Designing and Running Reports

Understanding User Requirements

Designing Reports



Master with Two Details


Retrieving and Sharing Data

Running a Report

Exploring Oracle Reports Developer

Reports Developer Executables

Invoking Reports Builder

Reports Builder Modules

Report Data and Layout

Reports Builder Components

Object Navigator

Report-Level Objects

Data Model Objects

Creating a Paper Report

Report Module Components

Building a Paper Report

Viewing the Paper Report Output

Saving the Report Definition

Reentering the Wizard

Creating Break Reports

Break Report Labels

Creating Mailing Labels and Letters

Enhancing a Basic Paper Report

What Is the Paper Design?

The Paper Design Window

Modifying a Report

Aligning Columns

Setting a Format Mask

Manipulating Objects

Modifying Visual Attributes

Applying Conditional Formatting

Managing Report Templates

Using Report Templates

Modifying a Template

Customizing the Template Margin

Customizing the Template Body

Adding Web Links to a Template for Report HTML Output

Predefining Your Own Templates

Adding a Template Preview Image

Creating a Web Report

What Is JSP Technology?

JSP Advantages

Simple JSP Example

Building a Web Report

Using the Report Wizard

Report Editor: Web Source View

JSP Tags

Web Source Example

Enhancing Reports Using the Data Model: Queries and Groups

The Data Model Objects

Modifying Properties of a Query

Applying Changes

Changing the Group Structure

Group Hierarchy

Ordering Data in a Group

Query Modifications

Filtering Data in a Group

Enhancing Reports Using the Data Model: Data Sources

Data Source Types

Pluggable Data Sources

Using XML as a Data Source

Document Type Definition File

OLAP Data Source

Using Text as a Data Source

Using JDBC as a Data Source

Using REF Cursor Queries

Enhancing Reports Using the Data Model: Creating Columns

Data Model Columns

Maintaining Data Source Columns

Producing File Content Output

Creating a Column

Creating Summary Columns

Displaying Subtotals

Displaying Percentages

Creating a Formula Column

Enhancing Reports Using the Paper Layout

Viewing the Paper Layout

Designing Multipanel Reports

Printing Multipanel Reports

Different Objects in the Paper Layout

The Paper Layout Layers

Report Processing

Paper Layout Tools

Report Bursting

Controlling the Paper Layout: Common Properties

Modifying Paper Layout Object Properties

Common Layout Properties

Sizing Objects


Layout Object Relationships

Pagination Icons in the Paper Layout

Controlling Print Frequency

Using Format Triggers

Controlling the Paper Layout: Specific Properties

Properties of a Repeating Frame

Specifying Print Direction

Controlling the Number of Records per Page

Controlling Spacing Between Records

Minimum Widow Records

System Variables

Valid Source Columns

Displaying File Contents

Web Reporting

Comparing Static and Dynamic Reporting

Adding Dynamic Content

Creating a Report Block

Invoking the Report Block Wizard

Examining the Web Source Code

rw:foreach Tag

rw:field Tag

Customizing Reports JSPs

Extending Functionality Using XML

Why Use XML Report Definitions?

Creating XML Report Definitions

Partial Report Definitions: Format Modification Example

Partial Report Definitions: Format Exception Example

Full Report Definition: Data Model Modification Example

Running XML Report Definitions

Debugging XML Report Definitions

Creating and Using Report Parameters

Creating User Parameters

Referencing Parameters in a Report Query

Using Bind References

Using Lexical References

Hints and Tips When Referencing Parameters

Creating a List of Values

Referencing System Parameters

Building a Paper Parameter Form

Embedding a Graph in a Report

Adding a Graph to a Paper Report

Adding a Graph to a Web Report

Selecting the Graph Type

Selecting the Graph Data

Adding Options to the Graph

Customizing Web Graphs

The rw:graph Tag

Customizing Graphs Using the Graph.XML File

Enhancing Matrix Reports

The Matrix Data Model

The Matrix Paper Layout

Creating Matrix Summaries

Creating the Matrix Manually

The Matrix with Group Data Model

The Matrix with Group Layout

Building a Nested Matrix

Nested Matrix Paper Layout

Coding PL/SQL Triggers

Types of Triggers in Reports

Trigger Code

Using Report Triggers

Using Data Model Triggers: PL/SQL Group Filter

Using Data Model Triggers: Parameter Validation

Using Layout Triggers

Using Format Triggers

Event-Based Reporting

Extending Functionality Using the SRW Package

Contents of the SRW Package

Outputting Messages

Executing a Nested Report

Restricting Data

Initializing Fields

Creating a Table of Contents

Performing DDL Statements

Setting Format Attributes

Maximizing Performance Using OracleAS Reports Services

Running Reports Using OracleAS Reports Services

Report Request Methods

Oracle Application Server Components

Enabling Single Sign-On Access

Running the Web Layout: JSP Run-time Architecture

Running the Paper Layout: Servlet Run-time Architecture

Running a Paper Report on the Web

Queue Manager

Building Reports: Efficiency Guidelines

Tuning Reports

Performance Measurement

Non SQL Data Sources

Investigating the Data Model

Investigating the Paper Layout

Running the Report

Different Development and Run-Time Environments

Developing Reports to Run in Different GUIs



Training Coordinator.

UK :+44-203-468-0685

USA : +1-703-445-4802

INDIA: +91-8143111555 ; +91-40-64643304 / 06

URL : www.ecorptrainings.com

Email : training@ecorptrainings.com



January 09, 2014 — 9:00 am to
October 09, 2018 — 6:00 pm

Add to your calendar