InformIT Home About InformIT Oracle Workforce Development Program Cisco Networking Academy Program Microsoft IT Training & Certification Other Intensive Training International IT Certifications
  10g DBA Track  
  10g iDS Track  
  10g Java Develop. Track  
  10g App. Server Track  
  9i DBA Track  
  9i iDS Track  
  9i J2EE Java Develop. Track  
  9i AS Web Adm. Track  
Oracle Data Warehouse









































































Oracle 9i Reports Developer: Build Reports

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.

Who should attend

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


INFORMIT - Skill Development Center
Jl. Purnawarman 9c, Bandung 40117- Phone (022) 4224 168 / 4223 168
Fax. (022) 4231 168 - E-mail:

  Home | About Us | Oracle | Cisco | Microsoft | Other Training | Certification | Training Calendar  
© 2006, InformIT Ganesa Pratama. All Right Reserved