Oracle Reports Workshop

 Click here

Course Overview

Oracle Reports Workshop is a two-day class designed to provide students with the skills necessary to create reports using a GUI report writer. Instructor-led exercises will teach students the complete report development process, from building queries on which reports are based through designing the appropriate report format to restricting output with user-entered parameters. Lessons will include building reports using the report tool's built-in wizards, as well as the more thorough manual approach, assuring a complete understanding of the capabilities of the tool. This workshop also will cover topics related to Web-enabled reports and new features.

Course Goals

• To understand product capabilities and features
• To understand the product structure and built-in features
• To acquire knowledge in meeting prerequisites for development and customization of Oracle Reports

Prerequisites

• SQL & SQL*Plus
• PL/SQL
• Advanced PL/SQL (optional)

Who Should Attend?

• Application developers
• Designers/developers

Course Materials

• Oracle Reports Course Notes
• Oracle Reports Reference Book
• Sample Script Disk

Duration

• Two (2) days

Course Outline

• Introductions
• Report wizard
  • Types of reports
  • Using the report wizard
  • Live previewer
• Data model
  • Query builder
  • Break groups
  • Formula, summary and placeholder columns
  • Linking queries
• Layout model
  • Margin, header and trailer pages
  • Frames, items and boilerplates
  • Object sizing and formatting
  • Stacking theory
  • Anchoring
• Parameter form
  • User parameters
    • Lexical parameters
    • Parameter LOVs
  • System parameters
  • Parameter form builder
• Report triggers
  • Types
  • When to use
• Using images
  • File system
  • Database table
  • URLs
• Generate to HTML/Web
  • Web wizard
  • URLs
• Delimited output
• XML output
• Reports new features
  • Java Server Pages and servlets
  • Pluggable data source (PDS)
  • Graph wizard
  • Server enhancements
  • Report bursting and distribution enhancements