Oracle Reports Services Publishing Reports to the Web with Oracle9<i>i</i> Application Server -- Contents

Variables

3.6.1.1 Setting the Environment Variables (Optional)

3.6.1.2 Starting the Oracle Reports Services Server

3.6.2 Configuring the Oracle Reports Services Server on UNIX with Environment

Variables

3.6.2.1 Setting the Environment Variables (Optional)

3.6.2.2 Starting the Oracle Reports Services 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 Services Server Configuration (Optional)

3.9.1 Updating the Database with Job Queue Activity

3.9.1.1 On the Oracle Reports Services 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 Oracle Reports Services Security with Oracle Portal

5.1 Overview

5.1.1 Creating a Security DLL for Oracle Reports Services 6i Security in a Windows

Environment

5.1.2 Creating a Security Library for Oracle Reports Services 6i Security in a UNIX

Environment

5.2 Database-Level Security

5.3 Application-Level Security

5.4 Integration with Oracle Portal

5.4.1 Sharing Authentication Information Between Oracle Portal and Oracle Reports Services Servers

5.5 Oracle Portal Integration Architecture

5.6 Installing Oracle Reports Services Security in Oracle Portal

5.6.1 Step 1: Installing Oracle Portal Into an Oracle Database

5.6.2 Step 2: Installing Oracle Reports Services

5.7 Configuring the Security Environment

5.7.1 Step 1: Enabling Oracle Reports Services Security within Oracle Portal

5.7.1.1 RW_ADMINISTRATOR

5.7.1.2 RW_DEVELOPER

5.7.1.3 RW_POWER_USER

5.7.1.4 RW_BASIC_USER

5.7.2 Step 2: Adding SECURITYTNSNAMES and PORTALUSERID Parameters

5.7.3 Step 3: Starting Oracle Portal

5.8 Printer Access

5.9 Creation of an Oracle Portal Content Area

5.10 Setting Up and Deploying a Report

5.11 Creating and Enabling an Oracle Portal User to Administer Security

5.11.1 Creating and Enabling User REPORTSDEV to Administer Security

5.12 Setting Up Access Controls in Oracle Portal

5.13 Registering a Report

5.13.1 Registering a Server

5.13.2 Creating Report Definition File Access

5.14 Deploying a Report

5.14.1 Deploying a Report to an Oracle Portal Content Area

5.15 Running a Report

5.16 Publishing Report Outside of Oracle Portal

6 Configuring Oracle Reports Services Server Clusters

6.1 Clustering Overview

6.2 Configuring Oracle Reports Services 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

Part II Appendixes

A Controlling User Access to Reports by Defining Calendars

A.1 Creating Availability Calendars

A.2 Availability Calendar Example

A.2.1 Creating a Daily Calendar

A.2.2 Creating the Maintenance Calendar

A.2.3 Creating the Christmas Calendar

A.2.4 Creating a Combined Availability Calendar

B RWCLI60 Command Line Arguments

B.1 Syntax

B.2 Usage Notes

C Oracle Reports Services Configuration Parameters

D Environment Variables

E Database Connection Strings

F Migrating from Web Cartridge to CGI

F.1 Benefits of Migrating to CGI

F.2 Steps for Migrating to CGI

F.2.1 Step 1. Installing the Software

F.2.2 Step 2. Configuring OAS

F.2.3 Step 3. Configuring the CGI

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

F.2.4.1 Windows NT

F.2.4.2 UNIX

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

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

F.2.7 Updating the Report Links on Your Web Page

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Part I Publishing Reports

1 Publishing Architecture and Concepts

2 Installing Oracle9i Application Server with Oracle Reports Services

3 Configuring the Oracle Reports Services Server on Windows NT and UNIX

4 Running Report Requests

5 Oracle Reports Services Security with Oracle Portal

6 Configuring Oracle Reports Services Server Clusters

7 Customizing Reports at Runtime

Part II Appendixes

A Controlling User Access to Reports by Defining Calendars

B RWCLI60 Command Line Arguments

C Oracle Reports Services Configuration Parameters

D Environment Variables

E Database Connection Strings

F Migrating from Web Cartridge to CGI

G Troubleshooting

Glossary

Index