Oracle 9i Reports Developer: Build Reports

Introduction to Oracle9i Reports Developer

• What is Business Intelligence

• Enterprise Reporting: Issues and Challenges

• Web Publishing and Paper Publishing

• What is Oracle9i Reports Developer

• Key Features

• Benefits

• Oracle9iAS 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 Oracle9i 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 Oracle9iAS Reports Services

• Why Use Oracle9iAS Reports Services?

• Report Request Methods

Oracle9iAS Reports Services Architecture

• JSP Runtime Architecture

• Servlet Runtime Architecture

• Viewing and Scheduling Reports

• Managing and Monitoring Oracle9iAS Reports Services

Building Reports: Efficiency Guidelines

• Investigating Performance Issues

• Tuning Oracle Reports

• Building for Other Languages