	Training/Mentoring

	E-Business Suite
	Business Intelligence
	Custom Development
	Database Services
	Managed Services
	Training/Mentoring
		The Service
		The Value
		References
		Contact Us / Registration
		Oracle Certification Prep
		Pricing
		Course Schedule
		Directions, Travel & Accommodations
		Register Online
	Oracle Licensing

Oracle Reports Workshop

Click here to contact us

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 days

Tuition

$930

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