Publishing Reports to the Web with Oracle9i 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-74

<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-84

<tabular> XML tag reference, 7-89

access control

availability calendars, 5-12

batch registering reports, 5-3

debugging, 5-24

example, 5-6

installing security in Oracle WebDB, 5-4

Oracle Reports Services system administrator, 5-11

overview, 5-3

printers, 5-17

report definition files, 5-19

setting default parameters, 5-26

accessing

database, 5-6

demo tables, 5-6

information in Oracle WebDB, 5-3

ActiveX request method, 4-2

adding

a report request to a folder in Oracle WebDB, 5-29

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, A-29

setting domain, 5-5

availability calendar, 5-12

batch

modifications to reports, 7-25

registering, 5-3

reporting

from an Oracle WebDB site, 4-8, 5-31

BUILD IN privileges, 5-11

cache

destination type, 5-19

output parameters

COPIES, 5-25

DESFORMAT, 5-25

DESNAME, 5-25

DESTYPE, 5-24

P_LASTNAME, 5-25

P_SSN, 5-25

PRINTER, 5-24

SERVER, 5-24

USERID, 5-25

size, B-1

CACHESIZE parameter, 4-4

CLUSTERCONFIG parameter, 6-2, 6-5

clustering

configuring

master server, 6-5

Oracle Reports Servers, 6-3

Oracle Reports Services, 6-3

enabling communication between master and slave, 6-4

overview, 6-2

resubmitting, 6-7

running reports, 6-7

combined availability calendar, 5-15

command line arguments, A-1

AUTHID, A-29

CURRENCY, 4-3

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

DECIMAL, 4-3

DESFORMAT, 4-3, 5-17

DESNAME, 5-17

DESTYPE, 4-3, A-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, A-1

SCHEDULE, 6-7

SERVER, 3-16, 3-17, 4-3, 4-6, 4-8, 6-7, A-22, C-2, E-5

THOUSANDS, 4-3

TOLERANCE, 4-3

USERID, 4-3, A-2, D-1

commands

line arguments, 1-4, 1-5

Oracle Reports Runtime, 4-3

READONLY, A-9, A-13

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

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

SCHEDULE, A-23

setenv, 3-12

SHOWAUTH, A-2, A-29

sqlplus, 5-5

SRW.RUN.REPORT, 4-3

concepts, 1-1

configuring

master server clustering, 6-5

Oracle Reports Server

modifying, 3-18

UNIX with environment variables, 3-14

Windows NT with environment variables, 3-13

with environment variables, 3-12

Oracle Reports Server CGI, 3-8, 3-10

Oracle Reports Server clustering, 6-1, 6-3

Oracle Reports Server servlet, 3-4

with JSDK, 3-5

with JServ, 3-7

Oracle Reports Services, 1-7

Oracle Reports Services Security with Oracle WebDB, 5-4

Web server, 3-9

COPIES parameter

cache output, 5-25

restricted printer output, 5-26

runtime, 5-26

system, 5-20

user, 5-30

creating

a list of values, 5-20

a service entry for Oracle Reports Server, 3-11

an Oracle WebDB site, 5-27

availability calendar, 5-12

combined availability calendar, 5-15

daily calendar, 5-13

maintenance calendar, 5-14

Oracle WebDB

a folder, 5-28

personal folder, 5-31

TNSnames alias for connecting to Oracle WebDB, 5-8

user accounts, 5-10

for running reports, 5-11

system administrator, 5-11

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, 5-13

database tier, Oracle Reports Services, 1-2

DBA privileges, 5-12

debugging

restricted reports, 5-24

tracing options, 7-26

XML report definitions, 7-26

DECIMAL command line argument, 4-3

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

demo table, accessing, 5-6

DESFORMAT

command line argument, 4-3, 5-17

parameter

cache output, 5-25

restricted printer output, 5-25

runtime, 5-26

user, 5-30

DESNAME

command line argument, 5-17

parameter

cache output, 5-25

restricted printer output, 5-26

runtime, 5-26, 5-27

destination

format

HTMLCSS, 5-19

PDF, 5-19

type

cache, 5-19

printer, 5-19

DESTYPE

command line argument, 4-3

parameter

cache output, 5-24

restricted printer output, 5-25

runtime, 5-26

user, 5-30

directories

ORACLE_HOME ET80ADMIN, 5-8

ORACLE_HOME ETWORKADMIN, 5-8

ORACLE_HOME/guicommon6/tk60/ADMIN, 3-15

ORACLE_HOMELISTENERCFG, 5-6

ORACLE_HOMEOOLS^#OC60RBBR60, 5-19

ORACLE_HOMEOOLS^#OC60USRBBR60, 5-6

ORACLE_HOMEREPORT60, 4-5

ORACLE_HOMEREPORT60SERVER, 3-14, 5-10

duplicate job detection

multiple output destinations, 4-3

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

ENGLIFE parameter, 6-5

environment variables

configuration, 3-16

REPORTS_PATH, 3-14

