Oracle Reports Developer

Build Reports

5 days training event

6100-3043

Course Outlines - Download PDF

Learn to build complex and sophisticated reports from any data source, in any format, using Oracle Reports Developer (9.0.4.0.1). In this course, participants also learn to deploy the reports using

OracleAS Reports Services.

Learn To

In this course, participants learn how to design and build a variety of standard and custom Web and paper reports using Oracle Reports Developer (9.0.4.0.1). Working in the declarative environment of Reports Builder, participants learn how to retrieve, display, and format data from any data source in numerous reporting styles and publish the output to any destination.

Participants learn how to add dynamic content to a static Web page and publish reports to the Web. In addition, participants learn how to customize more complex reports, embed graphical charts, and use OracleAS Reports Services to deploy the reports.

Audience

  • Technical Consultant

  • Reports Developer

  • Business Intelligence Developer

  • PL/SQL Developer

Course Objectives

  • Use report parameters and customize a runtime parameter form

  • Enhance reports using graphs and PL/SQL trigger code

  • Maximize report performance using OracleAS Reports Services and tune reports

  • Publish a report on the Web and build reports to run in various languages

  • Manage report templates, create mailing labels and letters

  • Identify the main components in a report document and how they are related

  • Identify the differences between Web and paper reports

  • Identify standard report design styles and run existing reports to various output destinations

  • Create and modify basic tabular reports and high quality Web reports

  • Create other report styles such as break reports and matrix reports

  • Create reports by accessing data from various data sources

  • Add dynamic data to an existing HTML page

Introduction to Oracle Reports Developer

  • OracleAS Reports Services

  • Oracle Reports Developer

  • OracleAS Reports Services Architecture for the Web

  • Oracle Database 10g

  • Oracle Application Server 10g

  • Enterprise Reporting

  • Business Intelligence

  • Oracle Developer Suite 10g

Designing and Running Reports

  • Matrix

  • Retrieving and Sharing Data

  • Tabular

  • Master-Detail

  • Master with Two Details

  • Running a Report

  • Designing Reports

  • Understanding User Requirements

Exploring Oracle Reports Developer

  • Reports Developer Executables

  • Reports Builder Modules

  • Reports Builder Components

  • Object Navigator

  • Invoking Reports Builder

  • Data Model Objects

  • Report Data and Layout

  • Report-Level Objects

Creating a Paper Report

  • Creating Break Reports

  • Building a Paper Report

  • Creating Mailing Labels and Letters

  • Break Report Labels

  • Report Module Components

  • Saving the Report Definition

  • Reentering the Wizard

  • Viewing the Paper Report Output

Enhancing a Basic Paper Report

  • Setting a Format Mask

  • Aligning Columns

  • Applying Conditional Formatting

  • Modifying Visual Attributes

  • The Paper Design Window

  • Modifying a Report

  • Manipulating Objects

  • What Is the Paper Design?

Managing Report Templates

  • Customizing the Template Margin

  • Predefining Your Own Templates

  • Adding a Template Preview Image

  • Adding Web Links to a Template for Report HTML Output

  • Modifying a Template

  • Using Report Templates

  • Customizing the Template Body

Creating a Web Report

  • JSP Advantages

  • JSP Tags

  • Simple JSP Example

  • Using the Report Wizard

  • Building a Web Report

  • Web Source Example

  • Report Editor: Web Source View

  • What Is JSP Technology?

Enhancing Reports Using the Data Model: Queries and Groups

  • Query Modifications

  • Group Hierarchy

  • Modifying Properties of a Query

  • Changing the Group Structure

  • The Data Model Objects

  • Applying Changes

  • Ordering Data in a Group

  • Filtering Data in a Group

Enhancing Reports Using the Data Model: Data Sources

  • Data Source Types

  • Using JDBC as a Data Source

  • OLAP Data Source

  • Using Text as a Data Source

  • Using XML as a Data Source

  • Document Type Definition File

  • Pluggable Data Sources

  • Using REF Cursor Queries

Enhancing Reports Using the Data Model: Creating Columns

  • Maintaining Data Source Columns

  • Creating a Formula Column

  • Data Model Columns

  • Creating Summary Columns

  • Displaying Percentages

  • Creating a Column

  • Displaying Subtotals

  • Producing File Content Output

