Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

Part I Preparing Your Environment

1 Understanding the OracleAS Reports Services Architecture

• 1.1 Overview of OracleAS Reports Services
• 1.2 OracleAS Reports Services Components
• 1.3 OracleAS Reports Services Runtime Process
• 1.4 OracleAS Reports Services Communication Architecture
• • 1.4.1 Server Discovery Using the Broadcast Mechanism
  • • 1.4.1.1 Server Discovery Within a Subnet
    • 1.4.1.2 Server Discovery Across Subnets
  • 1.4.2 Server Discovery Using the COS Naming Service
• 1.5 Setting Up Your System
• • 1.5.1 Choosing the Types of Requests You Will Service
  • 1.5.2 Choosing Reports Servlet, JSP, Web Services, or CGI
  • 1.5.3 Choosing Single or Multiple-Machine Configurations
  • 1.5.4 Choosing a High Availability Environment
  • • 1.5.4.1 Maintaining High Availability in Oracle Application Server
    • 1.5.4.2 Maintaining Infrastructure Dependencies

2 Starting and Stopping OracleAS Reports Services

• 2.1 Starting and Stopping Reports Server
• • 2.1.1 Starting, Stopping, and Restarting Reports Servers from Oracle Enterprise Manager 10g
  • 2.1.2 Starting, Stopping, and Restarting Reports Servers from the Oracle Process Manager and Notification Server
  • 2.1.3 Alternative Methods of Starting and Stopping Reports Server
  • • 2.1.3.1 Starting the In-process Server (Windows and UNIX)
    • 2.1.3.2 Starting Reports Server from a Command Line (Windows and UNIX)
    • 2.1.3.3 Stopping Reports Server
• 2.2 Starting and Stopping the Oracle Reports Bridge
• • 2.2.1 Starting, Stopping, and Restarting the Oracle Reports Bridge from the Oracle Process Manager and Notification Server
  • 2.2.2 Starting and Stopping the Oracle Reports Bridge from the Command Line
• 2.3 Starting and Stopping the COS Naming Service
• 2.4 Verifying that the Oracle HTTP Server Is Running
• 2.5 Verifying that the Reports Servlet and Server Are Running

3 Configuring OracleAS Reports Services

• 3.1 OracleAS Reports Services Configuration Files
• 3.2 Configuring Reports Server
• • 3.2.1 Reports Server Configuration Elements (rwserverconf.dtd)
  • • 3.2.1.1 server
    • 3.2.1.2 compatible
    • 3.2.1.3 cache
    • 3.2.1.4 engine
    • 3.2.1.5 security
    • 3.2.1.6 oidconnection
    • 3.2.1.7 destination
    • 3.2.1.8 networkConfig
    • 3.2.1.9 job
    • 3.2.1.10 notification
    • 3.2.1.11 log
    • 3.2.1.12 jobStatusRepository
    • 3.2.1.13 trace
    • 3.2.1.14 connection
    • 3.2.1.15 ORBPorts
    • 3.2.1.16 queue
    • 3.2.1.17 persistFile
    • 3.2.1.18 jobRecovery
    • 3.2.1.19 identifier
    • 3.2.1.20 pluginParam
    • 3.2.1.21 environment
  • 3.2.2 Dynamic Environment Switching
  • • 3.2.2.1 Examples
    • 3.2.2.2 Usage Notes
  • 3.2.3 Connecting to OracleAS Portal
• 3.3 Configuring the Reports Server Discovery Mechanism
• • 3.3.1 Network Configuration Elements (rwnetworkconf.dtd)
  • • 3.3.1.1 discoveryService
    • 3.3.1.2 multicast
    • 3.3.1.3 namingService
  • 3.3.2 Bridge Configuration Elements (bridgeconf.dtd)
  • • 3.3.2.1 bridge
    • 3.3.2.2 networkConfig
    • 3.3.2.3 identifier
    • 3.3.2.4 remoteBridges
    • 3.3.2.5 remoteBridge
    • 3.3.2.6 trace
• 3.4 Configuring Reports Servlet
• • 3.4.1 Specifying the Location of the Key Map File
  • 3.4.2 Reloading the Key Map File
  • 3.4.3 Hiding Web Command Output
  • 3.4.4 Selecting Login Dialog Boxes
  • 3.4.5 Setting Up Trace Options for Reports Servlet and JSPs
  • 3.4.6 Specifying the rwservlet Character Encoding to Decode Reports Parameters
  • 3.4.7 Disallowing HTML Code Specified in the URL from Being Executed in a Browser
  • 3.4.8 Specifying the Pool Size for Concurrent Connections to rwservlet
  • 3.4.9 Customizing the Appearance of Server Error Messages
  • 3.4.10 Specifying an In-process Server
  • 3.4.11 Identifying the In-process Server
  • 3.4.12 Specifying Oracle Internet Directory Connection Pooling Parameters
  • 3.4.13 Pointing to Dynamically Generated Images
  • 3.4.14 Setting Expiration for Database and System Authentication Cookies
  • 3.4.15 Setting an Encryption Key for the Database and System Authentication Cookies
  • 3.4.16 Adding Formatting to Diagnostic and Debugging Output
  • 3.4.17 Defining the rwservlet Help File
  • 3.4.18 Specifying the Use of OracleAS Single Sign-On
  • 3.4.19 Specifying the Network Configuration File
  • 3.4.20 Migrating OracleAS Forms Services Applications that Include a Reports Server Cluster Name
  • 3.4.21 Specifying an Alternate Reports Servlet Configuration File
