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