New Learning | Premium Moodle Theme

Oracle Reports Developer 10g: Building Reports Boot Camp


In this course, students learn how to design and build a variety of standard and custom Web and paper reports using Oracle Reports Developer ( Working in the declarative environment of Reports Builder, students learn how to retrieve, display, and format data from any data source in numerous reporting styles and publish the output to any destination. This is a five-day boot camp.


XML: Introduction or equivalent familiarity with basic XML


Introduction to Oracle Reports Developer

Business Intelligence
Enterprise Reporting
Oracle Reports Developer
Oracle Database 10g
Oracle Developer Suite 10g
Oracle Application Server 10g
OracleAS Reports Services
OracleAS Reports Services Architecture for the Web

Designing and Running Reports

Understanding User Requirements
Designing Reports
Master with Two Details
Retrieving and Sharing Data
Running a Report

Exploring Oracle Reports Developer

Reports Developer Executables
Invoking Reports Builder
Reports Builder Modules
Report Data and Layout
Reports Builder Components
Object Navigator
Report-Level Objects
Data Model Objects

Creating a Paper Report

Report Module Components
Building a Paper Report
Viewing the Paper Report Output
Saving the Report Definition
Reentering the Wizard
Creating Break Reports
Break Report Labels
Creating Mailing Labels and Letters

Enhancing a Basic Paper Report

What Is the Paper Design?
The Paper Design Window
Modifying a Report
Aligning Columns
Setting a Format Mask
Manipulating Objects
Modifying Visual Attributes
Applying Conditional Formatting

Managing Report Templates

Using Report Templates
Modifying a Template
Customizing the Template Margin
Customizing the Template Body
Adding Web Links to a Template for Report HTML Output
Predefining Your Own Templates
Adding a Template Preview Image

Creating a Web Report

What Is JSP Technology?
JSP Advantages
Simple JSP Example
Building a Web Report
Using the Report Wizard
Report Editor: Web Source View
JSP Tags
Web Source Example

Enhancing Reports Using the Data Model: Queries and Groups

The Data Model Objects
Modifying Properties of a Query
Applying Changes
Changing the Group Structure
Group Hierarchy
Ordering Data in a Group
Query Modifications
Filtering Data in a Group

Enhancing Reports Using the Data Model: Data Sources

Data Source Types
Pluggable Data Sources
Using XML as a Data Source
Document Type Definition File
OLAP Data Source
Using Text as a Data Source
Using JDBC as a Data Source
Using REF Cursor Queries

Enhancing Reports Using the Data Model: Creating Columns

Data Model Columns
Maintaining Data Source Columns
Producing File Content Output
Creating a Column
Creating Summary Columns
Displaying Subtotals
Displaying Percentages
Creating a Formula Column

Enhancing Reports Using the Paper Layout

Viewing the Paper Layout
Designing Multipanel Reports
Printing Multipanel Reports
Different Objects in the Paper Layout
The Paper Layout Layers
Report Processing
Paper Layout Tools
Report Bursting

Controlling the Paper Layout: Common Properties

Modifying Paper Layout Object Properties
Common Layout Properties
Sizing Objects
Layout Object Relationships
Pagination Icons in the Paper Layout
Controlling Print Frequency
Using Format Triggers

Controlling the Paper Layout: Specific Properties

Properties of a Repeating Frame
Specifying Print Direction
Controlling the Number of Records per Page
Controlling Spacing Between Records
Minimum Widow Records
System Variables
Valid Source Columns
Displaying File Contents

Web Reporting

Comparing Static and Dynamic Reporting
Adding Dynamic Content
Creating a Report Block
Invoking the Report Block Wizard
Examining the Web Source Code
rw:foreach Tag
rw:field Tag
Customizing Reports JSPs

Extending Functionality Using XML

Why Use XML Report Definitions?
Creating XML Report Definitions
Partial Report Definitions: Format Modification Example
Partial Report Definitions: Format Exception Example
Full Report Definition: Data Model Modification Example
Running XML Report Definitions
Debugging XML Report Definitions

Creating and Using Report Parameters

Creating User Parameters
Referencing Parameters in a Report Query
Using Bind References
Using Lexical References
Hints and Tips When Referencing Parameters
Creating a List of Values
Referencing System Parameters
Building a Paper Parameter Form

Embedding a Graph in a Report

Adding a Graph to a Paper Report
Adding a Graph to a Web Report
Selecting the Graph Type
Selecting the Graph Data
Adding Options to the Graph
Customizing Web Graphs
The rw:graph Tag
Customizing Graphs Using the Graph.XML File

Enhancing Matrix Reports

The Matrix Data Model
The Matrix Paper Layout
Creating Matrix Summaries
Creating the Matrix Manually
The Matrix with Group Data Model
The Matrix with Group Layout
Building a Nested Matrix
Nested Matrix Paper Layout

Coding PL/SQL Triggers

Types of Triggers in Reports
Trigger Code
Using Report Triggers
Using Data Model Triggers: PL/SQL Group Filter
Using Data Model Triggers: Parameter Validation
Using Layout Triggers
Using Format Triggers
Event-Based Reporting

Extending Functionality Using the SRW Package

Contents of the SRW Package
Outputting Messages
Executing a Nested Report
Restricting Data
Initializing Fields
Creating a Table of Contents
Performing DDL Statements
Setting Format Attributes

Maximizing Performance Using OracleAS Reports Services

Running Reports Using OracleAS Reports Services
Report Request Methods
Oracle Application Server Components
Enabling Single Sign-On Access
Running the Web Layout: JSP Run-time Architecture
Running the Paper Layout: Servlet Run-time Architecture
Running a Paper Report on the Web
Queue Manager

Building Reports: Efficiency Guidelines

Tuning Reports
Performance Measurement
Non SQL Data Sources
Investigating the Data Model
Investigating the Paper Layout
Running the Report
Different Development and Run-Time Environments
Developing Reports to Run in Different GUIs

What's included?

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers  & Onsite Certification Testing- (excluding 1-day Adobe, 1-day MS Office and PMP Boot Camps) 
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

Training Formats

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.


Instructor Led (the best training format we offer)
Live Online Classroom – Online Instructor Led
Self-Paced Video

Speak to an Admissions Representative for complete details

By far the most competitve price we found, which included exam vouchers, hands on labs, practice test and a true Master of Cyber Security concepts as our Instructor. Franklin Mesa was the best trainer I have ever had and i walked out certified on the last day of my CompTIA Security+ certification bootcamp. 

Marc Alfonso - CompTIA Security + Student


The Academy is one of the best educational values for today's job market.  I studied hard and got certified (A+ and N+).  Even though I had no prior IT experience, I now have a good job replacing obsolete computers in hospitals throughout the country.  At my job interview, I just slid my test scores and certification across the table to the interviewer, who is now my boss.  I was hired the next day.  

Not bad for a 65 year old.

John Arnett- Student 

"I congratulate The Academy for a great facility and good lab computers. The Academy is great and I will definitely be taking more courses and utilizing the services available. Omer Palo is an excellent instructor that truly knows his material. I never felt bored in his class which is a first for me. Thank You."

IT Director, Burger King Corporation

"The instructor Frank Martinez is excellent – he covered so much material in 2 weeks that was unbelievable! He definitely knows what he does and it shows in the way that he conducts each lecture. He is the greatest!"
"Thanks Academy for allowing me to experience the MCSA / MCSE + Security Boot camp."

IT Professional, Florida International University



Contact Us



FTL: 954.351.7040

MIA: 305.648.2000

Request More Information


Current Promotions!






Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Sign up for our Email Newsletter!



Students - Orbund Log-In