• 3.5 Configuring the URL Engine
• 3.6 Entering Proxy Information
• 3.7 Configuring Reports Server with the Oracle Process Manager and Notification Server and Oracle Enterprise Manager 10g
• • 3.7.1 opmn.xml
  • • 3.7.1.1 Module Specification
    • 3.7.1.2 Standalone Reports Server Specification
    • 3.7.1.3 In-process Reports Server Specification
    • 3.7.1.4 Oracle Reports Bridge Specification
    • 3.7.1.5 COS Naming Service Specification
• 3.8 Configuring Oracle Reports to Communicate with Oracle Workflow
• 3.9 Optimizing the Deployment of Reports
• 3.10 Removing DISPLAY and Printer Dependencies on UNIX
• • 3.10.1 ScreenPrinter
  • 3.10.2 Advanced Imaging Support

4 Managing Fonts in Oracle Reports

• 4.1 Using Fonts
• • 4.1.1 Fonts in Reports Builder
  • 4.1.2 Fonts in Report Output
  • • 4.1.2.1 Font lookup
  • 4.1.3 Fonts in the User Interface
• 4.2 Adding Fonts
• • 4.2.1 Adding Fonts to Reports Builder
  • 4.2.2 Adding New Fonts for Report Output
  • • 4.2.2.1 Adding fonts on UNIX
    • 4.2.2.2 Adding fonts on Windows
• 4.3 Font Configuration Files
• • 4.3.1 File Searching
• 4.4 Font Aliasing
• • 4.4.1 Specifying Aliasing Information
  • 4.4.2 Font Aliasing Mechanism
  • 4.4.3 Font Alias File Sections
  • 4.4.4 Font Aliasing File Verification
• 4.5 Troubleshooting Font Issues
• 4.6 Font Types
• • 4.6.1 Character Sets
  • 4.6.2 Unicode
  • 4.6.3 Type1 Fonts
  • 4.6.4 TrueType Fonts
  • 4.6.5 TrueType Collection
  • 4.6.6 Barcode Fonts
  • 4.6.7 CID Fonts

5 Printing on UNIX with Oracle Reports

• 5.1 UNIX Printing Overview
• • 5.1.1 General Printing Mechanism
  • 5.1.2 Oracle Reports Printing Mechanism on UNIX and Windows
  • 5.1.3 Printing Support
• 5.2 Setting Up a Printer on UNIX
• • 5.2.1 Installing a Printer on UNIX
  • 5.2.2 Verifying the Printer Setup for Oracle Reports
• 5.3 Configuring the Printing Environment
• • 5.3.1 Editing uiprint.txt File
  • 5.3.2 Environment Variables
  • 5.3.3 Print Property Dialog Boxes
  • • 5.3.3.1 Page Setup dialog box
    • 5.3.3.2 Print Job dialog box
• 5.4 Printer-Related Files
• • 5.4.1 Overview of Files
  • 5.4.2 PPD Files
  • • 5.4.2.1 Local customization of PPD files
  • 5.4.3 HPD Files
  • 5.4.4 Font Metrics Files
  • • 5.4.4.1 AFM files
    • 5.4.4.2 TFM files
  • 5.4.5 uifont.ali
  • 5.4.6 uiprint.txt
  • 5.4.7 Editing the Printer-Related Files
  • • 5.4.7.1 Editing PPD files
    • 5.4.7.2 Editing HPD files for PCL printing
• 5.5 Globalization Support
• • 5.5.1 Multibyte Character Set Printing
  • 5.5.2 Overview of IX and PASTA
• 5.6 Debugging Options
• • 5.6.1 DEBUG_SLFIND
  • 5.6.2 TK_DEBUG_POSTSCRIPT
• 5.7 Frequently Asked Questions
• • 5.7.1 Common Printing Error Messages
  • 5.7.2 PCL Printing Issues
  • 5.7.3 PostScript Printing Issues
  • 5.7.4 Font-Related Printing Issues
  • 5.7.5 Printed Output Issues

6 Using PDF in Oracle Reports