Enhancing Reports Using the Paper Layout

  • Report Processing

  • Designing Multipanel Reports

  • Printing Multipanel Reports

  • Viewing the Paper Layout

  • The Paper Layout Layers

  • Different Objects in the Paper Layout

  • Report Bursting

  • Paper Layout Tools

Controlling the Paper Layout: Common Properties

  • Modifying Paper Layout Object Properties

  • Using Format Triggers

  • Anchors

  • Pagination Icons in the Paper Layout

  • Sizing Objects

  • Layout Object Relationships

  • Controlling Print Frequency

  • Common Layout Properties

Controlling the Paper Layout: Specific Properties

  • Specifying Print Direction

  • Properties of a Repeating Frame

  • System Variables

  • Displaying File Contents

  • Valid Source Columns

  • Controlling Spacing Between Records

  • Minimum Widow Records

  • Controlling the Number of Records per Page

Web Reporting

  • Examining the Web Source Code

  • Adding Dynamic Content

  • Creating a Report Block

  • rw:field Tag

  • Customizing Reports JSPs

  • rw:foreach Tag

  • Comparing Static and Dynamic Reporting

  • Invoking the Report Block Wizard

Extending Functionality Using XML

  • Full Report Definition: Data Model Modification Example

  • Running XML Report Definitions

  • Debugging XML Report Definitions

  • Partial Report Definitions: Format Exception Example

  • Creating XML Report Definitions

  • Partial Report Definitions: Format Modification Example

  • Why Use XML Report Definitions?

Creating and Using Report Parameters

  • Hints and Tips When Referencing Parameters

  • Building a Paper Parameter Form

  • Creating User Parameters

  • Creating a List of Values

  • Referencing System Parameters

  • Using Lexical References

  • Using Bind References

  • Referencing Parameters in a Report Query

Embedding a Graph in a Report

  • Adding a Graph to a Web Report

  • Customizing Graphs Using the Graph.XML File

  • Selecting the Graph Type

  • Customizing Web Graphs

  • Selecting the Graph Data

  • The rw:graph Tag

  • Adding Options to the Graph

  • Adding a Graph to a Paper Report

Enhancing Matrix Reports

  • The Matrix Data Model

  • Building a Nested Matrix

  • Creating the Matrix Manually

  • The Matrix with Group Data Model

  • The Matrix Paper Layout

  • Nested Matrix Paper Layout

  • Creating Matrix Summaries

  • The Matrix with Group Layout

Coding PL/SQL Triggers

  • Types of Triggers in Reports

  • Using Data Model Triggers: Parameter Validation

  • Using Layout Triggers

  • Using Report Triggers

  • Using Format Triggers

  • Using Data Model Triggers: PL/SQL Group Filter

  • Trigger Code

  • Event-Based Reporting

Extending Functionality Using the SRW Package

  • Creating a Table of Contents

  • Initializing Fields

  • Restricting Data

  • Contents of the SRW Package

  • Executing a Nested Report

  • Performing DDL Statements

  • Outputting Messages

  • Setting Format Attributes

Maximizing Performance Using OracleAS Reports Services

  • Report Request Methods

  • Running Reports Using OracleAS Reports Services

  • Oracle Application Server Components

  • Running a Paper Report on the Web

  • Running the Web Layout: JSP Run-time Architecture

  • Queue Manager

  • Enabling Single Sign-On Access

  • Running the Paper Layout: Servlet Run-time Architecture

Building Reports: Efficiency Guidelines

  • Different Development and Run-Time Environments

  • Investigating the Data Model

  • Developing Reports to Run in Different GUIs

  • Non SQL Data Sources

  • Tuning Reports

  • Investigating the Paper Layout

  • Running the Report

  • Performance Measurement

TRAINING LOCATIONS

أماكن ومقرات التدريب حول العالم

Dubai

Dubai

Kuala Lumpur

Kuala Lumpur

Tunis

Tunis

Istanbul

Amman

Amman

Sunny resort beach with palm tree at the coast shore of Red Sea in Sharm el Sheikh, Sinai, Egypt, Asia in summer hot. Bright sunny light

Sharm El Sheikh

Ottawa

Ottawa

Paris

Lagos

Lagos

Harare

Harare

Kampala

Kampala

Casablanca

Casablanca