Session 1: INTRODUCTION TO ORACLE REPORTS DEVELOPER
- Overview of Oracle Reports Developer
- Oracle Reports Developer Basic Concepts
- Paper and Web Reports
- Key Features and Benefits
- Oracle Application Server Reports Services
- Designing Reports
- Available Reports Styles
Session 2: CREATING A BASIC TABULAR PAPER REPORT
- Invoke the Reports Builder
- Use the Object Navigator
- Designing a Report to Retrieve Data Efficiently
- Use the Report Wizard to Build a Report
- Use Query Builder to Create the Query
- Apply an Appropriate Template
- Reports Property Palette
- Modify the Layout Model
- Save the Report in an Appropriate Format
Session 3: CREATE A WEB REPORT
- Use JavaServer Page Technology to Build a Web Report
- Testing a Report on the Web
- Web Technology in Oracle Reports
- Create a Web Report Using the Report Wizard
- Examine the Source Code Using the Web Source View
- Make Basic Enhancements to the Web Source Code
- Create a Cascading Stylesheet for a Report
- Preview a Report on the Web
Session 4: MANAGING REPORT TEMPLATES
- Modify a Predefined Template
- Create a New Template
- Configure the Report Builder Preferences
Session 5: BREAK REPORT
- Concepts of the Break Report
- Data Model Objects: Report Groups
- Formula Columns
- Summary Columns
- XML Settings
- Repeating Frames
- Use the Wizard to Create a Break Report
- Modify the Data Model
- Modify Field Properties
- Customise the Web Source Field Tags
- Display System Variables
- Display Report Margins
- Add Boilerplate Text and Images
- Embed Report Variables in Boilerplate Text
- Include Report Variables in the Web Source Code
Session 6: FORM REPORT
- Design and Create a Form Report
- Embed Data in Boilerplate Text
- Flex and Confine Modes
- Use the Arrange Objects tools in the Layout
- Group Operations
- External Queries
Session 7: MASTER DETAIL REPORTS
- Multi-Query Reports
- Use Data Links in the Layout Model
- Create a Master/Detail Report
- Control the Pagination of Layout Objects
- Use the Report Block Tool for a Customised Layout
- Use the Report Block Tool in a Web Report
Session 8: LAYOUT MODEL OBJECTS
- Frames
- Fields
- Boilerplate
- Anchors
- Images
- Sections
- Displaying a file in a column
Session 9: LETTERS AND MAILING LABELS
- The Mailing Label Report Style
- The Form-Letter Report Style
Session 10: MATRIX REPORTS
- Introduction to Matrix Reports
- The Matrix Data Model
- To Create a Single Query Matrix Report
- Matrix Summaries
- Multi-Level and Break Matrices
- Child dimension in matrix reports
Session 11: PARAMETERS
- System Parameters in Reports
- Using Bind Parameters in Reports
- The Use of Lexical Parameters
- Lists of Parameter Values
- The Parameter Form Screen
- Creating Parameter HTML Extensions
Session 12: PL/SQL AND TRIGGERS IN REPORTS
- PL/SQL in Oracle Reports
- Report Level Triggers
- Group Filters
- Use Parameters and Placeholders in a Report
- External and Internal PL/SQL Procedures
- PL/SQL in Oracle Reports Builder
- Create, attach and use PL/SQL Libraries
- Oracle Reports PL/SQL Packages
- Report Level PL/SQL
- Creating Reports using Ref Cursor Queries
- Enhance the Web source code with triggers
- Use JSP in the web source code instead of triggers
- The SRW Package
- Create dynamic web links using PL/SQL functions
Session 13: REPORT DISTRIBUTION
- Report Distribution and distribution files
- Distribute Paper Report sections
- Burst a Paper Report to multiple destinations
Session 14: WEB REPORTING
- Build Reports for the Web
- Use JSP in Oracle Reports
- HTML and PDF in Reports Builder
- Web Links for HTML Output
- Style Sheets
- Add a Bookmark to a Paper Report
- Add a Hyperlink to a Paper Report
- Add Dynamic Content to a Web Page
- Create an HTML file from a report
- Create a delimited file from a report
- Add Report Data to a HTML File
- Prepare a Paper Based Report for the Web
- Add Web Links to Paper Based Reports
- HTML Special Characters
Session 15: XML AND PLUGGABLE DATA SOURCES
- Storing Reports as XML files
- Generating XML Output from a Report
- Reports based on an XML Pluggable Data Source
- Reports based on Text Pluggable Data Source
Session 16: USING GRAPHICS IN A REPORT
- Oracle Graphics Objects
- Create and Embed a Graph using the Graph Wizard
- Add a Graph to a Web report
- Customise a Graph in a Report
Session 17: USING ORACLE APPLICATION SERVER REPORTS SERVICES
- Report Request Methods
- Oracle Application Server Reports Services
- Architecture Report Request Methods
- JSP Runtime Architecture
- Servlet Runtime Architecture
- Viewing and Scheduling Reports
- Monitoring and Managing Reports Services
Session 18: PERFORMANCE ISSUES
- Designing Efficient Reports
- Monitor the Performance of Reports
- Investigate Performance Issues