Introduction
to Oracle Reports Developer
·
Business Intelligence
·
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
Designing
and Running Reports
·
Understanding User Requirements
·
Designing Reports
·
Tabular
·
Master-Detail
·
Master with Two Details
·
Matrix
·
Retrieving and Sharing Data
·
Running a Report
Working in
Oracle Reports Developer
·
Reports Developer Executables
·
Invoking Reports Builder
·
Reports Builder Modules
·
Report Data and Layout
·
Reports Builder Components
·
Object Navigator
·
Report-Level Objects
·
Data Model Objects
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
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
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
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
·
Web Source Example
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
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
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
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
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
·
Adding a Graph to a Paper Report
·
Adding a Graph to a Web Report
·
Selecting the Graph Type
·
Selecting the Graph Data
·
Adding Options to the Graph
·
Customizing Web Graphs
·
The rw:graph Tag
·
Customizing Graphs Using the Graph.XML File
Enhancing Matrix Reports
·
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 z
·
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