• 6.1 PDF Features Included in Oracle Reports
• • 6.1.1 Compression
  • • 6.1.1.1 Setup
  • 6.1.2 Font-Related Features
  • • 6.1.2.1 Font Aliasing
    • 6.1.2.2 Font Subsetting
    • 6.1.2.3 Font Embedding
    • 6.1.2.4 Font Feature Summary
  • 6.1.3 Precedence of Execution
  • 6.1.4 Accessibility
  • 6.1.5 Taxonomy
  • 6.1.6 Graph Support
• 6.2 Resolving PDF Font Issues During Cross-Platform Deployment
• • 6.2.1 Designing and Deploying a Report on the Same Platform
  • 6.2.2 Designing and Deploying a Report on Different Platforms
  • • 6.2.2.1 Generating a PDF Report Using Single Byte Fonts
    • 6.2.2.2 Generating a PDF Report Using Multibyte and Unicode Fonts
• 6.3 Generating a Unicode PDF File
• • 6.3.1 Font Subsetting
• 6.4 Generating a Bidirectional (BiDi) PDF File
• • 6.4.1 Font Subsetting
• 6.5 Generating a Multibyte PDF File
• • 6.5.1 Font Aliasing
  • 6.5.2 Font Subsetting
• 6.6 Generating a Barcode PDF File
• • 6.6.1 Font Embedding
  • 6.6.2 Font Subsetting

7 Resolving Cross-Platform Porting Issues

• 7.1 Overview of Cross-Platform Issues
• • 7.1.1 Font Availability On Different Platforms
  • 7.1.2 Fixing Font-Related Issues
• 7.2 Generating HTMLCSS, RTF, or Web Output
• • 7.2.1 Designing Your Report
  • 7.2.2 Deploying Your Report
  • • 7.2.2.1 Troubleshooting Information
  • 7.2.3 Frequently Asked Questions
• 7.3 Generating Single-Byte PDF Output
• • 7.3.1 Designing Your Report
  • 7.3.2 Deploying Your Report
  • • 7.3.2.1 Troubleshooting Information
  • 7.3.3 Frequently Asked Questions
• 7.4 Generating Multibyte PDF Output
• • 7.4.1 Designing Your Report
  • 7.4.2 Deploying Your Report
  • • 7.4.2.1 Troubleshooting Information
  • 7.4.3 Frequently Asked Questions
• 7.5 Generating Unicode PDF Output
• • 7.5.1 Designing Your Report
  • 7.5.2 Deploying Your Report
  • • 7.5.2.1 Troubleshooting Information
  • 7.5.3 Frequently Asked Questions
• 7.6 Generating PostScript Output
• • 7.6.1 Designing Your Report
  • 7.6.2 Deploying Your Report
  • 7.6.3 Frequently Asked Questions

8 Configuring Destinations for OracleAS Reports Services

• 8.1 Overview of Output Processing
• 8.2 Registering Destination Types with the Server
• • 8.2.1 Setting Up a Destination Section in the Server Configuration File
  • 8.2.2 Entering Valid Values for a Destination
  • • 8.2.2.1 Destination destypes and classes
    • 8.2.2.2 Destination Property name/value Pairs
  • 8.2.3 Example Destination

9 Configuring and Using the JDBC PDS

• 9.1 JDBC Configuration File
• • 9.1.1 Verifying Pre-installed Driver Entries
  • 9.1.2 Installing and Configuring Merant DataDirect Drivers
  • • 9.1.2.1 Sybase Driver
    • 9.1.2.2 DB2 Driver
    • 9.1.2.3 SQL Server Driver
    • 9.1.2.4 Informix Driver
    • 9.1.2.5 Custom Driver
• 9.2 Defining and Running a JDBC Query
• • 9.2.1 Sample Connection Information
• 9.3 Running a JDBC Report Using OracleAS Reports Services
• 9.4 Troubleshooting Information
• • 9.4.1 Error Messages
  • 9.4.2 Trace Information
• 9.5 Adding Your Own JDBC Driver
• • 9.5.1 Configuring the jdbcpds.conf File
  • 9.5.2 Installing the Driver's JAR Files

10 Securing OracleAS Reports Services

• 10.1 About OracleAS Reports Services Security
• • 10.1.1 Resources Protected
  • • 10.1.1.1 Application Security
    • 10.1.1.2 Resource Security
    • 10.1.1.3 Data Source Security
  • 10.1.2 Authorization and Access Enforcement
  • • 10.1.2.1 Handling Report Requests with OracleAS Single Sign-On
    • 10.1.2.2 Handling Report Requests without OracleAS Single Sign-On
  • 10.1.3 Leveraging Oracle Identity Management Infrastructure
  • • 10.1.3.1 OracleAS Single Sign-On
• 10.2 Configuring OracleAS Reports Services Security
• • 10.2.1 Configuring OracleAS Reports Services Security Options
  • • 10.2.1.1 OracleAS Portal
    • 10.2.1.2 Security Interfaces

11 Configuring and Administering OracleAS Single Sign-On

