Oracle Reports Developer 10g: Build Reports Self-Study Content Details

Controlling the Paper Layout: Common Properties

• Modifying Paper Layout Object Properties
• Common Layout Properties
• Sizing Objects
• Anchors
• Layout Object Relationships
• Pagination Icons in the Paper Layout
• Controlling Print Frequency
• Using Format Triggers

Controlling the Paper Layout: Specific Properties

• Properties of a Repeating Frame
• Specifying Print Direction
• Controlling the Number of Records per Page
• Controlling Spacing Between Records
• Minimum Widow Records
• System Variables
• Valid Source Columns
• Displaying File Contents

Web Reporting

• Comparing Static and Dynamic Reporting
• Adding Dynamic Content
• Creating a Report Block
• Invoking the Report Block Wizard
• Examining the Web Source Code
• rw:foreach Tag
• rw:field Tag
• Customizing Reports JSPs

Extending Functionality Using XML

• Why Use XML Report Definitions?
• Creating XML Report Definitions
• Partial Report Definitions: Format Modification Example
• Partial Report Definitions: Format Exception Example
• Full Report Definition: Data Model Modification Example
• Running XML Report Definitions
• Debugging XML Report Definitions

Creating and Using Report Parameters

• Creating User Parameters
• Referencing Parameters in a Report Query
• Using Bind References
• Using Lexical References
• Hints and Tips When Referencing Parameters
• Creating a List of Values
• Referencing System Parameters
• Building a Paper Parameter Form

Embedding a Graph in a Report

• The Matrix Data Model
• The Matrix Paper Layout
• Creating Matrix Summaries
• Creating the Matrix Manually
• The Matrix with Group Data Model
• The Matrix with Group Layout
• Building a Nested Matrix
• Nested Matrix Paper Layout

Coding PL/SQL Triggers

• Types of Triggers in Reports
• Trigger Code
• Using Report Triggers
• Using Data Model Triggers: PL/SQL Group Filter
• Using Data Model Triggers: Parameter Validation
• Using Layout Triggers
• Using Format Triggers
• Event-Based Reporting

Extending Functionality Using the SRW Package

• Contents of the SRW Package
• Outputting Messages
• Executing a Nested Report
• Restricting Data
• Initializing Fields
• Creating a Table of Contents
• Performing DDL Statements
• Setting Format Attributes

Maximizing Performance Using OracleAS Reports Services

• Running Reports Using OracleAS Reports Services
• Report Request Methods
• Oracle Application Server Components
• Enabling Single Sign-On Access
• Running the Web Layout: JSP Run-time Architecture
• Running the Paper Layout: Servlet Run-time Architecture
• Running a Paper Report on the Web
• Queue Manager

Building Reports: Efficiency Guidelines

• Tuning Reports
• Performance Measurement
• Non SQL Data Sources
• Investigating the Data Model
• Investigating the Paper Layout
• Running the Report
• Different Development and Run-Time Environments
• Developing Reports to Run in Different GUIs