Oracle Reports v3,6,6i

Course

Inhouse

Price on request

Description

  • Type

    Course

  • Methodology

    Inhouse

  • Duration

    3 Days

This is a practical course covering Oracle's flagship report writing tool, Oracle Reports v6/6i and also v3. The course aims to cover ground level techniques necessary to understand the product and implement enterprise standard reports within the development business environment. Suitable for: Analyst/Designers. Analyst Programmers. Technicians.

About this course

There are no prerequisites. .

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Training Course Objectives:
This is a practical course covering Oracle's flagship report writing tool, Oracle Reports v6/6i and also v3.
The course aims to cover ground level techniques necessary to understand the product and implement enterprise standard reports within the development business environment.
Training Course Contents: Report Basics
  • What is Oracle Reports?
  • Welcome to Report Builder
  • Object Navigator Menus
  • Object Navigator Toolbars
  • Object Navigator Structures
Building a Basic Report
  • Using the Report Wizard
  • Using the Data Wizard Manually
  • What Data Model Objects Were Built?
  • What Layout Model Objects Were Built?
  • What Obect Navigator Objects Were Built?
Data Model
  • Data Model Work Area
  • Formula Columns
  • Control Break Groups Using the Report Wizard
  • Control Break Groups Manually
  • Summary Columns using the Report Wizard
  • Summary Columns Manually
  • Query Properties
  • Group Properties
  • Database Column Properties
  • Multiple Queries & the Additional Default Layout Tool
  • Query Data Links
  • Query Builder
Live Previewer & Layout Model
  • Live Previewer Work Area
  • Report Formatting using the Live Previewer,
  • Layout Model Work Area,
  • Layout Model Tools,
  • Layout Model Menus,
  • Report Formatting using the Layout Model,
  • Layout Object Proporties,
  • Header and Trailer Pages,
  • Margin Page,
  • Direct Column and Field Referencing,
  • Tabular Report Style,
  • Group Left Report Style,
  • Form Like Report Style,
  • Mailing Label Report Style,
  • Form Letter Report Style,
  • Group Above Report Style,
  • Matrix Report Style,
  • Matrix with Group Report Style
Templates
  • Template Editor Work Area,
  • Template Data Model,
  • PL/SQL in Templates,
  • Group Levels in Templates,
  • Adding Templates to the Predetermined List.
Report Parameters
  • Setting System Parameters,
  • Creating User Parameters,
  • Building Parameter Drop Down Lists,
  • Parameter Form Builder,
  • Parameter Form Formatting.
PL/SQL in Reports
  • PL/SQL Overview,
  • Oracle 8 Support,
  • PL/SQL Editor,
  • Syntax Palette,
  • Find and Replace in PL/SQL,
  • Report Triggers,
  • Format Triggers,
  • Validation Triggers,
  • Creating Independent Program Units,
  • Building and Using PL/SQL Libraries,
  • SRW. Message Built In,
  • SRW. Set_Field Built Ins,
  • Conditional Formatting and the SRW. Set Built Ins.
Report Output and Distribution
  • Generating RTF Output for Word Processors,
  • Generating Delimited Text File Output,
  • Generating HTML Output,
  • Generating HTML Style Sheet Output,
  • Generating XML Output,
  • Generating PDF Output,
  • Setting Report Distribution Properties,
  • Building a Report Distribution File,
  • Distributing Report Output.
Preparing Reports for the Web
  • What is the Report Server?
  • Using the WEB Wizard,
  • Setting the WEB Properties.
Interactive Reporting
  • Creating Buttons in Reports.
  • Drilling Through Reports Using SRW. Run_Report.

Oracle Reports v3,6,6i

Price on request