Contents

Title and Copyright Information

Send Us Your Comments

Preface

Oracle Reports Services New Features

Intended Audience

Structure

Related Documents

Notational Conventions

Part I Publishing Reports

1 Publishing Architecture and Concepts

1.1 Oracle Reports Services

1.2 Oracle Reports Services Architecture

1.2.1 Web Architecture: Server Configurations

1.2.1.1 Processing Web Reports

1.2.2 Non-Web Architecture: Server Configuration

1.2.2.1 Processing Reports

1.3 Oracle Reports Services Configuration Choices

1.3.1 Enable Web and Non-Web Requests

1.3.2 Choose the Oracle Reports Server CGI or Servlet

1.3.3 Choose the Location of Oracle Reports Services

2 Installing Oracle9i Application Server with Oracle Reports Services

2.1 About the Oracle Universal Installer

2.2 About the Oracle HTTP Server powered by Apache

3 Configuring the Oracle Reports Server on Windows NT and UNIX

3.1 Starting and Stopping the Oracle Reports Server

3.1.1 Starting the Oracle Reports Server

3.1.1.1 Starting the Oracle Reports Server on Windows NT

3.1.1.2 Starting the Oracle Reports Server on UNIX

3.1.2 Starting the Oracle Reports Server on Windows NT as a Non-Service

3.2 Stopping the Oracle Reports Server

3.2.1 Stopping or Deinstalling the Oracle Reports Server on Windows NT

3.2.2 Stopping the Oracle Reports Server on UNIX

3.3 Configuring the Oracle Reports Server Servlet

3.3.1 Configuring the Oracle Reports Server Servlet with JSDK

3.3.2 Configuring the Oracle Reports Server Servlet with JServ

3.4 Configuring the Oracle HTTP Server powered by Apache Listener

3.5 Configuring the Web Server

3.5.1 Configuring the Oracle Reports Server CGI

3.5.1.1 Configuring the Oracle Reports Server CGI

3.5.1.2 Creating a Service Entry for the Oracle Reports Server

3.5.1.3 Setting the Default Oracle Reports Server (Optional)

3.5.1.3.1 Windows NT

3.5.1.3.2 UNIX

3.6 Configuring the Oracle Reports Server with Environment Variables

3.6.1 Configuring the Oracle Reports Server in Windows NT with Environment

Variables

3.6.1.1 Setting the Environment Variables (Optional)

3.6.1.2 Starting the Oracle Reports Server

3.6.2 Configuring the Oracle Reports Server on UNIX with Environment Variables

3.6.2.1 Setting the Environment Variables (Optional)

3.6.2.2 Starting the Oracle Reports Server on UNIX

3.7 Environment Variables

3.8 Running a Report Request from a Web Browser

3.8.1 Other Steps

3.9 Modifying the Oracle Reports Server Configuration (Optional)

3.9.1 Updating the Database with Job Queue Activity

3.9.1.1 On the Oracle Reports Server Machine

4 Running Report Requests

4.1 Report Request Methods

4.2 Duplicate Job Detection

4.2.1 Usage Notes

4.3 Using a Key Map File

4.3.1 Enabling Key Mapping

4.3.2 Mapping URL Parameters

4.4 Specifying Report Requests

4.4.1 Building a Report

4.4.2 Specifying a Report Request from a Web Browser

4.4.3 Scheduling Reports to Run Automatically

5 Controlling User Access to Reports

5.1 Access Control Configuration and Setup Overview

5.1.1 Setting up Access Control

5.1.2 Installing and Configuring Oracle Reports Services Security in Oracle WebDB

5.1.2.1 Step 1. Configuring Oracle Reports Services Security in Oracle WebDB

5.1.2.1.1 Installing Oracle WebDB

5.1.2.1.2 Installing Oracle Reports Services Security Packages in Oracle WebDB

5.1.2.1.3 Setting the Authentication Cookie Domain

5.1.3 Setting Up Access Controls in Oracle WebDB Example

5.1.3.1 Step 1. Configuring Oracle Reports Services for Access Control

5.1.3.1.1 Creating the TNSnames Alias that Connects to Oracle WebDB

5.1.3.1.2 Restricting Access to Oracle Reports Servers

5.1.3.2 Step 2. Creating User Accounts

5.1.3.2.1 Creating the Oracle Reports Services System Administrator User

Account

5.1.3.3 Step 3. Creating Availability Calendars

5.1.3.3.1 Creating the Daily Calendar

5.1.3.3.2 Creating the Maintenance Calendar

5.1.3.3.3 Creating the Christmas Calendar

5.1.3.3.4 Creating a Combined Availability Calendar

5.1.3.4 Step 4. Adding Access to a Oracle Reports Services Printer in Oracle

