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

XML tag reference, 7-30

<![CDATA[]]> XML tag reference, 7-31

<condition> XML tag reference, 7-32

<customize> XML tag reference, 7-34

<data> XML tag reference, 7-36

<dataSource> XML tag reference, 7-37

<exception> XML tag reference, 7-39

<field> XML tag reference, 7-41

<formLike> XML tag reference, 7-46

<formula> XML tag reference, 7-47

<function> XML tag reference, 7-50

<group> XML tag reference, 7-51

<groupAbove> XML tag reference, 7-53

<groupLeft> XML tag reference, 7-54

<labelAttribute> XML tag reference, 7-56

<layout> XML tag reference, 7-58

<matrix> XML tag reference, 7-64

<matrixCell> XML tag reference, 7-67

<matrixCol> XML tag reference, 7-68

<matrixRow> XML tag reference, 7-69

<programUnits> XML tag reference, 7-72

<properties> XML tag reference, 7-73

<property> XML tag reference, 7-75

<report> XML tag reference, 7-78

<section> XML tag reference, 7-80

<select> XML tag reference, 7-82

<summary> XML tag reference, 7-83

<tabular> XML tag reference, 7-88

access control

availability calendars, A-1

ActiveX request method, 4-2

adding

another slave server to the master, 6-8

Apache, 3-9, 3-10

Apache server See Oracle HTTP Server powered by Apache

applying in XML

multiple report definitions, 7-20

report definition at runtime, 7-19

report definition in PL/SQL, 7-21

report definition stored in a file, 7-21

report definition stored in memory, 7-21

architecture

Oracle Reports Services, 1-2

Oracle Reports Services tier, 1-2

database, 1-2

thin client, 1-2

Web server, 1-2

Web server configurations, 1-3

authentication cookie

expiring, B-29

availability calendar, A-1

batch

modifications to reports, 7-25

reporting

from an Oracle Portal site, 4-9

cache

size, C-1

CACHESIZE parameter, 4-3

CLUSTERCONFIG parameter, 6-2, 6-5

clustering

configuring

master server, 6-5

Oracle Reports Services, 6-3

Oracle Reports Services servers, 6-3

enabling communication between master and slave, 6-4

overview, 6-2

resubmitting, 6-7

running reports, 6-7

combined availability calendar, A-5

command line arguments, B-1

AUTHID, B-29

CURRENCY, 4-3

CUSTOMIZE, 7-3, 7-19, 7-20, 7-25

DECIMAL, 4-3

DESFORMAT, 4-3

DESTYPE, 4-3, B-4

mapping URL parameter, 4-4

MODE, 4-3

ORIENTATION, 4-3

PAGESIZE, 4-3

PARAMFORM, 4-3

REPORT, 4-3, 7-3, 7-19

RWCLI60, 4-6, 4-8, B-1

SCHEDULE, 6-7

SERVER, 3-16, 3-17, 4-2, 4-6, 4-8, 6-7, B-22, D-2, F-5

THOUSANDS, 4-3

TOLERANCE, 4-3

USERID, 4-3, B-2, E-1

commands

line arguments, 1-5

Oracle Reports Services Runtime, 4-2

READONLY, B-9, B-13

RWCLI60, 4-1, 4-2, 7-20, 7-25

RWRUN60, 7-10, 7-21, 7-25, B-3, B-17

SCHEDULE, B-23

setenv, 3-12

SHOWAUTH, B-2, B-29

SRW.RUN.REPORT, 4-2

concepts, 1-1

configuring

master server clustering, 6-5

Oracle Reports Services, 1-7

Oracle Reports Services server

modifying, 3-17

UNIX with environment variables, 3-14

Windows NT with environment variables, 3-12

with environment variables, 3-12

Oracle Reports Services server CGI, 3-8, 3-10

Oracle Reports Services server clustering, 6-1, 6-3

Oracle Reports Services server servlet, 3-4

with JSDK, 3-5

with JServ, 3-7

Web server, 3-9

creating

a service entry for Oracle Reports Services server, 3-11

availability calendar, A-1

combined availability calendar, A-5

daily calendar, A-2

maintenance calendar, A-3

XML

report definition required tags, 7-4

report definitions, 7-2, 7-3

CURRENCY command line argument, 4-3

CUSTOMIZE

command line argument, 7-3

keyword, 7-29

