On-line training course catalogue

Oracle 9i Reports Developer: Build Reports

Type of course: Classroom

Course details

Fee	£2100
Days	5
Course code	ORO9IFBR

We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.

Print this page | Download as Word document |

Overview

Please note that Oracle courses running at London training centres are subject to a 5% surcharge.

In this course, students design and build a variety of standard and custom Web and paper reports using Oracle9i Reports Developer. Working in the declarative environment of Reports Builder, students learn how to retrieve data from any data source, display it in any format, and publish the output to any destination.

Students 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 Oracle9iAS Reports Services to deploy their reports.

Delegates will learn how to

• Administer server resources
• Create high quality Web reports
• Use templates to create mailing labels and letters
• Create and modify basic tabular reports
• Build reports using XML
• Add dynamic data to an HTML page
• Identify the main components in a report document and how they are related
• Enhance reports with PL/SQL trigger code
• Publish a report on the Web
• Tune reports
• Create other report styles such as break reports and matrix reports
• Use report parameters and customize a runtime parameter form
• Maximize report performance using Oracle9iAS Reports Services
• Manage report templates
• Create and embed a graph in a report
• Identify standard report design styles and run existing reports to various output destinations

Outline

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