Oracle 9i Reports Developer is a high-fidelity enterprise reporting tool that enables businesses to give immediate access to information to all levels within and outside of the organization in an unrivaled scalable and secure environment.

In this course, participants design and build a variety of standard and custom Web and paper reports using Oracle 9i Reports Developer. Working in the declarative environment of Reports Builder, participants learn how to retrieve data from any data source, display it in any format, and publish the output to any destination. Participants learn how to create Web and paper reports using the Report Wizard, add dynamic report data to static HTML pages using custom JSP tags, and publish reports to the Web. They also learn how to customize more complex reports, embed graphical charts, and use Oracle 9i AS Reports Services to deploy their reports.

Course schedule

Duration: 30 hours
To view the schedule for this class, click here.

This course is valuable for those involved in developing applications with Developer, including consultants, engineers, analysts, manager and others.

Oracle 9i: Program with PL/SQL

Course Outline

Introduction to Oracle 9i Reports Developer

• What is Business Intelligence
• Enterprise Reporting: Issues and Challenges
• Web Publishing and Paper Publishing
• What is Oracle 9i Reports Developer
• Key Features
• Benefits
• Oracle 9i AS Reports Services

Designing and Running Reports

• Designing Reports: Recognizing User Requirements
• Selecting Report Styles
• Retrieving and Sharing Data
• Running a Report
• Viewing Report Output

Working in Oracle 9i Reports Developer

• Reports Executables
• Types of Report Builder Modules
• Report Builder Components
• Object Hierarchy

Creating a Paper Report

• Invoking Reports Builder
• Creating a Paper Report using the Report Wizard
• Modifying a Report Using the Report Wizard
• Adding Summaries
• Choosing Templates
• Generating Output

Enhancing a Basic Paper Report

• Enhancing a Paper Report Using the Paper Design View
• Aligning Columns
• Setting Format Masks
• Manipulating Objects
• Changing Text
• Modifying Visual Attributes
• Creating Format Exceptions
• Inserting Page Numbers, Current Date, and Time

Managing Report Templates

• Using a Report Template for Paper Reports
• Modifying a Predefined Template
• Registering a Customized Template

Creating a Web Report

• Using JavaServer Page Technology to Build Web Reports
• Creating a Web Report Using the Report Wizard
• Examining the Source Code Using the Web Source View
• Previewing a Report on the Web

Enhancing Reports Using the Data Model: Queries and Groups

• The Data Model Objects
• Creating Groups Manually
• Ordering Data in a Group Using the Break Order Property
• Eliminating Data from a Group Using a Group Filter

Enhancing Reports Using the Data Model: Data Sources

• Using Pluggable Data Sources
• Creating a Query Using the Data Wizard
• Creating a REF Cursor Query
• Linking Data from Multiple Queries Using a Data Link

Enhancing Reports Using the Data Model: Creating Columns

• Creating a File Column
• Creating a Summary Column
• Creating a Formula Column
• Creating a Placeholder Column

Enhancing Reports Using the Paper Layout

• Identifying Paper Report Sections
• Distributing a Report to Various Destinations
• Bursting on a Repeating Group
• Designing Multipanel Reports
• The Layout Model Objects
• Creating a Tabular Report with Variable-Length Vertical Lines

Controlling the Paper Layout: Common Properties

• Modifying Common Layout Properties
• Using Format Triggers
• Modifying Web Setting Properties

Controlling the Paper Layout: Specific Properties

• Controlling the Print Direction of a Repeating Frame
• Controlling Pagination of a Repeating Frame
• Controlling Spacing Between Records
• Creating New Fields in the Layout and Modifying Properties
• Creating a File Link to Display File Contents

Web Reporting

• High Quality Web Publishing
• Building Reports for the Web
• Adding Dynamic Content to a Web Page
• Using a Report Block
• Customizing Reports for the Web

Extending Functionality Using XML

• Using XML as a Data Source
• Why Use XML Report Definitions
• Building Reports Using XML
• Applying Runtime Customizations
• Applying Batch Updates

Creating and Using Reports Parameters

• Creating User Parameters
• Referencing User Parameters
• Creating Lists of Values for Parameters
• Creating a Parameter Form Layout
• Customizing the Parameter Form Layout
• Creating Parameter HTML Extensions

Embedding a Graph in a Report

• Creating and Embedding a Graph Using the Graph Wizard
• Restricting Graph Data with a User Parameter
• Customizing a Graph in a Web Report
• Using Graph Hyperlinks

Enhancing Matrix Reports

• The Matrix Data Model
• The Matrix Paper Layout
• Creating Matrix Summaries
• Creating a Nested Matrix Report Using the Wizards
• Displaying Zeros in Cells with No Value

Coding PL/SQL Triggers

• Trigger Types
• Creating Report Triggers
• Creating Data Model Triggers
• Creating Layout Triggers
• Writing Common Code
• Server-Side Code
• Event-Based Reporting

Extending Functionality Using the SRW Package

• Contents of the Report Builder Built-in Package
• Outputting Runtime Messages
• Managing Temporary Tables
• Modifying Visual Attributes

Maximizing Performance Using Oracle 9i AS Reports Services

• Why Use Oracle 9i AS Reports Services?
• Report Request Methods
• Oracle 9i AS Reports Services Architecture
• JSP Runtime Architecture
• Servlet Runtime Architecture
• Viewing and Scheduling Reports
• Managing and Monitoring Oracle 9i AS Reports Services

Building Reports: Efficiency Guidelines

• Investigating Performance Issues
• Tuning Oracle Reports
• Building for Other Languages