• 11.1 Prerequisites
• 11.2 Configuring Out-of-the-Box OracleAS Single Sign-On
• 11.3 Administering OracleAS Single Sign-On
• • 11.3.1 Enabling and Disabling OracleAS Single Sign-On
  • 11.3.2 Enabling and Disabling Reports Server Security
  • 11.3.3 Enabling and Disabling Data Source Security
  • • 11.3.3.1 SSOCONN
    • 11.3.3.2 Populating Oracle Internet Directory
    • 11.3.3.3 Adding a New Resource Type
  • 11.3.4 Connecting to Oracle Internet Directory
  • • 11.3.4.1 Choosing the Connecting Entity for Oracle Internet Directory
    • 11.3.4.2 Choosing the Oracle Internet Directory Instance
• 11.4 Choosing the Connecting Entity for Oracle Internet Directory
• 11.5 OracleAS Forms Services Security Considerations

12 Deploying Reports in OracleAS Portal

• 12.1 Creating Reports Users and Named Groups
• • 12.1.1 Default Reports-Related Groups
  • • 12.1.1.1 RW_BASIC_USER
    • 12.1.1.2 RW_POWER_USER
    • 12.1.1.3 RW_DEVELOPER
    • 12.1.1.4 RW_ADMINISTRATOR
  • 12.1.2 Creating Users and Groups
• 12.2 Registering Oracle Reports Components
• • 12.2.1 Registering a Reports Server
  • 12.2.2 Registering a Report
  • 12.2.3 Registering a Printer
  • 12.2.4 Creating an Availability Calendar
  • • 12.2.4.1 Creating a Simple Availability Calendar
    • 12.2.4.2 Creating a Combined Availability Calendar
  • 12.2.5 The Manage Portlet
• 12.3 Publishing Your Report as a Portlet
• • 12.3.1 Creating a Provider for Your Reports
  • 12.3.2 Adding the Report Portlet to a Page
  • 12.3.3 Adding the Reports Component as an Item Link to a Page
  • 12.3.4 Running Reports on OracleAS Portal as an Item Link on a Nondefault Installation
• 12.4 Troubleshooting Information
• • 12.4.1 Resolving Reports-Portal Integration Error When Attempting Create Resource

Part II Sending Requests to the Server

13 Running Report Requests

• 13.1 The Reports URL Syntax
• • 13.1.1 Servlet
  • 13.1.2 JSP
  • 13.1.3 CGI
• 13.2 Report Request Methods
• 13.3 Deploying Your Reports
• • 13.3.1 Deploying a Report with a Paper Layout
  • 13.3.2 Running a Report with a Paper Layout
  • 13.3.3 Deploying a JSP Report to the Web and to Paper
  • • 13.3.3.1 Creating a New J2EE Application
    • 13.3.3.2 Deploying the J2EE Application Using OC4J
  • 13.3.4 Running a JSP-Based Web Report from a Browser
  • 13.3.5 Running a JSP report with a Paper Layout
  • 13.3.6 Running with the WE8MSWIN1252 Character Set on UNIX
• 13.4 Publishing a Report in OracleAS Portal
• 13.5 Specifying a Report Request from a Web Browser
• 13.6 Sending a Request to the URL Engine
• 13.7 Running Reports Through a Web Service
• 13.8 Running Reports from Oracle Workflow
• 13.9 Scheduling Reports to Run Automatically
• 13.10 Additional Parameters
• 13.11 Reusing Report Output from Cache
• • 13.11.1 Usage Note
• 13.12 Using a Key Map File
• • 13.12.1 Enabling Key Mapping
  • 13.12.2 Adding Key Mapping Entries to a Key Map File
  • 13.12.3 Using a Key with Everything but JSPs
  • 13.12.4 Using a Key with a Report Run as a JSP

14 Using the Oracle Reports Web Service

• 14.1 Overview
• 14.2 Getting Started
• • 14.2.1 Invoking the RWWebService Servlet
  • 14.2.2 Viewing the WSDL
• 14.3 Oracle Reports Web Service Operations
• • 14.3.1 getAPIVersion
  • 14.3.2 getServerInfo
  • 14.3.3 getJobInfo
  • 14.3.4 killJob
  • 14.3.5 runJob
• 14.4 Installing and Using the Sample Proxy and Java Client

15 Creating Advanced Distributions

• 15.1 Distribution Overview
• 15.2 Introduction to Distribution XML Files
• • 15.2.1 The distribution.dtd File
  • 15.2.2 Using Variables Within Attributes
• 15.3 Elements of a Distribution XML File
• • 15.3.1 destinations
  • 15.3.2 foreach
  • 15.3.3 mail
  • 15.3.4 body
  • 15.3.5 attach
  • 15.3.6 include
  • 15.3.7 file
  • 15.3.8 printer
  • 15.3.9 destype
  • 15.3.10 property
