Back to Search Results

Training Course Summary:

This powerful Developer/2000 report development tool, Reports 2.5, enables database server information to be structured, formatted and combined with text and graphics for presentation in reports. This course shows the delegate how to develop and tune Reports 2.5 applications.

Pre-Requisites:

Introduction to Oracle SQL and PL/SQL (SPLI) Develop PL/SQL Program Units (DPP) Developer/2000 Core Technology (CORE)

Training Course Overview/Content:

Course Introduction
Product version history
Course structure

How to Design and Execute a Report
Styles and structures
Invoking and using Oracle Reports
The objects that make up reports and data models
Specifying database information for the report using data models
Managing the appearance of data with layout objects
Report storage methods and executables

Useful Data Handling Techniques
Restricting the data retrieved
Outputting the contents of a file in a column within the report

Handling Wide-Ranging Reporting Requirements
Taking detailed control of the layout using the properties of layout objects
Producing matrix reports and summaries

Reports with Procedural Functionality
Adding procedural functionality to reports using triggers
The packaged functions and procedures supplied with Oracle Reports 2.5

Runtime Parameters
Enabling the user to supply values at runtime to control report output

Version and Platform Issues
Developing reports to run in different GUIs
Producing reports for execution in character mode environments
Taking advantage of MS windows integration features

Performance
Ensuring efficient running
Debugging report code



Course Objectives

This course enables the delegate to create reports in a variety of styles, customising them to meet specific business requirements by combing text and graphics with quantitative data. Report development will be performed in a client-server environment using the power and flexibility of the Developer/2000 graphical user interface (GUI). The course also looks at the tuning of Reports.

The objectives for the end of the course is for the delegate to:

Understand the capabilities and terminology of Oracle Reports 2.5 Develop and maintain various types of reports using Oracle Reports 2.5 Lay out and format data to suit user reporting requirements Incorporate text and graphics in reports