INTRODUCTION TO ORACLE REPORTS DEVELOPER
▪ Business Intelligence
▪ OracleAS Reports Services
DESIGNING AND RUNNING REPORTS
▪ Designing Reports
▪ Tabular, Master-Detail, Master with Two Details
▪ Matrix
▪ Retrieving and Sharing Data
WORKING IN ORACLE REPORTS DEVELOPER
▪ Reports Developer Executables
▪ Reports Builder Components
CREATING A PAPER REPORT
▪ Building & Viewing the Paper Report Output
▪ Creating Break Reports
▪ Creating Mailing Labels and Letters
ENHANCING A BASIC PAPER REPORT
▪ Aligning Columns
▪ Setting a Format Mask
▪ Applying Conditional Formatting
MANAGING REPORT TEMPLATES
▪ Customizing the Template Margin & the Template Body
▪ Adding Web Links to a Template
CREATING A WEB REPORT
▪ JSP Advantages
▪ Building a Web Report
THE DATA MODEL: QUERIES AND GROUPS
▪ Modifying Properties of a Query
▪ Changing the Group Structure
▪ Ordering & Filtering Data in a Group
THE DATA MODEL: DATA SOURCES
▪ Using XML as a Data Source
▪ OLAP Data Source
▪ Using Text or Using JDBC as a Data Source
THE DATA MODEL: CREATING COLUMNS
▪ Producing File Content Output
▪ Displaying Subtotals, Percentages, & a Formula Columns
ENHANCING REPORTS USING THE PAPER LAYOUT
▪ Designing & Printing Multipanel Reports
▪ Paper Layout Tools
▪ Report Bursting
CONTROLLING THE PAPER LAYOUT: COMMON PROPERTIES
▪ Modifying Paper Layout Object Properties
▪ Pagination Icons in the Paper Layout
▪ Using Format Triggers
CONTROLLING THE PAPER LAYOUT: SPECIFIC PROPERTIES
▪ Properties of a Repeating Frame
▪ Specifying Print Direction
▪ System Variables
▪ Displaying File Contents
WEB REPORTING
▪ Adding Dynamic Content
▪ rw:foreach & field Tag
▪ Customizing Reports JSPs
EXTENDING FUNCTIONALITY USING XML
▪ Partial Report Definitions
▪ Full Report Definition
▪ Running & Debugging XML Report Definitions
CREATING AND USING REPORT PARAMETERS
▪ Using Bind References & Lexical References
▪ Creating a LOV
▪ System & Paper Parameters
EMBEDDING A GRAPH IN A REPORT
▪ Adding a Graph to a Paper Report & a Web Report
▪ Selecting the Graph Type & Graph Data
ENHANCING MATRIX REPORTS
▪ The Matrix Data Model & Paper Layout
▪ The Matrix with Group Data Model & Group Layout
▪ Building a Nested Matrix
CODING PL/SQL TRIGGERS
▪ Using Report Triggers
▪ Group Filter
▪ Using Layout Triggers & Format Triggers
▪ Event-Based Reporting
EXTENDING FUNCTIONALITY USING THE SRW PACKAGE
▪ Restricting Data
▪ Initializing Fields
▪ Creating a Table of Contents
▪ Performing DDL Statements
ORACLEAS REPORTS SERVICES
▪ Reports Services
▪ Report Request Methods
▪ Enabling Single Sign-On Access
▪ Running the Web Layout & Paper Layout
▪ Queue Manager
BUILDING REPORTS: EFFICIENCY GUIDELINES
▪ Performance Measurement
▪ Investigating the Data Model & Paper Layout
▪ Different Development and Run-Time Environments