• 15.4 Distribution XML File Examples
• • 15.4.1 foreach Examples
  • • 15.4.1.1 Single E-Mail with Report Groups as Separate Attachments
    • 15.4.1.2 Separate E-Mail for Each Group Instance
    • 15.4.1.3 Separate E-Mails with Separate Sections as Attachments
    • 15.4.1.4 Separate File for Each Section
    • 15.4.1.5 Separate Print Run for Each Report
  • 15.4.2 mail Examples
  • • 15.4.2.1 E-Mail with a Whole Report as the Body
    • 15.4.2.2 E-Mail with a Section of a Report as the Body
    • 15.4.2.3 E-Mail with Two Report Sections as the Body
    • 15.4.2.4 E-Mail with External File as Body and Report as Attachment
    • 15.4.2.5 E-Mail with Whole Report and Grouped Sections Attached
    • 15.4.2.6 E-Mail to Relevant Manager and Department
  • 15.4.3 file Examples
  • • 15.4.3.1 File for Whole Report
    • 15.4.3.2 File for Combined Report Sections
    • 15.4.3.3 File for Each Group of Combined Sections
    • 15.4.3.4 File for Each Report Group Instance
  • 15.4.4 printer Examples
  • • 15.4.4.1 Print Whole Report
    • 15.4.4.2 Print Two Sections of a Report
    • 15.4.4.3 Print Grouped Report
    • 15.4.4.4 Print Combined Sections for Each Group Instance
    • 15.4.4.5 Print Relevant Instance of a Report to Its Relevant Printer
  • 15.4.5 destype Examples
  • • 15.4.5.1 OracleAS Portal Destination
    • 15.4.5.2 FTP Destination
    • 15.4.5.3 WebDAV Destination
    • 15.4.5.4 Fax Destination
• 15.5 Using a Distribution XML File at Runtime
• 15.6 Limitations with Using Distribution
• • 15.6.1 OracleAS Portal Destination
  • 15.6.2 XML Output
  • 15.6.3 Delimited and DelimitedData Output
  • 15.6.4 Spreadsheet Output
  • 15.6.5 Dynamic Format Values

16 Customizing Reports with XML

• 16.1 Customization Overview
• 16.2 Creating XML Customizations
• • 16.2.1 Required XML Tags
  • 16.2.2 Changing Styles
  • 16.2.3 Changing a Format Mask
  • 16.2.4 Adding Formatting Exceptions
  • 16.2.5 Adding Program Units and Hyperlinks
  • 16.2.6 Adding a New Query and Using the Result in a New Header Section
  • 16.2.7 Encoding the URL
• 16.3 Creating XML Data Models
• • 16.3.1 Creating Multiple Data Sources
  • 16.3.2 Linking Between Data Sources
  • 16.3.3 Creating Group Hierarchies Within Each Data Source
  • 16.3.4 Creating Cross-Product (Matrix) Groups
  • 16.3.5 Creating Formulas, Summaries, and Placeholders at Any Level
  • 16.3.6 Creating Parameters
• 16.4 Using XML Files at Runtime
• • 16.4.1 Applying an XML Report Definition at Runtime
  • • 16.4.1.1 Applying One XML Report Definition
    • 16.4.1.2 Applying Multiple XML Report Definitions
    • 16.4.1.3 Applying an XML Report Definition in PL/SQL
  • 16.4.2 Running an XML Report Definition by Itself
  • 16.4.3 Performing Batch Modifications
• 16.5 Debugging XML Report Definitions
• • 16.5.1 XML Parser Error Messages
  • 16.5.2 Tracing Options
  • 16.5.3 rwbuilder
  • 16.5.4 Writing XML to a File for Debugging

17 Using Event-Driven Publishing

• 17.1 The Event-Driven Publishing API
• • 17.1.1 Elements of the API
  • 17.1.2 Creating and Manipulating a Parameter List
  • • 17.1.2.1 Add_Parameter
    • 17.1.2.2 Remove_Parameter
    • 17.1.2.3 Clear_Parameter_List
  • 17.1.3 Including non-ASCII Characters in Parameter Names and Values
  • 17.1.4 Submitting a Job
  • 17.1.5 Checking for Status
  • 17.1.6 Using the Servers' Status Record
• 17.2 Debugging Applications that Use the Event-Driven Publishing API
• 17.3 Invoking a Report from a Database Event
• 17.4 Integrating with Oracle Advanced Queuing
• • 17.4.1 Creating a Queue That Holds Messages of Type SRW_PARAMLIST
  • 17.4.2 Creating the Enqueuing Procedure
  • 17.4.3 Creating the Dequeuing Procedure

Part III Globalization Support and Bidirectional Support

18 Implementing Globalization and Bidirectional Support

• 18.1 Globalization Support Architecture
• • 18.1.1 Language-Independent Functions
  • 18.1.2 Language-Dependent Data
