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