<i>i</i>AS Publishing Reports to the Web with Oracle Internet Application Server -- Index

XML tag reference, 7-32

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

<condition> XML tag reference, 7-34

<customize> XML tag reference, 7-36

<data> XML tag reference, 7-38

<dataSource> XML tag reference, 7-39

<exception> XML tag reference, 7-41

<field> XML tag reference, 7-43

<formLike> XML tag reference, 7-48

<formula> XML tag reference, 7-49

<function> XML tag reference, 7-51

<group> XML tag reference, 7-53

<groupAbove> XML tag reference, 7-54

<groupLeft> XML tag reference, 7-55

<labelAttribute> XML tag reference, 7-57

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

<report> XML tag reference, 7-79

<section> XML tag reference, 7-82

<select> XML tag reference, 7-83

<summary> XML tag reference, 7-85

<tabular> XML tag reference, 7-89

access control

availability calendars, 5-11

batch registering reports, 5-3

debugging, 5-23

example, 5-6

installing security in WebDB, 5-4

Oracle Reports system administrator, 5-10

overview, 5-2

printers, 5-16

report definition files, 5-18

setting default parameters, 5-25

accessing

database, 5-6

demo tables, 5-6

information in WebDB, 5-2

ActiveX request method, 4-3

adding

a report request to a folder in WebDB, 5-28

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

report definition at runtime, 7-21

report definition in PL/SQL, 7-22

report definition stored in a file, 7-22

report definition stored in memory, 7-22

architecture

Oracle Reports Services, 1-3

Oracle Reports Services tier, 1-3

database, 1-3

thin client, 1-3

Web server, 1-3

Web server configurations, 1-3

authentication cookie

expiring, A-30

setting domain, 5-5

availability calendar, 5-11

batch

modifications to reports, 7-26

registering, 5-3

reporting

from a WebDB site, 4-9, 5-29

BUILD IN privileges, 5-10

cache

destination type, 5-18

output parameters

COPIES, 5-23

DESFORMAT, 5-23

DESNAME, 5-23

DESTYPE, 5-23

P_LASTNAME, 5-23

P_SSN, 5-23

PRINTER, 5-23

SERVER, 5-23

USERID, 5-23

size, B-1

CACHESIZE parameter, 4-4

CLUSTERCONFIG parameter, 6-2, 6-5

clustering

configuring

master server, 6-5

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

CURRENCY, 4-3

CUSTOMIZE, 7-4, 7-20, 7-21, 7-22, 7-26

DECIMAL, 4-3

DESFORMAT, 4-3, 5-16

DESNAME, 5-16

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-4, 7-21

RWCLI60, 4-6, 4-8, A-1

SCHEDULE, 6-7

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

THOUSANDS, 4-3

TOLERANCE, 4-3

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

commands

line arguments, 1-5, 1-6

Oracle Reports Runtime, 4-3

READONLY, A-9, A-13

RWCLI60, 4-2, 4-3, 7-21, 7-22, 7-26

RWRUN60, 7-11, 7-22, 7-26, A-3, A-17

SCHEDULE, A-23

setenv, 3-12

SHOWAUTH, A-2, A-30

sqlplus, 5-4

SRW.RUN.REPORT, 4-3

concepts, 1-1

configuring

master server clustering, 6-5

Oracle Reports Security WebDB, 5-4

Oracle Reports 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, 1-8

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

Oracle Reports Servlet, 3-4

with JSDK, 3-5

with JServ, 3-6

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

Web server, 3-9

COPIES parameter

cache output, 5-23

restricted printer output, 5-24

runtime, 5-25

system, 5-19

user, 5-29

creating

a list of values, 5-19

a service entry for Oracle Reports Server, 3-10

a WebDB site, 5-26

availability calendar, 5-11

combined availability calendar, 5-15

daily calendar, 5-12

maintenance calendar, 5-13

TNSnames alias for connecting to WebDB, 5-7

user accounts, 5-9

for running reports, 5-10

system administrator, 5-10

WebDB

a folder, 5-26

personal folder, 5-30

XML

report definition required tags, 7-5

report definitions, 7-4, 7-5

CURRENCY command line argument, 4-3

CUSTOMIZE

command line argument, 7-4

keyword, 7-31

customizing

overview, 7-2

reports at runtime, 7-1

XML report definition, 7-5

daily calendar, 5-12

database tier, Oracle Reports Services, 1-3

DBA privileges, 5-11

debugging

restricted reports, 5-23

tracing options, 7-28

XML report definitions, 7-28

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

parameter

cache output, 5-23

restricted printer output, 5-24

runtime, 5-25

user, 5-29

DESNAME

command line argument, 5-16

parameter

cache output, 5-23

restricted printer output, 5-24