• 18.2 Globalization Support Environment Variables
• • 18.2.1 NLS_LANG Environment Variable
  • • 18.2.1.1 Defining the NLS_LANG Environment Variable
    • 18.2.1.2 Character Sets
    • 18.2.1.3 Language and Territory
  • 18.2.2 DEVELOPER_NLS_LANG and USER_NLS_LANG Environment Variables
• 18.3 Specifying a Character Set in a JSP or XML File
• 18.4 Bidirectional Support
• 18.5 Unicode
• • 18.5.1 Unicode Support
  • 18.5.2 Unicode Font Support
  • 18.5.3 Enabling Unicode Support
• 18.6 Translating Applications
• 18.7 Troubleshooting Globalization Issues

Part IV Performance

19 Managing and Monitoring OracleAS Reports Services

• 19.1 Configuring the Reports Server for Oracle Enterprise Manager 10g
• 19.2 Navigating to the Reports Server Home Page
• • 19.2.1 Navigating to the Reports Server Home Page in the Application Server Control
  • 19.2.2 Navigating to the Reports Server Home Page in the Grid Control
• 19.3 Managing and Monitoring Reports Servers

20 Tuning Oracle Reports

• 20.1 Performance Analysis Tools
• • 20.1.1 Oracle Enterprise Manager
  • 20.1.2 Report Trace
  • 20.1.3 RW_SERVER_JOB_QUEUE Table
  • • 20.1.3.1 Updating the Database with Queue Activity
  • 20.1.4 SHOWJOBS Command Line Keyword
  • 20.1.5 Efficient SQL
  • 20.1.6 PL/SQL
  • 20.1.7 Java Stored Procedures
  • 20.1.8 The Java Importer
• 20.2 Tuning Reports Server Configuration
• 20.3 Using rwdiag for Bridge and Network Timeout Settings
• 20.4 Accessing the Data
• • 20.4.1 Non-SQL Data Sources
  • 20.4.2 Database Indexes
  • 20.4.3 Calculations
  • 20.4.4 Redundant Data
  • 20.4.5 Break Groups
  • 20.4.6 Group Filters
  • 20.4.7 To Link or Not To Link
• 20.5 Formatting the Data
• • 20.5.1 Paper Layout
  • • 20.5.1.1 Format Triggers
    • 20.5.1.2 Image Outputs
  • 20.5.2 Web Layout and JSP Report Definition
• 20.6 General Layout Guidelines
• • 20.6.1 Fetching Ahead
  • 20.6.2 Bursting and Distribution
• 20.7 Calling Oracle Reports from Forms
• 20.8 Running the Report

Part V Appendixes

A Command Line Keywords

• A.1 Using the Command Line
• • A.1.1 General Usage Notes
  • A.1.2 Rules
• A.2 Oracle Reports Executables Overview
• • A.2.1 Keyword Usage Summary
  • A.2.2 rwclient
  • A.2.3 rwrun
  • A.2.4 rwbuilder
  • A.2.5 rwconverter
  • A.2.6 rwservlet
  • A.2.7 rwcgi
  • A.2.8 rwserver
  • A.2.9 rwbridge