WebDB

5.1.3.5 Step 5. Adding Access to Oracle Reports Servers in Oracle WebDB

5.1.3.6 Step 6. Adding Access to the Report Definition File in Oracle WebDB

5.1.3.6.1 Creating a List of Values for the Lastname User Parameter

5.1.3.6.2 Adding Access the Report Definition File

5.1.3.7 Step 7. Setting Parameter Values on the Oracle Reports Services Parameter

Form

5.1.3.7.1 Running the Report Output to Cache

5.1.3.7.2 Running the Report Output to a Restricted Printer (Optional)

5.1.3.7.3 Setting the Default Parameters for Users at Runtime

5.1.3.8 Step 8. Making the Report Available to Users

5.1.3.8.1 Creating an Oracle WebDB Site

5.1.3.8.2 Creating a Folder in the Oracle WebDB Site

5.1.3.8.3 Adding the Report Request to the Folder

5.1.3.8.4 Running the Report as a User

5.1.3.9 Step 9. Scheduling the Report to Run and Push the Output to an Oracle WebDB

Site

5.1.3.9.1 Creating a Personal Folder

5.1.3.9.2 Scheduling the Report

5.1.3.9.3 Viewing the Pushed Report Output

5.1.3.9.4 Optional Examples

5.2 Summary

6 Configuring Oracle Reports Server Clusters

6.1 Clustering Overview

6.2 Configuring Oracle Reports Servers in a Cluster Example

6.2.1 Enabling Communication Between Master and Slaves

6.2.2 Configuring the Master Server

6.2.3 Running Reports in a Clustered Configuration

6.2.4 Resubmitting Jobs When an Engine Goes Down

6.2.5 Adding Another Slave Server to the Master

7 Customizing Reports at Runtime

7.1 Overview

7.1.1 Creating and Using XML Report Definitions

7.2 Creating an XML Report Definition

7.2.1 Required Tags

7.2.2 Partial Report Definitions

7.2.2.1 Formatting Modifications Example

7.2.2.2 Formatting Exception Example

7.2.2.3 Program Unit and Hyperlink Example

7.2.2.4 Data Model and Formatting Modifications Example

7.2.3 Full Report Definitions

7.3 Running XML Report Definitions

7.3.1 Applying an XML Report Definition at Runtime

7.3.1.1 Applying One XML Report Definition

7.3.1.2 Applying Multiple XML Report Definitions

7.3.1.3 Applying an XML Report Definition in PL/SQL

7.3.1.3.1 Applying an XML Definition Stored in a File

7.3.1.3.2 Applying an XML Definition Stored in Memory

7.3.2 Running an XML Report Definition by Itself

7.3.3 Performing Batch Modifications

7.4 Debugging XML Report Definitions

7.4.1 XML Parser Error Messages

7.4.2 Tracing Options

7.4.3 RWBLD60

7.4.4 TEXT_IO

7.5 XML Tag Reference

7.5.1 <!-- comments -->

7.5.2 <![CDATA[ ]]>

7.5.3 <condition>

7.5.4 <customize>

7.5.5 <data>

7.5.6 <dataSource>

7.5.7 <exception>

7.5.8 <field>

7.5.9 <formLike>

7.5.10 <formula>

7.5.11 <function>

7.5.12 <group>

7.5.13 <groupAbove>

7.5.14 <groupLeft>

7.5.15 <labelAttribute>

7.5.16 <layout>

7.5.17 <link>

7.5.18 <matrix>

7.5.19 <matrixCell>

7.5.20 <matrixCol>

7.5.21 <matrixRow>

7.5.22 <object>

7.5.23 <programUnits>

7.5.24 <properties>

7.5.25 <property>

7.5.26 <report>

7.5.27 <section>

7.5.28 <select>

7.5.29 <summary>

7.5.30 <tabular>

Part II Appendixes

A RWCLI60 Command Line Arguments

A.1 Syntax

A.2 Usage Notes

B Oracle Reports Services Configuration Parameters

C Environment Variables

D Database Connection Strings

E Migrating from Web Cartridge to CGI

E.1 Benefits of Migrating to CGI

E.2 Steps for Migrating to CGI

E.2.1 Step 1. Installing the Software

E.2.2 Step 2. Configuring OAS

E.2.3 Step 3. Configuring the CGI

E.2.4 Step 4. Setting Environment Variables (Optional)

E.2.4.1 Windows NT

E.2.4.2 UNIX

E.2.5 Step 5. Renaming the Map Files (Optional)

E.2.6 Step 6. Running a Report Using the CGI URL

E.2.7 Updating the Report Links on Your Web Page

F Troubleshooting

Glossary

Index