back to Course Categories | back | print
Oracle9i iDS Reports: Build Internet Reports          

Duration: 3 days

Description 
In this course students build a variety of standard and custom reports using Oracle Reports. Working in a graphical user interface environment, students learn to retrieve, display, and format data in numerous reporting styles. They also learn to customize more complex reports, create drill-down reports, and call Reports from Oracle Forms.

Topics

  • Business intelligence
  • Features of Report Builder
  • Components of Report Builder
  • Customizing an Oracle Reports Session
  • Report styles
  • Identify the main components in a report and how they are related
  • Create and modify basic tabular reports using the Report Wizard
  • Create other report styles such as break reports
  • Mailing labels
  • Letters
  • Matrix reports
  • Matrix layout model
  • Matrix summaries
  • Web enabling a report
  • Publishing a report on the web
  • Enhance a Report in the Live Previewer
  • Aligning columns
  • Format masks
  • Design Reports to Accept Runtime Parameters
  • Enhance a report by creating additional layout objects
  • Reports template editor
  • Modifying a template editor
  • Registering a customized template
  • Data model objects
  • Modifying the group structure
  • Using group filters
  • Use the Data Model to create custom columns
  • Summary columns
  • Formula columns
  • Report sections
  • Multipanel reports
  • Positioning report objects
  • Working with format triggers
  • Placeholder columns
  • Repeating frames
  • Controlling space between records
  • User parameters
  • System parameters
  • Using graphics charts
  • Embedding a graphics chart
  • Passing report data to a report
  • Chart hyperlinks
  • Code PL/SQL Triggers in Reports
  • Report triggers
  • Data model triggers
  • Layout model triggers
  • Writing reusable code
  • Use the Report Builder SRW Built-In Package
  • Managing temporary tables
  • Modifying visual attributes
  • Static-web reporting
  • Dynamic-web reporting
  • Web setting properties
  • Developing reports using XML
  • Runtime modifications
  • Applying batch updates
  • Call Reports from Oracle Forms
  • The Reports Server
  • The Reports server architecture
  • Viewing reports in queue management
  • Controlling user access

Prerequisites

  • A complete understanding of SQL, PL/SQL, and Relational Database Concepts.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design