Course Content
INTRODUCTION
- Business Intelligence
- Enterprise Reporting
- Oracle Reports Developer
- Oracle Database 10g
- Oracle Developer Suite 10g
- OracleAS 10g
- OracleAS Reports Services
DESIGNING AND RUNNING REPORTS
- User Requirements
- Designing Reports
- Tabular
- Master-Detail
- Master with Two Details
- Matrix
- Retrieving and Sharing Data
- Running a Report
- 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 AND ENHANCING A PAPER REPORT
- Report Module Components
- Building a Paper Report and Viewing Output
- Saving the Report Definition
- Reentering the Wizard
- Creating Break Reports
- Break Report Labels
- Creating Mailing Labels and Letters
- 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
- 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
- Building a Web Report
- Using the Report Wizard
- Report Editor: Web Source View
- JSP Tags
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 Source Types
- Pluggable Data Sources
- Using XML as a Data Source
- Document Type Definition File
- OLAP Data Source
- Using Text and 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 and Printing Multipanel Reports
- Different Objects in the Paper Layout
- The Paper Layout Layers
- Report Processing
- Paper Layout Tools
- Report Bursting
CONTROLLING THE PAPER LAYOUT
- 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 and 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 and rw.field
- Customizing Reports JSPs
EXTENDING FUNCTIONALITY USING XML
- Creating XML Report Definitions
- Running and 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 Report
- Selecting the Graph Type and Data
- Adding Options
- Customizing Web Graphs
- The rw:graph Tag
- Customizing Graphs
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
- Nested Matrix
PL/SQL TRIGGERS
- Types of Triggers in Reports
- Trigger Code
- Using Report Triggers
- Using Data Model Triggers
- Using Triggers
- Event-Based Reporting
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
- Running Reports Using OracleAS Reports Services
- Report Request Methods
- Oracle Application Server Components
- Enabling Single Sign-On Access
- Running the Layouts
- Running a Paper Report on the Web
- Queue Manager
BUILDING REPORTS
- 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
