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 Introduction

1.1 Oracle Internet Application Server Overview

1.2 Oracle Reports Services

2 Publishing Architecture and Concepts

2.1 Oracle Reports Services

2.2 Oracle Reports Services Architecture

2.2.1 Web Architecture: Server Configurations

2.2.1.1 Processing Web Reports

2.2.2 Non-Web Architecture: Server Configuration

2.2.2.1 Processing Reports

2.3 Oracle Reports Services Configuration Choices

2.3.1 Enable Web and Non-Web Requests

2.3.2 Choose the Oracle Reports Services Web CGI or Servlet

2.3.3 Choose the Location of Oracle Reports Services

3 Installing Oracle Internet Application Server Oracle on the Sun SPARC Solaris

3.1 About the Oracle Universal Installer

3.2 About the Oracle HTTP Server

4 Configuring Oracle Reports Services on Sun SPARC Solaris

4.1 Starting Oracle Reports Services

4.2 Configuring the Reports Servlet

4.2.1 Configuring the Oracle HTTP Server to Run the Reports Services Servlet with

JSDK

4.2.2 Configuring the Oracle HTTP Server to Run Reports Services Servlet with

JServ

4.3 Configuring Oracle HTTP Server Listener to Run Reports Services CGI

4.4 Stopping Oracle Reports Services

4.5 Environment Variables

5 Running Report Requests

5.1 Report Request Methods

5.2 Duplicate Job Detection

5.2.1 Usage Notes

5.3 Using a Key Map File

5.3.1 Enabling Key Mapping

5.3.2 Mapping URL Parameters

5.4 Specifying Report Requests

5.4.1 Building a Report

5.4.2 Specifying a Report Request from a Web Browser

5.4.3 Scheduling Reports to Run Automatically

6 Controlling User Access to Reports

6.1 Access Control Configuration and Setup Overview

6.1.1 Installing and Configuring Reports Services Security

6.1.2 Setting up Access Control

6.2 Installing and Configuring Reports Security in WebDB

6.2.1 Step 1. Configuring Reports Security in WebDB

6.2.1.1 Installing WebDB

6.2.1.2 Installing Oracle Reports Services Security Packages in WebDB

6.2.1.3 Setting the Authentication Cookie Domain

6.3 Setting Up Access Controls in WebDB

6.3.1 Step 1. Configuring Oracle Reports Services for Access Control

6.3.1.1 Creating the TNS Names Alias that Connects to WebDB

6.3.1.2 Restricting Access to Oracle Reports Services

6.3.2 Step 2. Creating User Accounts

6.3.2.1 Creating the Reports Services System Administrator User Account

6.3.2.2 Creating Users Accounts for Running Reports

6.3.3 Step 3. Creating Availability Calendars

6.3.3.1 Creating the Daily Calendar

6.3.3.2 Creating the Maintenance Calendar

6.3.3.3 Creating the Christmas Calendar

6.3.3.4 Creating a Combined Availability Calendar

6.3.4 Step 4. Adding Access to a Reports Services Printer in WebDB

6.3.5 Step 5. Adding Access to Oracle Reports Services in WebDB

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

6.3.6.1 Creating a List of Values for the Lastname User Parameter

6.3.6.2 Adding Access the Report Definition File

6.3.7 Step 7. Setting Parameter Values on the Reports Services Parameter Form

6.3.7.1 Running the Report Output to Cache

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

6.3.7.3 Setting the Default Parameters for Users at Runtime

6.3.8 Step 8. Making the Report Available to Users

6.3.8.1 Creating a WebDB Site

6.3.8.2 Creating a Folder in the WebDB Site

6.3.8.3 Adding the Report Request to the Folder

6.3.8.4 Running the Report as a User

6.3.9 Step 9. Scheduling the Report to Run and Push the Output to a WebDB Site

6.3.9.1 Creating a Personal Folder

6.3.9.2 Scheduling the Report

6.3.9.3 Viewing the Pushed Report Output

6.3.9.4 Optional Exercise

6.4 Summary

7 Configuring Oracle Reports Services Clusters

7.1 Clustering Overview

7.2 Configuring Oracle Reports Services in a Cluster Example

7.2.1 Enabling Communication Between Master and Slaves

7.2.2 Configuring the Master Server

7.2.3 Running Reports in a Clustered Configuration

7.2.4 Resubmitting Jobs When an Engine Goes Down

7.2.5 Adding Another Slave Server to the Master

8 Customizing Reports at Runtime

8.1 Overview

8.1.1 Creating and Using XML Report Definitions

8.2 Creating an XML Report Definition

8.2.1 Required Tags

8.2.2 Partial Report Definitions

8.2.2.1 Formatting Modifications Example

8.2.2.2 Formatting Exception Example

8.2.2.3 Program Unit and Hyperlink Example

8.2.2.4 Data Model and Formatting Modifications Example

8.2.3 Full Report Definitions

8.3 Running XML Report Definitions

8.3.1 Applying an XML Report Definition at Runtime

8.3.1.1 Applying one XML Report Definition

8.3.1.2 Applying Multiple XML Report Definitions

8.3.1.3 Applying an XML Report Definition in PL/SQL

8.3.1.3.1 Applying an XML Definition Stored in a File

8.3.1.3.2 Applying an XML Definition Stored in Memory

8.3.2 Running an XML Report Definition by Itself

8.3.3 Performing Batch Modifications

8.4 Debugging XML Report Definitions

8.4.1 XML Parser Error Messages

8.4.2 Tracing Options

8.4.3 RWBLD60

8.4.4 TEXT_IO

8.5 XML Tag Reference

8.5.1 <!-- comments -->

8.5.2 <![CDATA[ ]]>

8.5.3 <condition>

8.5.4 <customize>

8.5.5 <data>

8.5.6 <dataSource>

8.5.7 <exception>

8.5.8 <field>

8.5.9 <formLike>

8.5.10 <formula>

8.5.11 <function>

8.5.12 <group>

8.5.13 <groupAbove>

8.5.14 <groupLeft>

8.5.15 <labelAttribute>

8.5.16 <layout>

8.5.17 <link>

8.5.18 <matrix>

8.5.19 <matrixCell>

8.5.20 <matrixCol>

8.5.21 <matrixRow>

8.5.22 <object>

8.5.23 <programUnits>

8.5.24 <properties>

8.5.25 <property>

8.5.26 <report>

8.5.27 <section>

8.5.28 <select>

8.5.29 <summary>

8.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 Troubleshooting

Glossary

Index