runtime, 5-25

destination

format

HTMLCSS, 5-18

PDF, 5-18

type

cache, 5-18

printer, 5-18

DESTYPE

command line argument, 4-3

parameter

cache output, 5-23

restricted printer output, 5-24

runtime, 5-25

user, 5-29

directories

ORACLE_HOME ET80ADMIN, 5-8

ORACLE_HOME ETWORKADMIN, 5-7

ORACLE_HOME/guicommon6/tk60/ADMIN, 3-15

ORACLE_HOMELISTENERCFG, 5-5

ORACLE_HOMEOOLS^#OC60RBBR60, 5-18

ORACLE_HOMEOOLS^#OC60USRBBR60, 5-6

ORACLE_HOMEREPORT60, 4-5

ORACLE_HOMEREPORT60SERVER, 3-13, 5-9

duplicate job detection

multiple output destinations, 4-3

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

ENGLIFE parameter, 6-5

environment variables

configuration, 3-15

REPORTS_PATH, 3-14

TNS_ADMIN, 3-14

REPORTS_REPORTS_SERVER, 3-16

REPORTS60_CGIMAP, 4-5

REPORTS60_COOKIE_EXPIRE, 3-15

REPORTS60_DB_AUTH, 3-15

REPORTS60_ENCRYPTION_KEY, 3-15

REPORTS60_PATH, 3-12, 3-14, 4-7, 5-21

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

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

<condition> XML tag reference, 7-36

<customize> XML tag reference, 7-37

<data> XML tag reference, 7-38

<dataSource> XML tag reference, 7-40

<exception> XML tag reference, 7-43

<field> XML tag reference, 7-47

<formLike> XML tag reference, 7-50

<formula> XML tag reference, 7-48

<function> XML tag reference, 7-52

<group> XML tag reference, 7-53

<groupAbove> XML tag reference, 7-55

<groupLeft> XML tag reference, 7-56

<labelAttribute> XML tag reference, 7-59

<layout> XML tag reference, 7-60

<matrix> XML tag reference, 7-66

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

<report> XML tag reference, 7-80

<section> XML tag reference, 7-83

<select> XML tag reference, 7-83

<summary> XML tag reference, 7-88

<tabular> XML tag reference, 7-90

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

formatting, 7-8

formatting exception, 7-10

full, 7-14

hyperlink, 7-11

PL/SQL, 7-11

execute privilege, 5-10

files

RDF, 4-7, 5-18

REP, 4-7, 5-18

RWRUN60 executable, 4-2

security.rdf, 5-6, 5-18

sqlnet.ora, 5-8

tnsnames.ora, 5-7, 5-8, 5-9, 5-17

uiprint.txt, 3-15

wdbsvr.cfg, 5-5

XML, 5-18

HTMLCSS destination format, 5-18

installing

Oracle Internet Application Server, 2-1

Oracle Reports Services Security, 5-3

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

starting Oracle Reports Server on UNIX, 3-12, 3-14

starting Oracle Reports Services on UNIX, 3-3, 3-14

WebDB, 5-4

WebDB security package, 5-4

invalid package procedure, 5-22

IP address for WebDB, 5-8

key map file