TNS_ADMIN, 3-14

REPORTS_REPORTS_SERVER, 3-17

REPORTS60_CGIMAP, 4-5

REPORTS60_COOKIE_EXPIRE, 3-16

REPORTS60_DB_AUTH, 3-16

REPORTS60_ENCRYPTION_KEY, 3-16

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

REPORTS60_REPORT_SERVER, E-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-31

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

<condition> XML tag reference, 7-34

<customize> XML tag reference, 7-35

<data> XML tag reference, 7-37

<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-68

<matrixCol> XML tag reference, 7-69

<matrixRow> XML tag reference, 7-70

<programUnits> XML tag reference, 7-73

<properties> XML tag reference, 7-74

<property> XML tag reference, 7-77

<report> XML tag reference, 7-79

<section> XML tag reference, 7-82

<select> XML tag reference, 7-83

<summary> XML tag reference, 7-88

<tabular> XML tag reference, 7-89

access control, 5-6

full URL syntax, 4-8

key mapping, 4-5, 4-6

RWCLI60 command line request, 4-2

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

execute privilege, 5-11

files

RDF, 4-7, 5-19

REP, 4-7, 5-19

RWRUN60 executable, 4-2

security.rdf, 5-6, 5-19

sqlnet.ora, 5-9

tnsnames.ora, 5-8, 5-10, 5-18

uiprint.txt, 3-15

wdbsvr.cfg, 5-6

XML, 5-19

HTMLCSS destination format, 5-19

installing

Oracle Reports Services Security, 5-4

Oracle WebDB, 5-4

Oracle WebDB security package, 5-4

Oracle9i Application Server, 2-1

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

starting Oracle Reports Server on UNIX, 3-3, 3-13, 3-14, 3-15

invalid package procedure, 5-24

IP address for Oracle WebDB, 5-9

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-29

load balancing

resubmitting jobs, 6-7

running reports, 6-7

maintenance calendar, 5-14

making a report available in Oracle WebDB, 5-27

MAXENGINE parameter, 6-2, 6-3

MAXIDLE parameter, 6-5

migration from Web cartridge to CGI, E-1

MINENGINE parameter, 6-2, 6-3

MODE command line argument, 4-3

OAS (Oracle Application Server), E-1

Oracle Application Server (OAS), E-1

Oracle HTTP Server powered by Apache, 2-2

Oracle Reports Queue Manager

monitoring job status, 3-17

scheduling jobs to run, 4-8

Oracle Reports Server

configuring

UNIX with environment variables, 3-14

Windows NT with environment variables, 3-13

with environment variables, 3-12

creating a service entry, 3-11

database queue, 3-18

setting the default, 3-12

UNIX, 3-12

Windows NT, 3-12

starting, 3-2

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

Windows NT, 3-2

Windows NT as a non-service, 3-3

stopping, 3-2, 3-4

UNIX, 3-4

Windows NT, 3-4

Oracle Reports Services

architecture, 1-2

configuring

for clustering, 6-1

parameters, B-1

duplicate job detection, 4-3

installing security in Oracle WebDB, 5-4

tier, 1-2

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

Oracle Universal Installer, 2-2

Oracle WebDB

accessing

information, 5-3

Oracle Reports Services, 5-18

Oracle Reports Services printer, 5-17

report definition file, 5-19

adding a report request to a folder, 5-29

component request method, 4-2

configuring Oracle Reports Services Security, 5-4

creating

a folder, 5-28

a site, 5-27

personal folder, 5-31

TNSnames alias for connecting, 5-8

installing, 5-4

installing, security package, 5-4

IP address, 5-9

making report available, 5-27

running a report as a user, 5-30

scheduling

a report to run and push output, 5-31

reports, 5-31

setting authentication cookie domain, 5-5

viewing pushed report output, 5-33

Oracle WebDBl

scheduling

a report, 5-32

ORACLE_HOME ET80ADMIN directory, 5-8

ORACLE_HOME ETWORKADMIN directory, 5-8

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

ORACLE_HOMELISTENERCFG directory, 5-6

ORACLE_HOMEOOLS^#OC60USRBBR60 directory, 5-6, 5-19

ORACLE_HOMEREPORT60 directory, 4-5

ORACLE_HOMEREPORT60SERVER directory, 3-14, 5-10

ORIENTATION command line argument, 4-3

output destination sites, 5-32

overviews

clustering, 6-2

XML, 7-2

P_LASTNAME parameter

cache output, 5-25

restricted printer output, 5-26

runtime, 5-26

user, 5-30

P_SSN parameter

cache output, 5-25

restricted printer output, 5-26

runtime, 5-26

user, 5-20, 5-30

PAGESIZE command line argument, 4-3

parameters

cache output

COPIES, 5-25

DESFORMAT, 5-25

DESNAME, 5-25

DESTYPE, 5-24

P_LASTNAME, 5-25

P_SSN, 5-25

PRINTER, 5-24

SERVER, 5-24

USERID, 5-25