customizing

overview, 7-2

reports at runtime, 7-1

XML report definition, 7-3

daily calendar, A-2

database tier, Oracle Reports Services, 1-2

debugging

tracing options, 7-26

XML report definitions, 7-26

DECIMAL command line argument, 4-3

default printer, set access, 3-3, 3-15

DESFORMAT

command line argument, 4-3

DESTYPE

command line argument, 4-3

directories

ORACLE_HOME/guicommon6/tk60/ADMIN, 3-15

ORACLE_HOMEREPORT60, 4-5

ORACLE_HOMEREPORT60SERVER, 3-14

duplicate job detection

multiple output destinations, 4-3

Oracle Reports Services handling, 4-3, B-23

ENGLIFE parameter, 6-5

environment variables

configuration, 3-15

REPORTS_PATH, 3-14

TNS_ADMIN, 3-14

REPORTS_REPORTS_SERVER, 3-17

REPORTS60_CGIMAP, 4-5

REPORTS60_COOKIE_EXPIRE, 3-15

REPORTS60_DB_AUTH, 3-16

REPORTS60_ENCRYPTION_KEY, 3-16

REPORTS60_PATH, 3-13, 3-14, 4-7

REPORTS60_REPORT_SERVER, F-5

REPORTS60_REPORTS_SERVER, 3-12, 3-16, 4-6, 4-8, 6-7

REPORTS60_SSLPORT, 3-16

REPORTS60_SYS_AUTH, 3-16

TNS_ADMIN, 3-13, 3-14

examples

XML tag reference, 7-30

<![CDATA[]]> XML tag reference, 7-31

<condition> XML tag reference, 7-34

<customize> XML tag reference, 7-35

<data> XML tag reference, 7-36

<dataSource> XML tag reference, 7-38

<exception> XML tag reference, 7-41

<field> XML tag reference, 7-45

<formLike> XML tag reference, 7-49

<formula> XML tag reference, 7-47

<function> XML tag reference, 7-50

<group> XML tag reference, 7-52

<groupAbove> XML tag reference, 7-54

<groupLeft> XML tag reference, 7-55

<labelAttribute> XML tag reference, 7-58

<layout> XML tag reference, 7-59

<matrix> XML tag reference, 7-65

<matrixCell> XML tag reference, 7-67

<matrixCol> XML tag reference, 7-68

<matrixRow> XML tag reference, 7-69

<programUnits> XML tag reference, 7-72

<properties> XML tag reference, 7-74

<property> XML tag reference, 7-77

<report> XML tag reference, 7-78

<section> XML tag reference, 7-81

<select> XML tag reference, 7-82

<summary> XML tag reference, 7-87

<tabular> XML tag reference, 7-88

full URL syntax, 4-8

key mapping, 4-5, 4-6

RWCLI60 command line request, 4-1

simplified URL syntax, 4-8

XML report definitions

additional objects, 7-11

formatting, 7-7

formatting exception, 7-9

full, 7-12

hyperlink, 7-10

PL/SQL, 7-10

files

RDF, 4-7

REP, 4-7

RWRUN60 executable, 4-1

uiprint.txt, 3-15

installing

Oracle9i Application Server, 2-1

starting as a non-service in Windows NT, 3-3

starting Oracle Reports Services server on UNIX, 3-2, 3-13, 3-14, 3-15

key map file

cgicmd.dat CGI, 4-5

enabling, 4-5

example, 4-5, 4-6

mapping entries, 4-6

mapping URL parameters, 4-6

using, 4-4

when to use, 4-4

keywords

CUSTOMIZE, 7-29

REPORT, 7-28

load balancing

resubmitting jobs, 6-7

running reports, 6-7

maintenance calendar, A-3

MAXENGINE parameter, 6-2, 6-3

MAXIDLE parameter, 6-5

migration from Web cartridge to CGI, F-1

MINENGINE parameter, 6-2, 6-3

MODE command line argument, 4-3

OAS (Oracle Application Server), F-1

Oracle Application Server (OAS), F-1

Oracle HTTP Server powered by Apache, 2-2

Oracle Portal

component request method, 4-2

Oracle Reports Services

architecture, 1-2

configuring

for clustering, 6-1

parameters, C-1

duplicate job detection, 4-3

tier, 1-2

view job status on UNIX, 3-3, 3-15

