Learn to build complex and sophisticated reports from any data source, in any format, using Oracle Reports Developer (9.0.4.0.1). In this course, participants also learn to deploy the reports using

OracleAS Reports Services.

Learn To

In this course, participants learn how to design and build a variety of standard and custom Web and paper reports using Oracle Reports Developer (9.0.4.0.1). Working in the declarative environment of Reports Builder, participants learn how to retrieve, display, and format data from any data source in numerous reporting styles and publish the output to any destination.

Participants learn how to add dynamic content to a static Web page and publish reports to the Web. In addition, participants learn how to customize more complex reports, embed graphical charts, and use OracleAS Reports Services to deploy the reports.

Audience

• Technical Consultant

• Reports Developer

• Business Intelligence Developer

• PL/SQL Developer

Course Objectives

• Use report parameters and customize a runtime parameter form

• Enhance reports using graphs and PL/SQL trigger code

• Maximize report performance using OracleAS Reports Services and tune reports

• Publish a report on the Web and build reports to run in various languages

• Manage report templates, create mailing labels and letters

• Identify the main components in a report document and how they are related

• Identify the differences between Web and paper reports

• Identify standard report design styles and run existing reports to various output destinations

• Create and modify basic tabular reports and high quality Web reports

• Create other report styles such as break reports and matrix reports

• Create reports by accessing data from various data sources

• Add dynamic data to an existing HTML page

Introduction to Oracle Reports Developer

• OracleAS Reports Services

• Oracle Reports Developer

• OracleAS Reports Services Architecture for the Web

• Oracle Database 10g

• Oracle Application Server 10g

• Enterprise Reporting

• Business Intelligence

• Oracle Developer Suite 10g

Designing and Running Reports

• Matrix

• Retrieving and Sharing Data

• Tabular

• Master-Detail

• Master with Two Details

• Running a Report

• Designing Reports

• Understanding User Requirements

Exploring Oracle Reports Developer

• Reports Developer Executables

• Reports Builder Modules

• Reports Builder Components

• Object Navigator

• Invoking Reports Builder

• Data Model Objects

• Report Data and Layout

• Report-Level Objects

Creating a Paper Report

• Creating Break Reports

• Building a Paper Report

• Creating Mailing Labels and Letters

• Break Report Labels

• Report Module Components

• Saving the Report Definition

• Reentering the Wizard

• Viewing the Paper Report Output

Enhancing a Basic Paper Report

• Setting a Format Mask

• Aligning Columns

• Applying Conditional Formatting

• Modifying Visual Attributes

• The Paper Design Window

• Modifying a Report

• Manipulating Objects

• What Is the Paper Design?

Managing Report Templates

• Customizing the Template Margin

• Predefining Your Own Templates

• Adding a Template Preview Image

• Adding Web Links to a Template for Report HTML Output

• Modifying a Template

• Using Report Templates

• Customizing the Template Body

Creating a Web Report

• JSP Advantages

• JSP Tags

• Simple JSP Example

• Using the Report Wizard

• Building a Web Report

• Web Source Example

• Report Editor: Web Source View

• What Is JSP Technology?

Enhancing Reports Using the Data Model: Queries and Groups

• Query Modifications

• Group Hierarchy

• Modifying Properties of a Query

• Changing the Group Structure

• The Data Model Objects

• Applying Changes

• Ordering Data in a Group

• Filtering Data in a Group

Enhancing Reports Using the Data Model: Data Sources

• Data Source Types

• Using JDBC as a Data Source

• OLAP Data Source

• Using Text as a Data Source

• Using XML as a Data Source

• Document Type Definition File

• Pluggable Data Sources

• Using REF Cursor Queries

Enhancing Reports Using the Data Model: Creating Columns

• Maintaining Data Source Columns

• Creating a Formula Column