Home About Courses Schedule Services Webinars Contact Search

Oracle Reports


Duration: 4 days

Method: Instructor led, Hands-on workshops

Price: $2250.00

Course Code: OR5350


Business Intelligence Developer and Reports Developer


In this course, students learn how to design and build a variety of standard and custom Web and paper reports using Oracle 10g Reports Developer. Working in the declarative environment of Reports Builder, students learn how to retrieve, display, and format data from different data sources in a variety of reporting styles.


Upon successful completion of this course, the student will be able to:

  • Add dynamic data to an existing HTML page
  • Use report parameters and customize a runtime parameter form
  • Enhance reports using graphs and PL/SQL trigger code
  • Maximize report performance using OracleAS Reports Services and tune reports
  • Publish a report on the Web and build reports to run in various languages
  • Manage report templates, create mailing labels and letters
  • Identify the main components in a report document and how they are related
  • Identify the differences between Web and paper reports
  • Identify standard report design styles and run existing reports to various output destinations
  • Create and modify basic tabular reports and high quality Web reports
  • Create other report styles such as break reports and matrix reports
  • Create reports by accessing data from various data sources


Oracle 10g SQL & SQL*Plus and Oracle 10g PL/SQL Programming


  • I.Introduction to Oracle Reports Developer
    • Overview of Business Intelligence and Enterprise Reporting
    • Oracle Reports Developer
    • Oracle Database 10g
    • Oracle Developer Suite 10g
    • Oracle Application Server 10g
    • OracleAS Reports Services
    • OracleAS Reports Services Architecture for the Web
  • II.Designing and Running Reports
    • Designing Reports
    • Tabular
    • Master-Detail
    • Master with Two Details
    • Matrix
    • Retrieving and Sharing Data
    • Running a Report
  • III.Working in Oracle Reports Developer
    • Reports Developer Executables
    • Invoking Reports Builder
    • Reports Builder Modules
    • Report Data
    • Reports Builder Components
    • Object Navigator
    • Report-Level Objects
    • Data Model Objects
  • IV.Creating a Paper Report
    • Report Module Components
    • Building a Paper Report
    • Viewing the Paper Report Output
    • Saving the Report Definition
    • Reentering the Wizard
    • Creating Break Reports
    • Break Report Labels
    • Creating Mailing Labels and Letters
  • V.Enhancing a Basic Paper Report
    • What Is the Paper Design?
    • The Paper Design Window
    • Modifying a Report
    • Aligning Columns
    • Setting a Format Mask
    • Manipulating Objects
    • Modifying Visual Attributes
    • Applying Conditional Formatting
  • VI.Managing Report Templates
    • Using Report Templates
    • Modifying a Template
    • Customizing the Template Margin
    • Customizing the Template Body
    • Adding Web Links to a Template for Report HTML Output
    • Predefining Your Own Templates
    • Adding a Template Preview Image
  • VII.Creating a Web Report
    • What Is JSP Technology?
    • JSP Advantages
    • Simple JSP Example
    • Building a Web Report
    • Using the Report Wizard
    • Report Editor: Web Source View
    • JSP Tags
  • VIII.Enhancing Reports Using the Data Model: Queries and Groups
    • The Data Model Objects
    • Modifying Properties of a Query
    • Applying Changes
    • Changing the Group Structure
    • Group Hierarchy
    • Ordering Data in a Group
    • Query Modifications
    • Filtering Data in a Group
  • IX.Enhancing Reports Using the Data Model: Data Sources
    • Data Source Types
    • Pluggable Data Sources
    • Using XML as a Data Source
    • Document Type Definition File
    • OLAP Data Source
    • Using Text as a Data Source
    • Using JDBC as a Data Source
    • Using REF Cursor Queries
  • X.Enhancing Reports Using the Data Model: Creating Columns
    • Data Model Columns
    • Maintaining Data Source Columns
    • Producing File Content Output
    • Creating a Column
    • Creating Summary Columns
    • Displaying Subtotals
    • Displaying Percentages
    • Creating a Formula Column
  • XI.Enhancing Reports Using the Paper Layout
    • Viewing the Paper Layout
    • Designing Multipanel Reports
    • Printing Multipanel Reports
    • Different Objects in the Paper Layout
    • The Paper Layout Layers
    • Report Processing
    • Paper Layout Tools
    • Report Bursting