Oracle Reports Services Queue Manager

monitoring job status, 3-17

scheduling jobs to run, 4-9

Oracle Reports Services server

configuring

UNIX with environment variables, 3-14

Windows NT with environment variables, 3-12

with environment variables, 3-12

creating a service entry, 3-11

database queue, 3-18

setting the default, 3-11, 3-12

UNIX, 3-12

Windows NT, 3-12

starting, 3-1

UNIX, 3-2, 3-13, 3-14

Windows NT, 3-2

Windows NT as a non-service, 3-3

stopping, 3-1, 3-4

UNIX, 3-4

Windows NT, 3-4

Oracle Universal Installer, 2-1

ORACLE_HOME/guicommon6/tk60/ADMIN directory, 3-15

ORACLE_HOMEREPORT60 directory, 4-5

ORACLE_HOMEREPORT60SERVER directory, 3-14

ORIENTATION command line argument, 4-3

overviews

clustering, 6-2

XML, 7-2

PAGESIZE command line argument, 4-3

parameters

CACHESIZE, 4-3

CLUSTERCONFIG, 6-2, 6-5

ENGLIFE, 6-5

MAXENGINE, 6-2, 6-3

MAXIDLE, 6-5

MINENGINE, 6-2, 6-3

Oracle Reports Services configuration, C-1

RWCLI60 command line arguments, B-1

SOURCEDIR, 3-13, 3-14, 4-7

PARAMFORM command line argument, 4-3

parser error messages for XML, 7-26

performing batch modifications in XML, 7-25

processing

reports, 1-6

Web reports, 1-4

queue activity, database, 3-18

RDF

file, 4-7

registry entries, D-1

REP file, 4-7

REPORT

command line argument, 4-3, 7-3

keyword, 7-28

report definitions, XML, 7-1

report requests

building reports, 4-7

duplicate job detection, 4-3

methods

ActiveX, 4-2

Oracle Portal component, 4-2

RWCLI60 command line, 4-1

SRW.RUN_REPORT, 4-2

URL syntax, 4-2

running from a browser, 4-8

specifying request, 4-7

when servers are clustered, 6-7

report source path setting, 3-13

REPORTS_PATH configuration environment variable, 3-14

REPORTS60_CGIMAP environment variable, 4-5

REPORTS60_COOKIE_EXPIRE environment variable, 3-15

REPORTS60_DB_AUTH environment variable, 3-16

REPORTS60_ENCRYPTION_KEY environment variable, 3-16

REPORTS60_PATH environment variable, 3-13, 3-14, 4-7

REPORTS60_REPORT_SERVER environment variable, F-5

REPORTS60_REPORTS_SERVER environment variable, 3-12, 3-16, 3-17, 4-6, 4-8

REPORTS60_REPORTS_SERVER environment variables, 6-7

REPORTS60_SSLPORT environment variable, 3-16

REPORTS60_SYS_AUTH environment variable, 3-16

resubmitting jobs, 6-7

running

a report request from a Web browser, 3-16

reports in a clustered configuration, 6-7

XML

report definition by itself, 7-25

report definitions, 7-19

runtime

customization

overview, 7-2

XML report definition, 7-3

rw_server.sql script, 3-18

RWCLI60

command, 4-1, 4-2

command line argument, 4-6, 4-8, B-1

command line request, 4-1

RWRUN60 executable file, 4-1

SCHEDULE command line argument, 6-7

script, rw_server.sql, 3-18

security, 5-1

SERVER

command line argument, 3-16, 3-17, 4-2, 4-6, 4-8, 6-7, F-5

servlet, 1-5

setting

default Oracle Reports Services server, 3-11

UNIX, 3-12

Windows NT, 3-12

SOURCEDIR parameter, 3-13, 3-14, 4-7

specifying report requests, 4-6

by building a report, 4-7

by scheduling to run automatically, 4-9

from a Web browser, 4-8

SRW.RUN_REPORT request method, 4-2

SRW.RUN.REPORT command, 4-2

starting Oracle Reports Services server, 3-1

UNIX, 3-2

Windows NT, 3-2

Windows NT (non-service), 3-3

stopping Oracle Reports Services server, 3-1

UNIX, 3-4

Windows NT, 3-4

Index

Symbols

A

B

C

D

E

F

I

K

L

M

O

P

Q

R

S

T

U

W

X