Skip Navigation Links

Course Length:
5 Days
Course Description:
Students learn how to design reports and how to retrieve, display, and format data in numerous reporting styles and publish the output. Students also learn how to add dynamic content to a static Web page, publish reports to the Web, customize complex reports, embed charts, and use OracleAS Reports Services to deploy reports.
Who Should Attend:
This course is for Technical Consultants, Reports Developers, and Business Intelligence Developers.
Benefits of Attendance:
Upon completion of this course, students will be able to:
  • Add dynamic data to an existing HTML page
  • Use report parameters and customize a runtime parameter form
  • Enhance reports and maximize report performance
  • Publish a report on the Web and build reports to run in various languages
  • Manage report templates
  • Identify main components in a report document
  • Identify the differences between Web and paper reports
  • Identify report design styles and run existing reports to various output destinations
  • Create basic tabular reports and high quality Web reports
  • Create other report styles
  • Create reports by accessing data from various data sources
Prerequisites:
Students should have taken XML: Introduction or have equivalent familiarity with basic XML.
Course Outline:
  • Introduction
    1. Business Intelligence
    2. Enterprise Reporting
    3. Oracle Reports Developer
    4. Oracle Database 10g
    5. Oracle Developer Suite 10g
    6. OracleAS 10g
    7. OracleAS Reports Services
  • Designing and Running Reports
    1. User Requirements
    2. Designing Reports
    3. Tabular
    4. Master-Detail
    5. Master with Two Details
    6. Matrix
    7. Retrieving and Sharing Data
    8. Running a Report
    9. Reports Developer Executables
    10. Invoking Reports Builder
    11. Reports Builder Modules
    12. Report Data and Layout
    13. Reports Builder Components
    14. Object Navigator
    15. Report-Level Objects
    16. Data Model Objects
  • Creating and Enhancing a Paper Report
    1. Report Module Components
    2. Building a Paper Report and Viewing Output
    3. Saving the Report Definition
    4. Reentering the Wizard
    5. Creating Break Reports
    6. Break Report Labels
    7. Creating Mailing Labels and Letters
    8. What Is the Paper Design?
    9. The Paper Design Window
    10. Modifying a Report
    11. Aligning Columns
    12. Setting a Format Mask
    13. Manipulating Objects
    14. Modifying Visual Attributes
    15. Applying Conditional Formatting
  • Managing Report Templates
    1. Using Report Templates
    2. Modifying a Template
    3. Customizing the Template
    4. Adding Web Links to a Template for Report HTML Output
    5. Predefining Your Own Templates
    6. Adding a Template Preview Image
  • Creating a Web Report
    1. What Is JSP Technology?
    2. JSP Advantages
    3. Building a Web Report
    4. Using the Report Wizard
    5. Report Editor: Web Source View
    6. JSP Tags
  • Enhancing Reports Using the Data Model: Queries and Groups
    1. The Data Model Objects
    2. Modifying Properties of a Query
    3. Applying Changes
    4. Changing the Group Structure
    5. Group Hierarchy
    6. Ordering Data in a Group
    7. Query Modifications
    8. Filtering Data in a Group
  • Enhancing Reports Using the Data Model
    1. Data Source Types
    2. Pluggable Data Sources
    3. Using XML as a Data Source
    4. Document Type Definition File
    5. OLAP Data Source
    6. Using Text and JDBC as a Data Source
    7. Using REF Cursor Queries
  • Enhancing Reports Using the Data Model: Creating Columns
    1. Data Model Columns
    2. Maintaining Data Source Columns
    3. Producing File Content Output
    4. Creating a Column
    5. Creating Summary Columns
    6. Displaying Subtotals
    7. Displaying Percentages
    8. Creating a Formula Column
  • Enhancing Reports Using the Paper Layout
    1. Viewing the Paper Layout
    2. Designing and Printing Multipanel Reports
    3. Different Objects in the Paper Layout
    4. The Paper Layout Layers
    5. Report Processing
    6. Paper Layout Tools
    7. Report Bursting
  • Controlling the Paper Layout
    1. Modifying Paper Layout Object Properties
    2. Common Layout Properties
    3. Sizing Objects
    4. Anchors
    5. Layout Object Relationships
    6. Pagination Icons in the Paper Layout
    7. Controlling Print Frequency
    8. Using Format Triggers
  • Controlling the Paper Layout: Specific Properties
    1. Properties of a Repeating Frame
    2. Specifying Print Direction
    3. Controlling the Number of Records per Page and Spacing Between Records
    4. Minimum Widow Records
    5. System Variables
    6. Valid Source Columns
    7. Displaying File Contents
  • Web Reporting
    1. Comparing Static and Dynamic Reporting
    2. Adding Dynamic Content
    3. Creating a Report Block
    4. Invoking the Report Block Wizard
    5. Examining the Web Source Code
    6. rw:foreach and rw.field
    7. Customizing Reports JSPs
  • Extending Functionality Using XML
    1. Creating XML Report Definitions
    2. Running and Debugging XML Report Definitions
  • Creating and Using Report Parameters
    1. Creating User Parameters
    2. Referencing Parameters in a Report Query
    3. Using Bind References
    4. Using Lexical References
    5. Hints and Tips When Referencing Parameters
    6. Creating a List of Values
    7. Referencing System Parameters
    8. Building a Paper Parameter Form
  • Embedding a Graph in a Report
    1. Adding a Graph to a Report
    2. Selecting the Graph Type and Data
    3. Adding Options
    4. Customizing Web Graphs
    5. The rw:graph Tag
    6. Customizing Graphs
  • Enhancing Matrix Reports
    1. The Matrix Data Model
    2. The Matrix Paper Layout
    3. Creating Matrix Summaries
    4. Creating the Matrix Manually
    5. The Matrix with Group Data Model
    6. The Matrix with Group Layout
    7. Nested Matrix
  • PL/SQL Triggers
    1. Types of Triggers in Reports
    2. Trigger Code
    3. Using Report Triggers
    4. Using Data Model Triggers
    5. Using Triggers
    6. Event-Based Reporting
  • Using the SRW Package
    1. Contents of the SRW Package
    2. Outputting Messages
    3. Executing a Nested Report
    4. Restricting Data
    5. Initializing Fields
    6. Creating a Table of Contents
    7. Performing DDL Statements
    8. Setting Format Attributes
  • Maximizing Performance
    1. Running Reports Using OracleAS Reports Services
    2. Report Request Methods
    3. Oracle Application Server Components
    4. Enabling Single Sign-On Access
    5. Running the Layouts
    6. Running a Paper Report on the Web
    7. Queue Manager
  • Building Reports
    1. Tuning Reports
    2. Performance Measurement
    3. Non SQL Data Sources
    4. Investigating the Data Model
    5. Investigating the Paper Layout
    6. Running the Report
    7. Different Development and Run-Time Environments
    8. Developing Reports to Run in Different GUIs