Oracle Reports Publishing Reports
Release 6i

A73173-01

Index

Next

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Reports Server new features
Intended Audience
Structure
Related Documents
Notational conventions

Part I Publishing Reports

1 Introduction

1.1 The Oracle Reports Server
1.1.1 Oracle Developer Server

2 Publishing Architecture and Concepts

2.1 The Oracle Reports Server
2.2 Reports Server 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 Reports Server configuration choices
2.3.1 Enable Web and non-Web requests
2.3.2 Choose the Reports Web CGI or Servlet
2.3.3 Choose the location of the Reports Server

3 Configuring the Reports Server

3.1 Installation and Configuration overview
3.1.1 Configuring the Report Server automatically using the Smart Server Install
3.1.2 Configuring the Reports Server manually
3.2 Configuring the Reports Server: Reports Web CGI example
3.2.1 Step 1. Install the software
3.2.2 Step 2. Configure the Web server
3.2.3 Step 3. Configure the Reports Web CGI
3.2.3.1 To configure Reports Web CGI
3.2.3.2 To create a service entry for the Reports Server
3.2.3.3 (Optional) To set the default Reports Server
3.2.4 Step 4. Configure the Reports Server
3.2.4.1 To configure the Reports Server in Windows NT
3.2.4.1.1 (Optional) To set the source path
3.2.4.1.2 Start the Reports Server
3.2.4.2 To configure the Reports Server on UNIX
3.2.4.2.1 (Optional) Set enviornment variables
3.2.4.2.2 Start the Reports Server
3.2.5 Step 5. Run a report request from a Web browser
3.2.6 Step 6. (Optional) Modify the Reports Server configuration
3.2.6.1 To update the database with job queue activity
3.3 Starting or stopping the Reports Server from the command line
3.3.1 Start another Reports Server
3.3.1.1 To create a service entry for the Reports Server
3.3.1.2 To configure the Reports Server on Windows NT
3.3.1.2.1 (Optional) Set the source path
3.3.1.2.2 Start the Reports Server
3.3.1.3 To configure the Reports Server on UNIX
3.3.1.3.1 (Optional) Set environment variables
3.3.1.3.2 Start the Reports Server
3.3.2 Start the Reports Server on Windows NT as a non-service
3.3.3 Stop the Reports Server
3.4 Reports Servlet configuration guidelines
3.4.1 Configuring the Web server

4 Running Report Requests

4.1 Report request methods
4.2 Duplicate job detection
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.2 Installing and Configuring Reports Security in WebDB
5.2.1 Step 1. Configure Reports Security in WebDB
5.2.1.1 To install WebDB
5.2.1.2 To install the Reports Server security packages in WebDB
5.2.1.3 To set the authentication cookie domain
5.3 Setting up access controls in WebDB
5.3.1 Step 1. Configure the Reports Server for access control
5.3.1.1 To create the TNS names alias that connects to WebDB
5.3.1.2 To restrict access to the Reports Server
5.3.2 Step 2. Create user accounts
5.3.2.1 To create the Oracle Reports system administrator user account
5.3.2.2 To create users accounts for running reports
5.3.3 Step 3. Create availability calendars
5.3.3.1 To create the daily calendar
5.3.3.2 To create the maintenance calendar
5.3.3.3 To create the Christmas calendar
5.3.3.4 To create a combined Availability calendar
5.3.4 Step 4. Add access to an Oracle Reports printer in WebDB
5.3.5 Step 5. Add access to the Reports Server in WebDB
5.3.6 Step 6. Add access to the report definition file in WebDB
5.3.6.1 To create a list of values for the Lastname user parameter
5.3.6.2 To add access the report definition file
5.3.7 Step 7. Set parameter values on the Oracle Reports Parameter Form
5.3.7.1 To run the report output to cache
5.3.7.2 (optional) To run the report output to a restricted printer
5.3.7.3 To set the default parameters for users at runtime
5.3.8 Step 8. Make the report available to users
5.3.8.1 To create a WebDB site
5.3.8.2 To create a folder in the WebDB site
5.3.8.3 To add the report request to the folder
5.3.8.4 To run this report as a user
5.3.9 Step 9. Schedule the report to run and push the output to a WebDB site
5.3.9.1 To create a personal folder
5.3.9.2 To schedule the report
5.3.9.3 To view the pushed report output
5.3.10 Summary

6 Configuring Reports Server clusters

6.1 Clustering overview
6.2 Configuring 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 How to create and use 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 Appendices

A RWCLI60 Command Line Arguments

B Reports Server Configuration Parameters

C Environment Variables

D Database Connection Strings

E Reports Web Cartridge

E.1 Reports Web Cartridge example
E.1.1 Step 1. Install the software
E.1.2 Step 2. Configure your Web server
E.1.3 Step 3. Configure the Reports Web Cartridge
E.1.3.1 To create a service entry for the Reports Server
E.1.3.2 To set the default Reports Server
E.1.3.3 To configure the Reports Web Cartridge (on Windows NT and UNIX)
E.1.4 Step 4. Configure the Reports Server
E.1.4.1 To configure the Reports Server on Windows NT
E.1.4.1.1 (Optional) Set the source path
E.1.4.2 To configure the Reports Server on Windows NT
E.1.4.2.1 (Optional) Set the source path
E.1.4.2.2 Install the Reports Server on Windows NT as a service
E.1.4.2.3 Configure the Reports Server on Windows NT as a non-service
E.1.4.2.4 Uninstall the Reports Server on Windows NT
E.1.4.3 To configure the Reports Server on UNIX
E.1.4.3.1 (Optional) Set enviornment variables
E.1.4.3.2 Starting the Reports Server
E.1.5 Step 5. Run a report request
E.1.6 Step 6. (Optional) Modify the configuration
E.1.6.1 To update the database with job queue activity
E.2 Environment variables

F Troubleshooting

Glossary

Index


Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Index