Introduction to Oracle Reports
Duration
Four Days
Audience
This course is designed for application developers.
Pre-requisites
The student should have a complete understanding of SQL, SQL*Plus, PL/SQL, and Relational Database Concepts.
Description
This course provides the student with instruction using Oracle Reports, the report writer component of the Oracle Developer suite. The student will build complete productionstyle reports using Oracle Reports and various layout styles such as master-detail, tabular, label, and matrix. Inclusion of images and other graphical items will be included as well as how to use user-defined parameters.
Topics
- Overview of Oracle Reports
- Oracle Reports objects
- Designer interface
- The object navigator
- Object navigator views
- Oracle Reports filetypes and storage methods
- Oracle Reports executables
- Oracle Reports on-line help system
- Using report wizards
- Creating a default report
- Viewing and modifying reports using the live previewer
- Using the Data Model/Layout Editor
Tabular Reports
- Data Model objects
- Data Model objects created by default
- Layout objects
- Layout objects created by default
- Tool palettes
- Oracle Reports menus
- Overview of the reports server
- Using report templates
- Break reports
- Defining and modifying properties
- Matrix reports
- Creating and using parameters
- Placing graphics and images in your report
- Using headers and footers
- Sizing and positioning objects in the layout editor
- Arranging objects in the layout
- Manually creating objects in the layout editor
- Creating margins
- Page numbering
- Using colors and the color palette
- Creating and customizing the parameter form
- Outputting messages at runtime
- Embedding a chart in a report
- Referencing a PL/SQL library
- Overview of the report builder built-in package, SRW
- Form letter/Mailing label reports
- Using external queries
- Report and format triggers
- Master/Detail reports
- Using summaries and formulas