• A.3 Command Line Keywords
• • A.3.1 ACCESSIBLE
  • A.3.2 ARRAYSIZE
  • A.3.3 AUTHID
  • A.3.4 AUTOCOMMIT
  • A.3.5 BACKGROUND
  • A.3.6 BATCH
  • A.3.7 BCC
  • A.3.8 BLANKPAGES
  • A.3.9 BUFFERS
  • A.3.10 CACHELOB
  • A.3.11 CC
  • A.3.12 CELLWRAPPER
  • A.3.13 CMDFILE
  • A.3.14 CMDKEY
  • A.3.15 COLLATE
  • A.3.16 CONTAINSHTMLTAGS
  • A.3.17 CONTAINSOLE
  • A.3.18 CONTENTAREA
  • A.3.19 COPIES
  • A.3.20 CUSTOMIZE
  • A.3.21 DATEFORMATMASK
  • A.3.22 DELAUTH
  • A.3.23 DELIMITED_HDR
  • A.3.24 DELIMITER
  • A.3.25 DESFORMAT
  • A.3.26 DESNAME
  • A.3.27 DEST
  • A.3.28 DESTINATION
  • A.3.29 DESTYPE
  • A.3.30 DISTRIBUTE
  • A.3.31 DTYPE
  • A.3.32 DUNIT
  • A.3.33 ENGINERESPONSETIMEOUT
  • A.3.34 ENVID
  • A.3.35 EXPIRATION
  • A.3.36 EXPIREDAYS
  • A.3.37 EXPRESS_SERVER
  • A.3.38 FORMSIZE
  • A.3.39 FROM
  • A.3.40 GETJOBID
  • A.3.41 GETSERVERINFO
  • A.3.42 HELP
  • A.3.43 ITEMTITLE
  • A.3.44 JOBNAME
  • A.3.45 JOBTYPE
  • A.3.46 JVMOPTIONS
  • A.3.47 KILLENGINE
  • A.3.48 KILLJOBID
  • A.3.49 LONGCHUNK
  • A.3.50 MIMETYPE
  • A.3.51 MODE
  • A.3.52 MODULE|REPORT
  • A.3.53 NAME
  • A.3.54 NONBLOCKSQL
  • A.3.55 NOTIFYFAILURE
  • A.3.56 NOTIFYSUCCESS
  • A.3.57 NUMBERFORMATMASK
  • A.3.58 OLAP_CON
  • A.3.59 ONFAILURE
  • A.3.60 ONSUCCESS
  • A.3.61 ORIENTATION
  • A.3.62 OUTPUTFOLDER
  • A.3.63 OUTPUTIMAGEFORMAT
  • A.3.64 OUTPUTPAGE
  • A.3.65 OVERWRITE
  • A.3.66 P_AVAILABILITY
  • A.3.67 P_DESCRIPTION
  • A.3.68 P_FORMATS
  • A.3.69 P_JDBCPDS
  • A.3.70 P_NAME
  • A.3.71 P_OWNER
  • A.3.72 P_PFORMTEMPLATE
  • A.3.73 P_PRINTERS
  • A.3.74 P_PRIVILEGE
  • A.3.75 P_SERVERS
  • A.3.76 P_TRIGGER
  • A.3.77 P_TYPES
  • A.3.78 PAGEGROUP
  • A.3.79 PAGESIZE
  • A.3.80 PAGESTREAM
  • A.3.81 PARAMFORM
  • A.3.82 PARSEQUERY
  • A.3.83 PDFCOMP
  • A.3.84 PDFEMBED
  • A.3.85 PFACTION
  • A.3.86 PRINTJOB
  • A.3.87 READONLY
  • A.3.88 RECURSIVE_LOAD
  • A.3.89 REPLYTO
  • A.3.90 REPORT|MODULE
  • A.3.91 ROLE
  • A.3.92 RUNDEBUG
  • A.3.93 SAVE_RDF
  • A.3.94 SCHEDULE
  • A.3.95 SERVER
  • A.3.96 SHOWAUTH
  • A.3.97 SHOWENV
  • A.3.98 SHOWJOBID
  • A.3.99 SHOWJOBS
  • A.3.100 SHOWMAP
  • A.3.101 SHOWMYJOBS
  • A.3.102 SHUTDOWN
  • A.3.103 SITENAME
  • A.3.104 SOURCE
  • A.3.105 SQLTRACE
  • A.3.106 SSOCONN
  • A.3.107 STATUSFOLDER
  • A.3.108 STATUSFORMAT
  • A.3.109 STATUSPAGE
  • A.3.110 STYPE
  • A.3.111 SUBJECT
  • A.3.112 SUPPRESSLAYOUT
  • A.3.113 TOLERANCE
  • A.3.114 TRACEFILE
  • A.3.115 TRACEMODE
  • A.3.116 TRACEOPTS
  • A.3.117 UPGRADE_PLSQL
  • A.3.118 URLPARAMETER
  • A.3.119 USEJVM
  • A.3.120 USERID
  • A.3.121 USERSTYLES
  • A.3.122 VALIDATETAG
  • A.3.123 WEBSERVER_DEBUG
  • A.3.124 WEBSERVER_DOCROOT
  • A.3.125 WEBSERVER_PORT

B Environment Variables