CACHESIZE, 4-4

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, B-1

restricted printer output

COPIES, 5-26

DESFORMAT, 5-25

DESNAME, 5-26

DESTYPE, 5-25

P_LASTNAME, 5-26

P_SSN, 5-26

PRINTER, 5-25

SERVER, 5-25

USERID, 5-26

runtime

COPIES, 5-26

DESFORMAT, 5-26

DESNAME, 5-26, 5-27

DESTYPE, 5-26

P_LASTNAME, 5-26

P_SSN, 5-26

PRINTER, 5-26

SERVER, 5-26

USERID, 5-26

RWCLI60 command line arguments, A-1

SECURITYTNSNAME, 5-9, 5-10

SOURCEDIR, 3-13, 3-15, 4-7, 5-22

system

COPIES, 5-20

USERID, 5-20

user

COPIES, 5-30

DESFORMAT, 5-30

DESTYPE, 5-30

P_LASTNAME, 5-30

P_SSN, 5-20, 5-30

USERID, 5-30

PARAMFORM command line argument, 4-3

parser error messages for XML, 7-26

PDF destination format, 5-19

performing batch modifications in XML, 7-25

printer destination type, 5-19

PRINTER parameter

cache output, 5-24

restricted printer output, 5-25

runtime, 5-26

privileges

BUILD IN, 5-11

DBA, 5-12

execute, 5-11

processing

reports, 1-6

Web reports, 1-4

queue activity, database, 3-18

RDF

adding access, 5-21

file, 4-7, 5-19

registry entries, C-1

REP file, 4-7, 5-19

REPORT

command line argument, 4-3, 7-3

keyword, 7-29

report definition file See RDF

report definitions, XML, 7-1

report output

to cache, 5-24

to restricted printer, 5-25

report requests

building reports, 4-7

duplicate job detection, 4-3

from Manage Component page, 5-24

in Oracle WebDB site, 5-27

methods

ActiveX, 4-2

Oracle WebDB component, 4-2

RWCLI60 command line, 4-2

SRW.RUN_REPORT, 4-3

URL syntax, 4-2

running from a browser, 4-7

scheduling in Oracle WebDB, 5-31

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-16

REPORTS60_DB_AUTH environment variable, 3-16

REPORTS60_ENCRYPTION_KEY environment variable, 3-16

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

REPORTS60_REPORT_SERVER environment variable, E-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

restricted printer output parameters

COPIES, 5-26

DESFORMAT, 5-25

DESNAME, 5-26

DESTYPE, 5-25

P_LASTNAME, 5-26

P_SSN, 5-26

PRINTER, 5-25

SERVER, 5-25

USERID, 5-26

resubmitting jobs, 6-7

roles

RW_ADMINISTRATOR, 5-11

RW_BASIC_USER, 5-11

running

a report request from a Web browser, 3-17

Oracle WebDB, a report as a user, 5-30

report output to cache, 5-24

report output to restricted printer, 5-25

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

parameters

COPIES, 5-26

DESFORMAT, 5-26

DESNAME, 5-26, 5-27

DESTYPE, 5-26

P_LASTNAME, 5-26

P_SSN, 5-26

PRINTER, 5-26

SERVER, 5-26

USERID, 5-26

RW_ADMINISTRATOR role, 5-11

RW_BASIC_USER role, 5-11

rw_server.sql script, 3-19

RWCLI60

command, 4-2, 4-3

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

command line request, 4-2

RWRUN60 executable file, 4-2

SCHEDULE command line argument, 6-7

scheduling

Oracle WebDB

report to run and push output, 5-31

reports, 5-32

reports, 5-31

script, rw_server.sql, 3-19

security, 5-1

implementation, 5-3

Oracle Reports Services system administrator, 5-11

setting up access control, 5-3

security.rdf file, 5-6, 5-19

SECURITYTNSNAME parameter, 5-9, 5-10

SERVER

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

parameter

cache output, 5-24

restricted printer output, 5-25

runtime, 5-26

servlet, 1-4

setting

authentication cookie domain in Oracle WebDB, 5-5

default Oracle Reports Server, 3-12

UNIX, 3-12

Windows NT, 3-12

default parameters for users at runtime, 5-26

parameter values, 5-24

SOURCEDIR parameter, 3-13, 3-15, 4-7, 5-22

specifying report requests, 4-6

by building a report, 4-7

by scheduling to run automatically, 4-8

from a Web browser, 4-7

sqlnet.ora file, 5-9

SRW.RUN_REPORT request method, 4-3

SRW.RUN.REPORT command, 4-3

starting Oracle Reports Server, 3-2

UNIX, 3-3

Windows NT, 3-2

Windows NT (non-service), 3-3

stopping Oracle Reports Server, 3-2

UNIX, 3-4

Windows NT, 3-4

system parameters

COPIES, 5-20

USERID, 5-20

Index

Symbols

A

B

C

D

E

F

H

I

K

L

M

O

P

Q

R

S

T

U

V

W

X