cgicmd.dat (Web 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-31

REPORT, 7-30

load balancing

resubmitting jobs, 6-7

running reports, 6-7

maintenance calendar, 5-13

making a report available in WebDB, 5-26

MAXENGINE parameter, 6-2, 6-3

MAXIDLE parameter, 6-5

migration from Web Cartridge to Web 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-9

Oracle Reports 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-10

database queue, 3-18

setting the default, 3-11

UNIX, 3-12

Windows NT, 3-11

starting, 3-2

UNIX, 3-3, 3-12, 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-3

configuring

for clustering, 6-1

parameters, B-1

duplicate job detection, 4-3

installing security in WebDB, 5-3, 5-4

tier, 1-3

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

Oracle Universal Installer, 2-2

ORACLE_HOME ET80ADMIN directory, 5-8

ORACLE_HOME ETWORKADMIN directory, 5-7

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

ORACLE_HOMELISTENERCFG directory, 5-5

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

ORACLE_HOMEREPORT60 directory, 4-5

ORACLE_HOMEREPORT60SERVER directory, 3-13, 5-9

ORIENTATION command line argument, 4-3

output destination sites, 5-31

overviews

clustering, 6-2

XML, 7-2

P_LASTNAME parameter

cache output, 5-23

restricted printer output, 5-24

runtime, 5-25

user, 5-29

P_SSN parameter

cache output, 5-23

restricted printer output, 5-24

runtime, 5-25

user, 5-18, 5-29

PAGESIZE command line argument, 4-3

parameters

cache output

COPIES, 5-23

DESFORMAT, 5-23

DESNAME, 5-23

DESTYPE, 5-23

P_LASTNAME, 5-23

P_SSN, 5-23

PRINTER, 5-23

SERVER, 5-23

USERID, 5-23

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

DESFORMAT, 5-24

DESNAME, 5-24

DESTYPE, 5-24

P_LASTNAME, 5-24

P_SSN, 5-24

PRINTER, 5-24

SERVER, 5-24

USERID, 5-24

runtime

COPIES, 5-25

DESFORMAT, 5-25

DESNAME, 5-25

DESTYPE, 5-25

P_LASTNAME, 5-25

P_SSN, 5-25

PRINTER, 5-25

SERVER, 5-25

USERID, 5-25

RWCLI60 command line arguments, A-1

SECURITYTNSNAME, 5-9

SOURCEDIR, 3-12, 3-14, 4-7, 5-21

system

COPIES, 5-19

USERID, 5-19

user

COPIES, 5-29

DESFORMAT, 5-29

DESTYPE, 5-29

P_LASTNAME, 5-29

P_SSN, 5-18, 5-29

USERID, 5-29

PARAMFORM command line argument, 4-3

parser error messages for XML, 7-28

PDF destination format, 5-18

performing batch modifications in XML, 7-26

printer destination type, 5-18

PRINTER parameter

cache output, 5-23

restricted printer output, 5-24

runtime, 5-25

privileges

BUILD IN, 5-10

DBA, 5-11

execute, 5-10

processing

reports, 1-7

Web reports, 1-5

queue activity, database, 3-18

RDF

adding access, 5-20

file, 4-7, 5-18

registry entries, C-1

REP file, 4-7, 5-18

REPORT

command line argument, 4-3, 7-4

keyword, 7-30

Report Definition File See RDF

report definitions, XML, 7-1

report output

to cache, 5-23

to restricted printer, 5-24

report requests

building reports, 4-7

duplicate job detection, 4-3

from Manage Component page, 5-23

in WebDB site, 5-26

methods

ActiveX, 4-3

RWCLI60 command line, 4-2

SRW.RUN_REPORT, 4-3

URL syntax, 4-2

WebDB component, 4-2

running from a browser, 4-8

scheduling in WebDB, 5-29

specifying request, 4-7

when servers are clustered, 6-7

report source path setting, 3-12

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

REPORTS60_ENCRYPTION_KEY environment variable, 3-15

REPORTS60_PATH environment variable, 3-12, 3-14, 4-7, 5-21

REPORTS60_REPORT_SERVER environment variable, E-5

REPORTS60_REPORTS_SERVER environment variable, 3-12, 3-16, 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-24

DESFORMAT, 5-24

DESNAME, 5-24

DESTYPE, 5-24

P_LASTNAME, 5-24

P_SSN, 5-24

PRINTER, 5-24

SERVER, 5-24

USERID, 5-24

resubmitting jobs, 6-7

roles

RW_ADMINISTRATOR, 5-10

RW_BASIC_USER, 5-10

running

a report request from a Web browser, 3-16

report output to cache, 5-23

report output to restricted printer, 5-24

reports in a clustered configuration, 6-7

WebDB, a report as a user, 5-28

XML

report definition by itself, 7-26

report definitions, 7-20

runtime

customization

overview, 7-2

XML report definition, 7-5

parameters

COPIES, 5-25

DESFORMAT, 5-25

DESNAME, 5-25

DESTYPE, 5-25

P_LASTNAME, 5-25

P_SSN, 5-25

PRINTER, 5-25

SERVER, 5-25

USERID, 5-25

RW_ADMINISTRATOR role, 5-10

RW_BASIC_USER role, 5-10

rw_server.sql script, 3-18

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

reports, 5-29

WebDB

report to run and push output, 5-29

reports, 5-30

script, rw_server.sql, 3-18

security, 5-1

implementation, 5-2

Oracle Reports system administrator, 5-10

setting up access control, 5-3

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

SECURITYTNSNAME parameter, 5-9

SERVER

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

parameter

cache output, 5-23

restricted printer output, 5-24

runtime, 5-25

Servlet, 1-5

setting

authentication cookie domain in WebDB, 5-5

default Oracle Reports Server, 3-11

UNIX, 3-12

Windows NT, 3-11

default parameters for users at runtime, 5-25

parameter values, 5-23

SOURCEDIR parameter, 3-12, 3-14, 4-7, 5-21

specifying report requests, 4-6

by building a report, 4-7

by scheduling to run automatically, 4-9

from a Web browser, 4-8

sqlnet.ora file, 5-8

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

USERID, 5-19

Index

Symbols

A

B

C

D

E

F

H

I

K

L

M

O

P

Q

R

S

T

U

V

W

X