• B.1 Environment Variables
• • B.1.1 CA_GPREFS
  • B.1.2 CA_UPREFS
  • B.1.3 DELIMITED_LINE_END
  • B.1.4 DOC
  • B.1.5 DEVELOPER_NLS_LANG
  • B.1.6 NLS_CALENDAR
  • B.1.7 NLS_CREDIT
  • B.1.8 NLS_CURRENCY
  • B.1.9 NLS_DATE_FORMAT
  • B.1.10 NLS_DATE_LANGUAGE
  • B.1.11 NLS_DEBIT
  • B.1.12 NLS_ISO_CURRENCY
  • B.1.13 NLS_LANG
  • B.1.14 NLS_LIST_SEPARATOR
  • B.1.15 NLS_MONETARY_CHARACTERS
  • B.1.16 NLS_NUMERIC_CHARACTERS
  • B.1.17 NLS_SORT
  • B.1.18 ORACLE_AFM
  • B.1.19 ORACLE_HOME
  • B.1.20 ORACLE_HPD
  • B.1.21 ORACLE_PATH
  • B.1.22 ORACLE_PPD
  • B.1.23 ORACLE_TFM
  • B.1.24 ORAINFONAV_DOCPATH
  • B.1.25 PRINTER
  • B.1.26 REMOTE
  • B.1.27 REPORTS_ADD_HWMARGIN
  • B.1.28 REPORTS_ARABIC_NUMERAL
  • B.1.29 REPORTS_BIDI_ALGORITHM
  • B.1.30 REPORTS_CGIDIAGBODYTAGS
  • B.1.31 REPORTS_CGIDIAGHEADTAGS
  • B.1.32 REPORTS_CGIHELP
  • B.1.33 REPORTS_CGIMAP
  • B.1.34 REPORTS_CGINODIAG
  • B.1.35 REPORTS_CLASSPATH
  • B.1.36 REPORTS_CONTAINSHTMLTAGS
  • B.1.37 REPORTS_COOKIE_EXPIRE
  • B.1.38 REPORTS_DB_AUTH
  • B.1.39 REPORTS_DEFAULT_DISPLAY
  • B.1.40 REPORTS_DEFAULT_PIXEL_SIZE
  • B.1.41 REPORTS_ENABLE_RTF_SPACING
  • B.1.42 REPORTS_ENCRYPTION_KEY
  • B.1.43 REPORTS_ENHANCED_SUBSET
  • B.1.44 REPORTS_GRAPH_IMAGE_DPI
  • B.1.45 REPORTS_IGNORE_IMAGE_TAG_RES
  • B.1.46 REPORTS_JPEG_QUALITY_FACTOR
  • B.1.47 REPORTS_JVM_OPTIONS
  • B.1.48 REPORTS_NETWORK_CONFIG
  • B.1.49 REPORTS_NLS_XML_CHARSETS
  • B.1.50 REPORTS_NO_DUMMY_PRINTER
  • B.1.51 REPORTS_NO_HTML_SPACE_REPLACE
  • B.1.52 REPORTS_OUTPUTIMAGEFORMAT
  • B.1.53 REPORTS_PATH
  • B.1.54 REPORTS_RESOURCE
  • B.1.55 REPORTS_SERVER
  • B.1.56 REPORTS_SOLARIS_9
  • B.1.57 REPORTS_SPACE_BREAK
  • B.1.58 REPORTS_SRWRUN_TO_SERVER
  • B.1.59 REPORTS_SSLPORT
  • B.1.60 REPORTS_SYS_AUTH
  • B.1.61 REPORTS_TAGLIB_URI
  • B.1.62 REPORTS_TMP
  • B.1.63 REPORTS_USEREXITS
  • B.1.64 REPORTS_UTF8_XMLOUTPUT
  • B.1.65 RW
  • B.1.66 TK_PRINT
  • B.1.67 TK_PRINT_STATUS
  • B.1.68 TK_PRINTER
  • B.1.69 TK_AFM
  • B.1.70 TK_HPD
  • B.1.71 TK_PPD
  • B.1.72 TK_TFM
  • B.1.73 USERNAME
  • B.1.74 USER_NLS_LANG

C Batch Registering Reports in OracleAS Portal

• C.1 Batch Registering Report Definition Files
• • C.1.1 Run rwconverter to Generate a SQL Script
  • C.1.2 Run the Script in SQL*Plus
• C.2 Batch Removing Report Packages
• C.3 PL/SQL Batch Registering Function

D Troubleshooting OracleAS Reports Services

• D.1 Problems and Solutions
• • D.1.1 Hanging Report Requests
  • D.1.2 Reports Server Activity Generates Error REP-50125
  • D.1.3 Long Running Report Failure with Reports Servlet
  • D.1.4 Fonts Do Not Display Consistently On Different Platforms
  • D.1.5 Running Reports on UNIX Platforms Generates REP-56048
  • D.1.6 In-process Server Fails Using OPMN with Heavy Load
  • D.1.7 Font Issues with Right-to-Left Languages
  • D.1.8 Errors When Running Reports from Oracle Forms Using RUN_REPORT_OBJECT
  • D.1.9 Displaying Report Output in Microsoft Excel
  • D.1.10 Report Containing User Exit Fails on UNIX
  • D.1.11 Printing and Font Errors When Using In-process Server
• D.2 Diagnosing Performance Problems
• D.3 Diagnosing Font Problems
• D.4 Diagnosing Printing Problems
• D.5 Diagnosing JDBC PDS Problems
• D.6 Diagnosing OracleAS Portal Problems
• D.7 Diagnosing Globalization Problems
• D.8 Diagnosing Oracle Reports Bridge Problems
• D.9 Need More Help?

E Reports Server and Bridge Diagnostic Utility

• E.1 Overview of rwdiag
• • E.1.1 Examples
  • • E.1.1.1 Example 1
    • E.1.1.2 Example 2
    • E.1.1.3 Example 3
    • E.1.1.4 Example 4
    • E.1.1.5 Example 5
    • E.1.1.6 Example 6
• E.2 Command Line Syntax
• • E.2.1 Syntax
  • E.2.2 Usage Notes

Glossary

Index