Oracle Application Server Reports Services Publishing Reports to the Web -- Index

access controls, 11-5 to 11-24

availability calendar, combined, 11-9

availability calendar, simple, 11-6

printer, 11-11

report, 11-18

server, 11-14

accessible command keyword, A-16

Advanced Queuing, 17-2, 17-9, 17-10, 17-11, 17-12

dbms_AQadm package, 17-10

dbms_aq.dequeue, 17-13

DEQUEUE, 17-9

ENQUEUE, 17-9

MESSAGES, 17-9

ALTER_SESSION, 18-16

API

cache, 3-11

debugging events, 17-7

destinations, 3-20

engine, 3-12

events, 3-21, 17-1 to 17-13

notification, 3-22

pluggable destinations, 7-2, 15-1, 15-36

repository, 3-25

security, 3-17

architecture

destination, 7-3

NLS, 18-2

Reports Services, 1-1

arraysize command keyword, 20-22, A-16

attach distribution element, 15-12

format attribute, 15-13

instance attribute, 15-13

name attribute, 15-13

srcType attribute, 15-13

attributes, using variables with, 15-2

authentication cookies, 3-52

authid command keyword, 2-6, A-17

authid parameter, events, 17-4

autocommit command keyword, A-18

autostart command keyword, 2-3, A-18

availability calendar, 11-5 to 11-11

combined, 11-9

simple, 11-6

background command keyword, A-19

Barcode fonts, 4-34

batch command keyword, 2-3, 2-5, 2-6, A-20

batch modifications, XML, 16-22

batch registering reports in Oracle 9iAS Portal, C-1

bcc attribute, mail, 15-9

bcc command keyword, A-20

bidirectional support, 18-1 to 18-18

blankpages command keyword, A-21

body, 20-20

body distribution element, 15-10

format attribute, 15-12

instance attribute, 15-12

srcType attribute, 15-12

break groups

ORDER BY, 20-15

buffers command keyword, A-22

bursting, 15-6

distribution, 20-20

CA_GPREFS, B-2

CA_UPREFS, B-2

cache, 3-11

cache configuration element, 3-11, 13-24

class attribute, 3-11

cache destype, 7-5

cache key, 13-23

cacheDir, 3-12

cachelob command keyword, A-23

cacheSize property, 3-12

caching, 13-23

calculations, 20-13

example, 20-13

callBackTimeOut attribute, 3-14

cancelling a job, 17-6

case sensitivity, 2-8

cauprefs.ora, 8-27

cc attribute, mail, 15-9

cc command keyword, A-24

cell wrappers

text data sources, 20-12

cellwrapper command keyword, A-24

CGI, 1-2, 1-6

backward compatibility, 3-9

URL syntax, 13-4

cgicmd.dat, 3-44, 13-24 to 13-27

adding entries, 13-25

using, 13-26

character set

unicode, 18-14 to 18-17

UTF8, 18-15

character sets, 4-30, 18-1, 18-7, 18-10 to 18-13

design considerations, 18-7

font aliasing, 18-8

CID Fonts, 4-34

class attribute

cache, 3-11

destination, 3-20

engine, 3-13

jobStatusRepository, 3-25

notification, 3-23

security, 3-18

class, in JDBC configuration file, 8-5

classPath attribute, engine, 3-13

cluster, 3-51

cluster configuration element, 3-30

clustering servers, 3-30

clusters, 12-1 to 12-7

duplicate job detection, 13-24

linking to via OEM, 19-22

overview, 12-1

setting up, 12-2

submitting requests to, 12-6

viewing via OEM, 19-22

cmdfile command keyword, A-25

cmdkey command keyword, A-26

cmdkey parameter, events, 17-8

command keywords

accessible, A-16

arraysize, 20-22, A-16

authid, 2-6, A-17

autocommit, A-18

autostart, 2-3, A-18

background, A-19

batch, 2-3, 2-5, 2-6, A-20

bcc, A-20

blankpages, A-21

buffers, A-22

cachelob, A-23

cc, A-24

cell wrappers, 20-12

cellwrapper, A-24

cmdfile, A-25

cmdkey, A-26

contentarea, A-28

copies, A-29

customize, 16-1, 16-3, 16-17, 16-18, 16-22, 16-24, A-30

dateformatmask, A-30

delauth, A-31

delimited_hdr, A-32

delimiter, A-32

desformat, A-34

desname, A-36

dest, A-37

destination, A-38

destype, A-39

distribute, A-44

dtype, A-45

dunit, A-46

engineresponsetimeout, A-47

expiration, 1-8, A-48

expiredays, A-48

express_server, A-49

formsize, A-52

from, A-52

getjobid, A-53

getserverinfo, A-54

help, A-54

install, A-55, A-109

itemtitle, A-55

jobname, A-56

jobtype, A-57

killjobid, A-58

LONGCHUNK, 20-22

longchunk, A-59

mimetype, A-60

mode, A-60

module, 16-17, 16-24, A-61

nonblocksql, A-62

notifyfailure, A-62

notifysuccess, A-63

numberformatmask, A-64

olap_con, A-64

onfailure, A-65

onsuccess, A-66

orientation, A-67

ourputpage, A-70

outputfolder, A-67

outputimageformat, A-68

overwrite, A-71

p_availability, A-71

p_description, A-72

p_formats, A-73

p_name, A-73

p_owner, A-74

p_pformtemplate, A-74

p_printers, A-75

p_privilege, A-76

p_servers, A-76

p_trigger, A-77

p_types, A-77

pagegroup, A-78

pagesize, A-79

pagestream, A-80

paramform, A-81

parsequery, A-81

pdfcomp, A-82

pdfembed, A-83

printjob, A-83

readonly, A-84, A-85

RECURSIVE_LOAD, 20-22

replaceitem, A-85

replyto, A-86

report, 16-17, 16-24, A-61

role, A-87

rundebug, 20-22, A-88

save_rdf, A-89

schedule, 13-22, A-89

server, 2-5, 2-6, A-90

showenv, A-92

showjobs, 1-2, 17-5, A-93

showmap, A-94

showmyjobs, A-95

shutdown, 2-6, A-95

sitename, A-96

source, A-97

ssoconn, A-98

statusfolder, A-100

statusformat, A-101

statuspage, A-102

stype, A-103

subject, A-103

tolerance, 1-8, 13-24, A-105

tracefile, A-106

tracemode, A-107

traceopts, A-108

urlparameter, A-111

used with rwbuilder, A-6

used with rwcgi, A-12

used with rwclient, A-2

used with rwconverter, A-8

used with rwrun, A-4

used with rwserver, A-15

used with rwservlet, A-8

userid, A-111

webserver_debug, A-112

webserver_docroot, A-113

webserver_port, A-114

command lines, specifying, 13-5

commands

overview, A-1

rwbuilder, 16-24, A-6

rwcgi, A-11

rwclient, 16-17, 16-18, 16-22, A-2

rwconverter, 16-17, 16-22, A-7

rwrun, 16-18, 16-22, 16-24, A-4

rwserver, A-15

rwservlet, A-8

syntax, A-15

compatible configuration element, 3-3, 3-9

version attribute, 3-10

confidential attribute, 7-6

configuration, 3-1 to 3-64

considerations, 1-9

proxy information, 3-54

URL engine, 3-53

via OEM, 19-18

configuration elements

cache, 3-11, 13-24

cluster, 3-30

compatible, 3-3, 3-9

connection, 3-28

destination, 3-19, 7-5

engine, 3-12

environment, 3-35

identifier, 3-33

job, 3-21

jobStatusRepository, 3-24

log, 3-24

notification, 3-22

orbClient, 3-29

persistFile, 3-3, 3-32

pluginParam, 3-34, 15-10

queue, 3-31

security, 3-17

server, 3-9

trace, 3-26

configuration files

Reports Server, 3-2

rwserverconf.dtd, 3-4

rwserver.template, 3-3

rwservlet.properties, 3-3

configuration, Reports Server, 1-9

connection configuration element, 3-28

idleTimeOut attribute, 3-29

maxConnect attribute, 3-29

connection, in JDBC configuration file, 8-6

connectString, 8-5

contentarea command keyword, A-28

cookie, 10-2

cookieexpire, rwservlet.properties, 3-52

copies attribute, 20-23

printer, 15-20

copies command keyword, A-29

current jobs queue, 19-6

custom driver, 8-13

Custom Tag Handler, 1-6

customize command keyword, 16-1, 16-3, 16-22, 16-24, A-30

customize keyword, 16-18

DAS, see Delegation Administration Service

data definition

DTD schema, 20-12

XML schema, 20-12

data models, creating, 16-10 to 16-16

data sources

creating via XML, 16-10

group hierarchies via XML, 16-12

linking via XML, 16-11

data type dictionary

distribution.dtd, 15-2, 15-36

DTD, 20-12

rwserverconf.dtd, 3-3, 3-4

data types

BLOB, 20-22

CLOB, 20-22

DATE, 18-3

LONG, 20-22

LONG RAW, 20-22

NUMBER, 18-3

database authentication cookies, 3-52

Database Indexes

SQL WHERE clause, 20-12

database indexes, 20-12

database triggers, 17-8

dateformatmask command keyword, A-30

day names, language for, 18-9

DB2 driver, 8-10

dbauth, rwservlet.properties, 3-47

dbms_AQadm package, 17-10

dbms_aq.dequeue, 17-13

debugging events, 17-7

delauth command keyword, A-31

Delegated Administration Service, 9-11, 10-2, 11-4

delimited_hdr command keyword, A-32

DELIMITED_LINE_END, B-3

delimiter command keyword, A-32

DEQUEUE, 17-9

dequeuing, creating procedure, 17-12

desformat command keyword, A-34

desname command keyword, A-36

dest command keyword, A-37

destination

classes, 7-5

destypes, 7-5

valid values, 7-5

destination architecture, 7-3

destination command keyword, A-38

destination configuration element, 3-19, 7-5

class attribute, 3-20

destype attribute, 3-20

destination types, 3-20, 7-4

destinations distribution element, 15-4

destype attribute, 3-20, 7-5

cache, 7-5

file, 7-5

mail, 7-5

oraclePortal, 7-5

printer, 7-5

destype command keyword, A-39

destype distribution element, 15-20

id attribute, 15-22

instance attribute, 15-22

name attribute, 15-22

DEVELOPER_NLS_LANG, 18-10, 18-13, B-4

diagbodytags, rwservlet.properties, 3-52

diagheadtags, rwservlet.properties, 3-52

diagnostic, rwservlet.properties, 3-45

direction, of language, 18-9

dist parameter, events, 17-9

distribute command keyword, A-44

distribution, 15-1 to 15-34

bursting, 15-6, 20-20

distribution property, 20-21

group record level, 20-21

header, 20-20

repeat on property, 20-21

distribution elements

attach, 15-12

body, 15-10

destinations, 15-4

destype, 15-20

file, 15-16

foreach, 15-5

include, 15-14

mail, 15-8

printer, 15-18

property, 15-22

distribution examples, 15-23 to 15-34

file, 15-29

foreach, 15-23

mail, 15-26

printer, 15-30

distribution overview, 15-1 to 15-2

distribution, using XML file, 15-33

distribution.dtd, 15-2, 15-36

distribution.xsl, 15-36

DOC, B-3

drivers, 8-7

drivers, custom, 8-13

DTD, internal, 8-2

DTD, see data type dictionary

dtype command keyword, A-45

dunit command keyword, A-46

duplicate job detection, 13-24

dynamic environment switching, 3-37

elements, see distribution, customization, or configuration

encrypted attribute, 3-19, 7-6

encryption, 7-6

encryptionkey, rwservlet.properties, 3-52

engine configuration element, 3-12

callBackTimeOut attribute, 3-14

class attribute, 3-13

classPath attribute, 3-13

engLife attribute, 3-14

id attribute, 3-13

initEngine attribute, 3-13

maxEngine attribute, 3-13

maxIdle attribute, 3-14

minEngine attribute, 3-14

engineId attribute, 3-22

engineresponsetimeout command keyword, A-47

engLife attribute, 3-14

ENQUEUE, 17-9

enqueuing, creating procedure, 17-11

environment configuration element, 3-35

id attribute, 3-36

environment switching, 3-37

environment variables

CA_GPREFS, B-2

CA_UPREFS, B-2

DELIMITED_LINE_END, B-3

DEVELOPER_NLS_LANG, 18-10, B-4

DOC, B-3

INTERRUPT, B-4

NLS, 18-16

NLS_CALENDAR, B-4

NLS_CREDIT, B-4

NLS_CURRENCY, B-4

NLS_DATE_FORMAT, B-5

NLS_DATE_LANGUAGE, B-5

NLS_DEBIT, B-5

NLS_ISO_CURRENCY, B-5

NLS_LANG, 18-3, B-5

NLS_LIST_SEPARATOR, B-6

NLS_MONETARY_CHARACTERS, B-6

NLS_NUMERIC_CHARACTERS, B-6

NLS_SORT, B-7

ORACLE_AFM, B-7

ORACLE_HOME, B-7

ORACLE_HPD, B-8

ORACLE_PATH, B-8

ORACLE_PPD, B-9

ORACLE_TFM, B-9

ORAINFONAV_DOCPATH, B-10

PATH, 2-5

PRINTER, B-10

REMOTE, B-11

REPORTS_ADD_HWMARGIN, B-12

REPORTS_ARABIC_NUMERAL, 6-23, B-12

REPORTS_BIDI_ALGORITHM, B-13

REPORTS_CGIDIAGBODYTAGS, B-13

REPORTS_CGIDIAGHEADTAGS, B-14

REPORTS_CGIHELP, B-14

REPORTS_CGIMAP, B-15

REPORTS_CGINODIAG, B-16

REPORTS_CLASSPATH, B-16

REPORTS_COOKIE_EXPIRE, B-17

REPORTS_DB_AUTH, B-18

REPORTS_DEFAULT_DISPLAY, B-19, B-25

REPORTS_DEFAULT_PIXEL_SIZE, B-20

REPORTS_ENCRYPTION_KEY, B-20

REPORTS_GRAPH_IMAGE_DPI, B-21

REPORTS_JVM_OPTIONS, B-22

REPORTS_NLS_XML_CHARSETS, B-22

REPORTS_NO_DUMMY_PRINTER, B-23

REPORTS_NO_HTML_SPACE_REPLACE, B-24

REPORTS_PATH, B-26

REPORTS_RESOURCE, B-27

REPORTS_SERVER, B-27

REPORTS_SPACE_BREAK, B-28

REPORTS_SSLPORT, B-28

REPORTS_SYS_AUTH, B-29

REPORTS_TAGLIB_URI, B-29

REPORTS_TMP, B-30

REPORTS_USEREXIT, B-30

RW, B-31

TK_PRINT_STATUS, B-32

TK_PRINTER, B-33

TK90_AFM, B-34

TK90_HPD, B-34

TK90_PPD, B-35

TK90_TFM, B-35

USER_NLS_LANG, 18-10, B-36

USERNAME, B-36

WIN_REMOTE_SESSIONS, B-36

XMMITR, B-38

environment variables, editing, B-1

environment variables, NLS, 18-2 to 18-10

envVariable configuration element

envVariable Attribute, 3-36

name attribute, 3-36

error messages, 3-45, 3-50

error messages, XML, 16-23

errortemplate, 3-50

event-driven publishing, 1-9, 17-1 to 17-13

events

authid parameter, 17-4

cancelling a job, 17-6

cmdkey parameter, 17-8

creating a message queue, 17-10

creating dequeuing procedure, 17-12

creating enqueuing procedure, 17-11

debugging, 17-7

dist parameter, 17-9

gateway parameter, 17-4

invoking a report, 17-8

MyIdent.AuthID, 17-5

MyIdent.GatewayURL, 17-5

MyIdent.JobID, 17-5

MyIdent.ServerName, 17-5

ParamList-Object, 17-2

ParamList-Type, 17-2

report parameter, 17-4, 17-8

server parameter, 17-4

SRW_PARAMETER, 17-2

SRW_PARAMLIST, 17-2, 17-5, 17-10

srw_test.sql, 17-7

SRW.ADD_PARAMETER, 17-3

srwAPIdrop.sql, 17-2

srwAPIgrant.sql, 17-2

srwAPIins.sql, 17-2

SRW.CANCEL_REPORT, 17-7

SRW.CLEAR_PARAMETER_LIST, 17-4

SRW.JOB_IDENT, 17-5

SRW-Package, 17-2

SRW.REMOVE_PARAMETER, 17-3

SRW.REPORT_STATUS, 17-5

SRW.START_DEBUGGING, 17-7

SRW.STATUS_RECORD, 17-5

SRW.STOP_DEBUGGING, 17-7

userid parameter, 17-4, 17-8

examples, distribution, 15-23 to 15-34

file, 15-29

foreach, 15-23

mail, 15-26

printer, 15-30

Excel data source, 8-16

expiration command keyword, 1-8, A-48

expiredays command keyword, A-48

EXPLAIN PLAN

TKPROF, SQL trace, 20-7

express_server command keyword, A-49

failed jobs queue, 19-13

fetched ahead, 20-20

file destype, 7-5

file distribution element, 15-16

format attribute, 15-18

id attribute, 15-18

instance attribute, 15-18

name attribute, 15-18

fileName attribute, 3-33

finished jobs queue, 19-9

firewall

proxy information, 3-54

font aliasing, 18-8

font mapping, 18-8

font support, NLS, 18-15

fonts, true type big, 18-15

foreach distribution element, 15-5

Format

text fields span, 20-17

format

graphical layout objects, 20-17

horizontal elasticity, 20-17

non-graphical layout objects, 20-17

vertical elasticity, 20-17

format attribute

attach, 15-13

body, 15-12

file, 15-18

format triggers, 20-17

formsize command keyword, A-52

from attribute, mail, 15-9

from command keyword, A-52

gateway parameter, events, 17-4

getjobid command keyword, A-53

getserverinfo command keyword, A-54

Group Filters

WHERE clause, 20-15

group filters, 20-15

help command keyword, A-54

help, rwservlet.properties, 3-53

HTML

in debugging output, 3-52

in diagnostic output, 3-52

HTTP Secure Sockets Layer, 1-5

HTTP Server, 1-5, 9-10

HTTPS, 1-5

hyperlinks, adding via XML, 16-7

id attribute, 3-36

destype, 15-22

engine, 3-13

file, 15-18

mail, 15-9

notification, 3-23

orbClient, 3-29

printer, 15-19

security, 3-18

identifier configuration element, 3-33

idleTimeOut attribute, 3-29

image_url, rwservlet.properties, 3-51

include distribution element, 15-14

src attribute, 15-16

Informix driver, 8-12

initEngine attribute, 3-13

in-process server, 1-2, 1-6, 3-50

install command keyword, A-55, A-109

instance attribute

attach, 15-13

body, 15-12

destype, 15-22

file, 15-18

printer, 15-20

INTERRUPT, B-4

itemtitle command keyword, A-55

Java 2 Enterprise Edition, 1-6

java importer, 20-11

Java Servlet, 1-2

java stored procedures, 20-10

JDBC configuration file, 8-1

JDBC pluggable data source (PDS), 8-1

JDBC query, 8-15

JDBC report, 8-20

JDBC-ODBC driver, 8-7

job cancelling, 17-6

job configuration element, 3-21

engineId attribute, 3-22

jobType attribute, 3-22

securityId attribute, 3-22

job queues

managing via OEM, 19-6

viewing via OEM, 19-6

jobname command keyword, A-56

jobs queue

current, 19-6

failed, 19-13

finished, 19-9

scheduled, 19-8

jobs, running, 13-1 to 13-27

jobStatusRepository configuration element, 3-24

class attribute, 3-25

jobType attribute, 3-22

jobtype command keyword, A-57

JSP, 1-2, 1-6

images, 3-51

NLS, 18-10 to 18-13

specifying character set, 18-10 to 18-13

URL syntax, 13-3

using key mapping with, 13-27

VALIDATTAG, 20-22

JSP report, deploying to Web or paper, 13-8

key map file, 13-24 to 13-27

adding entries, 13-25

benefits, 13-25

enabling, 13-25

mapping URL parameters, 13-25

reloading, 3-45

restricted run with Parameter Form, 13-26

specifying location, 3-44

using, 13-26

KeyMapFile, 3-44

keywords

accessible, A-16

arraysize, A-16

authid, A-17

autocommit, A-18

autostart, A-18

background, A-19

batch, A-20

bcc, A-20

blankpages, A-21

buffers, A-22

cachelob, A-23

cc, A-24

cellwrapper, A-24

cmdfile, A-25

cmdkey, A-26

contentarea, A-28

copies, A-29

customize, 16-1, 16-3, 16-17, 16-18, 16-22, 16-24, A-30

dateformatmask, A-30

delauth, A-31

delimited_hdr, A-32

delimiter, A-32

desformat, A-34

desname, A-36

dest, A-37

destination, A-38

destype, A-39

distribute, A-44

dtype, A-45

dunit, A-46

engineresponsetimeout, A-47

expiration, A-48

expiredays, A-48

express_server, A-49

formsize, A-52

from, A-52

getjobid, A-53

getserverinfo, A-54

help, A-54

install, A-55, A-109

itemtitle, A-55

jobname, A-56

jobtype, A-57

killjobid, A-58

longchunk, A-59

mimetype, A-60

mode, A-60

module, 16-17, 16-24, A-61

nonblocksql, A-62

notifyfailure, A-62

notifysuccess, A-63

numberformatmask, A-64

olap_con, A-64

onfailure, A-65

onsuccess, A-66

orientation, A-67

outputfolder, A-67

outputimageformat, A-68

outputpage, A-70

overwrite, A-71

p_availability, A-71

p_description, A-72

p_formats, A-73

p_formtemplate, A-74

p_name, A-73

p_owner, A-74

p_printers, A-75

p_privilege, A-76

p_servers, A-76

p_trigger, A-77

p_types, A-77

pagegroup, A-78

pagesize, A-79

pagestream, A-80

paramform, A-81

parsequery, A-81

pdfcomp, A-82

pdfembed, A-83

printjob, A-83

readonly, A-84, A-85

replaceitem, A-85

replyto, A-86

report, 16-17, 16-24, A-61

role, A-87

rundebug, A-88

save_rdf, A-89

schedule, 13-22, A-89

server, A-90

showenv, A-92

showjobs, 17-5, A-93

showmap, A-94

showmyjobs, A-95

shutdown, A-95

sitename, A-96

source, A-97

ssoconn, A-98

statusfolder, A-100

statusformat, A-101

statuspage, A-102

stype, A-103

subject, A-103

tolerance, 13-24, A-105

tracefile, A-106

tracemode, A-107

traceopts, A-108

urlparameter, A-111

used with rwbuilder, A-6

used with rwcgi, A-12

used with rwclient, A-2

used with rwconverter, A-8

used with rwrun, A-4

used with rwserver, A-15

used with rwservlet, A-8

userid, A-111

webserver_debug, A-112

webserver_docroot, A-113

webserver_port, A-114

killjobid command keyword, A-58

languages

Middle Eastern, 18-13

North African, 18-13

languages, see NLS_LANG

LDAP, 11-2

listener, 1-5

log configuration element, 3-24

option attribute, 3-24

loginTimeout, 8-6

longchunk command keyword, 20-22, A-59

mail destype, 7-5

mail distribution element, 15-8

bcc attribute, 15-9

cc attribute, 15-9

from attribute, 15-9

id attribute, 15-9

organization attribute, 15-10

priority attribute, 15-9

replyTo attribute, 15-9

returnReciept attribute, 15-10

subject attribute, 15-9

to attribute, 15-9

managing Reports Services, 19-1 to 19-23

map

URL parameters, key map file, 13-25

maxConnect attribute, 3-29

maxEngine attribute, 3-13

maxIdle attribute, 3-14

maxQueueSize attribute, 3-32

Merant drivers, 8-7

message queue, creating, 17-10

MESSAGES, 17-9

messages, language for, 18-8

Middle Eastern languages, 18-13

mimetype command keyword, A-60

minEngine attribute, 3-14

mod_oc4j, 1-6

modecommand keyword, A-60

module command keyword, 16-24, A-61

module keyword, 16-17

monitoring Reports Services, 19-1 to 19-23

month names, language for, 18-9

multibyte, 18-1, 18-7, 18-14

multilingual text display, 18-15

MyIdent.AuthID, 17-5

MyIdent.GatewayURL, 17-5

MyIdent.JobID, 17-5

MyIdent.ServerName, 17-5

name attribute, 3-35

attach, 15-13

destype, 15-22

envVariable, 3-36

file, 15-18

printer, 15-20

name/value pairs, destination, 7-6

National Language Support, see NLS

NLS, 18-1 to 18-18

ALTER_SESSION, 18-16

architecture, 18-2

character sets, 18-7

DEVELOPER_NLS_LANG, 18-10

environment variables, 18-2 to 18-10

NLS_LANG, 18-15

font support, 18-15

JSP, 18-10 to 18-13

language-dependent data, 18-2

language-independent functions, 18-2

NLS_LANG, 18-3, 18-15

translating applications, 18-17

unicode, 18-14 to 18-17

USER_NLS_LANG, 18-10

NLS_CALENDAR, B-4

NLS_CREDIT, B-4

NLS_CURRENCY, B-4

NLS_DATE_FORMAT, B-5

NLS_DATE_LANGUAGE, B-5

NLS_DEBIT, B-5

NLS_ISO_CURRENCY, B-5

NLS_LANG, 18-3, 18-15, 18-16, B-5

American language, 18-4

Arabic language, 18-4

Bulgarian language, 18-4

Canadian French language, 18-4

Catalan language, 18-4

charset, 18-4

Chinese (Simplified) language, 18-5

Chinese (Traditional) language, 18-6

Croatian language, 18-4

Czech language, 18-4

Danish language, 18-4

defining, 18-6

Dutch language, 18-5

Egyptian language, 18-5

English (American) language, 18-5

English (United Kingdom) language, 18-5

Estonian language, 18-5

Finnish language, 18-5

French language, 18-5

German language, 18-5

Greek language, 18-5

Hebrew language, 18-5

Hungarian language, 18-5

Icelandic language, 18-5

Indonesian language, 18-5

Italian language, 18-5

Japanese language, 18-5

Korean language, 18-5

language, 18-3

language conventions, 18-8

Latvian language, 18-5

Lithuanian language, 18-5

Norwegian language, 18-5

Polish language, 18-5

Portuguese (Brazilian) language, 18-4

Portuguese language, 18-5

Romanian language, 18-5

Russian language, 18-5

Slovak language, 18-6

Spanish (Latin Americal) language, 18-5

Spanish (Mexican) language, 18-5

Spanish language, 18-6

Swedish language, 18-6

syntax, 18-3

territory, 18-4

territory conventions, 18-8

Thai language, 18-6

Turkish language, 18-6

Ukrainian language, 18-6

Vietnamese language, 18-6

NLS_LANG environment variable, 18-15, 18-16

NLS_LIST_SEPARATOR, B-6

NLS_MONETARY_CHARACTERS, B-6

NLS_NUMERIC_CHARACTERS, B-6

NLS_SORT, B-7

nonblocksql command keyword, A-62

North African languages, 18-13

notification configuration element, 3-22

class attribute, 3-23

id attribute, 3-23

notifyfailure command keyword, A-62

notifysuccess command keyword, A-63

numberformatmask command keyword, A-64

OC4J, 9-10

OEM, 19-1 to 19-23

launching, 19-2

managing job queues, 19-6

navigating to Reports Services, 19-2

performance monitoring, 19-15

reconfiguring Reports Server, 19-18

restarting Reports Servers, 2-2, 19-5

starting Reports Servers, 2-2, 19-5

stopping Reports Servers, 2-2, 19-5

viewing job queues, 19-6

OID, see Oracle Internet Directory

olap_con command keyword, A-64

onfailure command keyword, A-65

onsuccess command keyword, A-66

OPMN (Oracle Process Management and Notification), 2-1

option attribute, 3-24

ORA_PROF

PL/SQL, 20-9

Oracle Advanced Queuing, 17-2, 17-9, 17-10, 17-11, 17-12

dbms_AQadm package, 17-10

dbms_aq.dequeue, 17-13

DEQUEUE, 17-9

ENQUEUE, 17-9

MESSAGES, 17-9

Oracle Containers for J2EE, 1-6

Oracle Containers for Java 2 Enterprise Edition, 9-10

Oracle Enterprise Manager, see OEM

Oracle HTTP Server, 1-5, 2-1, 9-10

Oracle Internet Directory, 9-11, 11-2

Oracle JDBC OCI (thick) driver, 8-7

Oracle JDBC Thin driver, 8-7

Oracle Login Server, 9-11

Oracle Single Sign-on, 9-13

Oracle Technology Network, 11-1

ORACLE_AFM, B-7

ORACLE_HOME, 3-1, 20-5, B-7

ORACLE_HPD, B-8

ORACLE_PATH, B-8

ORACLE_PPD, B-9

ORACLE_TFM, B-9

OracleAS Portal, 11-1 to 11-24

availability calendar

combined, 11-9

simple, 11-6

destination element, example, 7-7

introduction, 9-12

printer access, 11-11

publishing a report portlet, 13-15

report access, 11-18

report requests, 13-6

runtime parameter form, 11-23

RW_ADMINISTRATOR, 11-3

RW_BASIC_USER, 11-2

RW_DEVELOPER, 11-2

RW_POWER_USER, 11-2

server access, 11-14

users and groups, 11-1

OracleAS Reports Services

single sign-on, 9-13

oraclePortal destype, 7-5

ORAINFONAV_DOCPATH, B-10

orbClient configuration element, 3-29

id attribute, 3-29

publicKeyFile Attribute, 3-30

ORDER BY

break groups, 20-14

organization attribute, mail, 15-10

orientation command keyword, A-67

OTN, see Oracle Technology Network

output

Postscript, 2-4

printer, 2-4

output processing, 7-1 to 7-4

output types, 7-1

outputfoldercommand keyword, A-67

outputimageformat command keyword, A-68

outputpage command keyword, A-70

overwrite command keyword, A-71

p_availability command keyword, A-71

p_description command keyword, A-72

p_formats command keyword, A-73

p_name command keyword, A-73

p_owner command keyword, A-74

p_pformtemplate command keyword, A-74

p_printers command keyword, A-75

p_privilege command keyword, A-76

p_servers command keyword, A-76

p_trigger command keyword, A-77

p_types command keyword, A-77

pagegroup command keyword, A-78

pagesize command keyword, A-79

pagestream command keyword, A-80

paramater list (events)

manipulating, 17-2 to 17-4

parameter form, 11-23

key map file, 13-26

parameter list (events)

creating, 17-2 to 17-4

paramform command keyword, 20-23, A-81

ParamList-Object, 17-2

ParamList-Type, 17-2

parsequery command keyword, A-81

PATH, 2-5

PDF Features

Accessibility, 6-14

Compression, 6-2

Font Aliasing, 6-3

Font Embedding, 6-10

Taxonomy, 6-15

pdfcomp command keyword, A-82

pdfembed command keyword, A-83

performance monitoring, 19-15

persisiFile configuration element

fileName attribute, 3-33

persistance, 1-2, 3-32, 13-24

persistFile configuration element, 3-3, 3-32

PL/SQL, 20-22

ALTER_SESSION, 18-16

ORA_PROF, 20-9

example, 20-9

SRW_PARAMETER, 17-2

SRW_PARAMLIST, 17-2, 17-5, 17-10

srw_test.sql, 17-7

SRW.ADD_DEFINITION, 16-19, 16-25

SRW.ADD_PARAMETER, 17-3

srwAPIdrop.sql, 17-2

srwAPIgrant.sql, 17-2

srwAPIins.sql, 17-2

SRW.APPLY_DEFINITION, 16-3, 16-17, 16-19

SRW.CANCEL_REPORT, 17-7

SRW.CLEAR_PARAMETER_LIST, 17-4

SRW.DO_SQL, 20-10

example, 20-10

SRW.JOB_IDENT, 17-5

SRW.MAXROW_UNSET, 20-14

SRW-Package, 17-2

SRW.REMOVE_PARAMETER, 17-3

SRW.REPORT_STATUS, 17-5

SRW.SET_MAXROW(), 20-14

example, 20-14

SRW.SET_TEXT_COLOR, 20-19

SRW.START_DEBUGGING, 17-7

SRW.STATUS_RECORD, 17-5

SRW.STOP_DEBUGGING, 17-7

stored procedures, 20-10

translating blocks, 18-17

PL/SQL, and advanced distribution, 15-3

pluggable

cache, 3-11

destinations, 3-20, 7-2, 15-1, 15-36

engine, 3-12

events, 3-21

notification, 3-22

repository, 3-25

security, 3-17

pluginParam

used with notification, 3-23

pluginParam configuration element, 3-34, 15-10

name attribute, 3-35

type attribute, 3-35

used with destination, 3-21

Portal, 11-1 to 11-24

availability calendar, combined, 11-9

availability calendar, simple, 11-6

introduction, 9-12

printer access, 11-11

report access, 11-18

report requests, 13-6

runtime parameter form, 11-23

RW_ADMINISTRATOR, 11-3

RW_BASIC_USER, 11-2

RW_DEVELOPER, 11-2

RW_POWER_USER, 11-2

server access, 11-14

users and groups, 11-1

portlet

adding to a page, 13-17, 13-19

creating provider for reports, 13-16

creating report definition file access, 13-17

Postscript, output to, 2-4

preferences file, 8-27

prefs.ora, 8-27

PRINTER, B-10

printer access controls, 11-11

printer destype, 7-5

printer distribution element, 15-18

copies attribute, 15-20

id attribute, 15-19

instance attribute, 15-20

name attribute, 15-20

printer, output to, 2-4

printjob command keyword, A-83

priority attribute, mail, 15-9

private key, 12-5

program units, adding via XML, 16-7

property distribution element, 15-22

property, in JDBC configuration file, 8-6

provider

creating for reports, 13-16

proxy information

configuring, 3-54

public key, 12-5

publicKeyFile attribute, 3-30

queue configuration element

maxQueueSize attribute, 3-32

queue element, 3-31

queue manager, 1-2, 13-22

queue viewer, 1-2

queues

current jobs, 19-6

failed jobs, 19-13

finished jobs, 19-9

managing via OEM, 19-6

scheduled jobs, 19-8

viewing via OEM, 19-6

reading order, 18-1, 18-13

readonly command keyword, A-84, A-85

RECURSIVE_LOAD command keyword, 20-22

registry, editing, B-1

registry, Windows, 18-7

reload_keymap, rwservlet.properties, 3-45

REMOTE, B-11

replaceitem command keyword, A-85

replyTo attribute, mail, 15-9

replyto command keyword, A-86

report access controls, 11-18

report command keyword, 16-24, A-61

report definitions, XML, 16-1

report keyword, 16-17

report parameter, events, 17-4, 17-8

reports

applying custom XML, 16-17 to 16-23

batch removing from OracleAS Portal, C-5

bursting, 15-6

caching, 13-23

command line requests, 13-5

current jobs queue, 19-6

debugging custom XML, 16-23 to 16-25

failed jobs queue, 19-13

finished jobs queue, 19-9

invoking via events, 17-8

processing, 1-7

request methods, 13-5

request via packaged procedure, 13-6

requests via Portal, 13-6

running automatically, 13-22

scheduled jobs queue, 19-8

scheduling, 13-22

URL requests, 13-6

URL syntax, 13-1

XML customization, 16-4 to 16-10

XML data models, 16-10 to 16-16

Reports CGI, 1-6

Reports Engine, 1-6, 1-9

Reports Engine, clustering architecture, load balancing, 12-2

Reports JSP, 1-6

Reports Queue Manager, 1-2, 13-22

Reports Queue Viewer, 1-2

Reports Server

access controls, 11-14

clusters, 12-1 to 12-7

configuration file, 1-9, 3-2

destination processing, 7-3

monitoring performance, 19-15

persistance, 3-32, 13-24

reconfiguring via OEM, 19-18

registering destination types, 7-4

renaming, 12-3

restarting, 12-6

restarting via OEM, 2-2, 19-5

starting as service, 2-3

starting as servlet, 2-5

starting from command line, 2-5

starting via OEM, 2-2, 19-5

status record, 17-6

stopping via OEM, 2-2, 19-5

Reports Services

about, 1-1

architecture, 1-1

cache API, 3-11

components, 1-5

destinations API, 3-20, 7-2, 15-1

engine API, 3-12

events API, 3-21

managing, 19-1 to 19-23

monitoring, 19-1 to 19-23

notification API, 3-22

persistance, 1-2

repository API, 3-25

security API, 3-17

single sign-on, 9-13

starting and stopping, 2-1

Reports Servlet, 1-6, 3-3, 9-10

URL syntax, 13-2

reports Trace

generating a trace file

Reports Builder, 20-4

reports trace, 20-4

generating a trace file, 20-4

RWBUILDER, 20-5

RWRUN, example, 20-6

RWSERVER, 20-5

RWSERVLET, 20-5

reports, running, 13-1 to 13-27

REPORTS_ADD_HWMARGIN, B-12

REPORTS_ARABIC_NUMERAL, 6-23, B-12

REPORTS_BIDI_ALGORITHM, B-13

REPORTS_CGIDIAGBODYTAGS, B-13

REPORTS_CGIDIAGHEADTAGS, B-14

REPORTS_CGIHELP, B-14

REPORTS_CGIMAP, B-15

REPORTS_CGINODIAG, B-16

REPORTS_CLASSPATH., B-16

REPORTS_COOKIE_EXPIRE, B-17

REPORTS_DB_AUTH, B-18

REPORTS_DEFAULT_DISPLAY, B-19, B-25

REPORTS_DEFAULT_PIXEL_SIZE, B-20

REPORTS_ENCRYPTION_KEY, B-20

REPORTS_GRAPH_IMAGE_DPI, B-21

REPORTS_JVM_OPTIONS, B-22

REPORTS_NLS_XML_CHARSETS, B-22

REPORTS_NO_DUMMY_PRINTER, B-23

REPORTS_NO_HTML_SPACE_REPLACE, B-24

REPORTS_PATH, B-26

REPORTS_RESOURCE, B-27

REPORTS_SERVER, B-27

REPORTS_SPACE_BREAK, B-28

REPORTS_SSLPORT, B-28

REPORTS_SYS_AUTH, B-29

REPORTS_TAGLIB_URI, B-29

REPORTS_TMP, B-30

REPORTS_USEREXIT, B-30

returnReceipt attribute, mail, 15-10

role command keyword, A-87

rundebug command keyword, 20-22, A-88

runing a report automatically

from OracleAS Portal, 13-18

running a report, 13-1

running a report automatically, 13-22

runtime parameter form, 11-23

runtime URL, 13-1 to 13-27

runtime URL syntax, 13-1

RW environment variable, B-31

RW_ADMINISTRATOR, 11-3

RW_BASIC_USER, 11-2

RW_DEVELOPER, 11-2

RW_POWER_USER, 11-2

rwbuilder command, 16-24, A-6

keywords used with, A-6

rwbuilder.conf, 3-2, 20-5

rwcgi command, A-11

keywords used with, A-12

rwclient, 13-5

rwclient command, 16-17, 16-18, 16-22, A-2

keywords used with, A-2

rwconverter

generating a SQL script for batch registration, C-1

rwconverter command, 16-17, 16-22, A-7

keywords used with, A-8

rwproxy, 3-9

RWRUN, 20-5

RECURSIVE_LOAD, 20-22

rwrun command, 16-18, 16-22, 16-24, A-4

keywords used with, A-4

rwrun.jar, 12-5

rwserver, 2-6

install, 2-3

server, 2-5

rwserver command, A-15

keywords used with, A-15

rwserverconf.dtd, 3-2, 3-4, 7-4, 7-6

cache element, 3-11

cluster element, 3-30

compatible element, 3-9

connection element, 3-28

destination element, 3-19

engine element, 3-12

environment element, 3-35

identifier element, 3-33

job element, 3-21

jobStatusRepository element, 3-24

log element, 3-24

notification element, 3-22

orbClient element, 3-29

persistFile element, 3-32

pluginParam element, 3-34

queue element, 3-31

security element, 3-17

server element, 3-9

trace element, 3-26

rwserver.template, 3-3

RWSERVLET, 20-22

rwservlet, 1-6, 2-5

exposing as a Web service, 13-22

rwservlet command, A-8

keywords used with, A-8

rwservlet.properties, 3-3

cookieexpire, 3-52

dbauth, 3-47

diagbodytags, 3-52

diagheadtags, 3-52

diagnostic, 3-45

encryptionkey, 3-52

errortemplate, 3-50

help, 3-53

image_url, 3-51

KeyMapFile, 3-44

reload_keymap, 3-45

server, 3-51

server_in_process, 3-50

single sign-on, 3-53

sysauth, 3-47

tracefile, 3-48

tracemode, 3-48

traceopts, 3-48

save_rdf command keyword, A-89

schedule command keyword, 13-22, A-89

scheduled jobs queue, 19-8

scripts

srw_test.sql, 17-7

srwAPIdrop.sql, 17-2

srwAPIgrant.sql, 17-2

srwAPIins.sql, 17-2

Secure Sockets Layer, 1-5

security configuration element, 3-17

class attribute, 3-18

id attribute, 3-18

securityId attribute, 3-22

serve parameter, events, 17-4

server, 9-10

in_process, 3-50

in-process, 1-2, 1-6

rwserver command, A-15

server access controls, 11-14

server cluster, 3-51

server clusters, 3-30

server command keyword, 2-5, 2-6, A-90

server configuration element, 3-9

server, rwservlet.properties, 3-51

server_in_process, 3-50

server_name.conf, 3-2

SERVEROUT, 17-7

servlet, 1-2, 1-6, 2-5, 3-3, 9-10

adding custom help, 3-53

rwservlet, A-8

URL syntax, 13-2

session cookie, 10-2

showenv command keyword, A-92

showjobs command keyword, 1-2, 17-5, A-93

showmap command keyword, A-94

showmyjobs command keyword, A-95

shutdown command keyword, 2-6, A-95

single sign-on, 9-13

feature, 9-13

rwservlet.properties, 3-53

single-byte, 18-14, 18-15

sitename command keyword, A-96

SMTP, 3-23, 15-8, 15-10

sorting sequence, of language, 18-9

source command keyword, A-97

sourceDatabase, 8-5

specifying a report request

for the URL engine, 13-21

from a Web browser, 13-21

publishing a report portlet, 13-15

scheduling to run automatically, 13-22

SQL Server driver, 8-11

SQL trace

TKPROF, EXPLAIN PLAN, 20-7

SQL*PLUS, 17-7

src attribute, include, 15-16

srcType attribute

attach, 15-13

body, 15-12

SRW_PARAMETER, 17-2

SRW_PARAMLIST, 17-2, 17-5, 17-10

srw_test.sql, 17-7

SRW.ADD_DEFINITION, 16-19, 16-25

SRW.ADD_PARAMETER, 17-3

srwAPIdrop.sql, 17-2

srwAPIgrant.sql, 17-2

srwAPIins.sql, 17-2

SRW.APPLY_DEFINITION, 16-3, 16-17, 16-19

SRW.CANCEL_REPORT, 17-7

SRW.CLEAR_PARAMETER_LIST, 17-4

SRW.DO_SQL, 20-10

SRW.JOB_IDENT, 17-5

SRW-Package, 17-2

SRW.REMOVE_PARAMETER, 17-3

SRW.REPORT_STATUS, 17-5

SRW.RUN_REPORT, 13-6

SRW.START_DEBUGGING, 17-7

SRW.STATUS_RECORD, 17-5

SRW.STOP_DEBUGGING, 17-7

SSL, 1-5

SSO, 3-53

ssoconn command keyword, A-98

status record, 17-6

statusfolder command keyword, A-100

statusformat command keyword, A-101

statuspage command keyword, A-102

stype command keyword, A-103

subject attribute, mail, 15-9

subject command keyword, A-103

subProtocol, 8-5

Sybase driver, 8-9

symbol equivalents, 18-9

syntax, of commands, A-15

syntax, reports URL, 13-1

sysauth, rwservlet.properties, 3-47

templates, rwserver.template, 3-3

text display, multilingual, 18-15

text reading order, 18-1

TK_PRINT_STATUS, B-32

TK_PRINTER, B-33

TK90_AFM, B-34

TK90_HPD, B-34

TK90_PPD, B-35

TK90_TFM, B-35

TKPROF

EXPLAIN PLAN, SQL trace, 20-7

tnsnames.ora, 3-10

to attribute, mail, 15-9

tolerance command keyword, 1-8, 13-24, A-105

trace configuration element, 3-26

traceFile, 20-5

traceFile attribute, 3-27

traceMode, 20-5

traceMode attribute, 3-27

traceOpts attribute, 3-27

trace configuration element,

traceFile, 20-6

traceOpts, 20-5

trace file output

ORACLE time, 20-7

SQL, 20-7

total elapsed time, 20-7

UPI, 20-7

trace_all, 3-28

trace_app, 3-27

trace_brk, 3-27

trace_dbg, 3-28

trace_dst, 3-28

trace_err, 3-28

trace_exc, 3-28

trace_inf, 3-28

trace_log, 3-28

trace_pls, 3-27

trace_prf, 3-27

trace_sql, 3-27

trace_sta, 3-28

trace_tms, 3-28

trace_wrn, 3-28

traceFile attribute, 3-27

tracefile command keyword, A-106

tracefile servlet parameter, 3-48

traceMode attribute, 3-27

tracemode command keyword, A-107

tracemode servlet parameter, 3-48

traceOpts attribute, 3-27

traceopts command keyword, A-108

traceopts servlet parameter, 3-48

tracing, 16-18

trailer, 20-20

translating applications, 18-17

translation

PL/SQL blocks, 18-17

TranslationHub tool, 18-17

triggers, database, 17-8

true type big fonts, 18-15

TrueType fonts, 4-32

type attribute, 3-35

Type1 fonts, 4-32

uifont.ali, 18-8

Unicode, 4-31

unicode, 18-14 to 18-17

URL engine

configuring, 3-53

elements, 3-53

sending a request to, 13-21

URL job requests, 13-1 to 13-27

URL, runtime syntax, 13-1

urlparameter command keyword, A-111

USER_NLS_LANG, 18-10, 18-13, B-36

userid command keyword, A-111

userid parameter, events, 17-4, 17-8

USERNAME, B-36

UTF8, 18-15

value attribute, 3-36

variables, NLS environment, 18-2 to 18-10

variables, using with XML attributes, 15-2

version attribute, 3-10

Web listener, 1-5, 9-10

Web service, 14-1

exposing rwservlet as, 13-22

operations, 14-6

viewing the WSDL, 14-3

webserver_debug command keyword, A-112

webserver_docroot command keyword, A-113

webserver_port command keyword, A-114

WIN_REMOTE_SESSIONS, B-36

Windows registry, 18-7

writing direction, of language, 18-9

XML

adding a new query, 16-8

adding formatting exceptions, 16-6

adding hyperlinks, 16-7

adding program units, 16-7

advanced distribution, 15-1 to 15-34

applying, 16-17 to 16-23

applying at runtime, 16-17

applying customizations, 16-3

applying definition in PL/SQL, 16-19

applying multiple definitions, 16-18

applying one definition, 16-17

applying via PL/SQL, 16-19

batch modifications, 16-22

changing format masks, 16-5

changing styles, 16-5

creating cross-product groups, 16-13

creating customizations, 16-3, 16-4 to 16-10

creating data models, 16-10 to 16-16

creating formulas, 16-14

creating group hierarchies, 16-12

creating matrix groups, 16-13

creating multiple data sources, 16-10

creating parameters, 16-15

creating placeholders, 16-14

creating summaries, 16-14

customization tracing options, 16-24

debugging, 16-25

debugging customizations, 16-23 to 16-25

distribution.dtd, 15-2, 15-36

interpreting, 16-2

linking data sources, 16-11

opening in Reports Builder, 16-24

parser error messages, 16-23

report customizations, 16-1 to 16-25

required customization tags, 16-4

running by itself, 16-22

using distribution XML file, 15-33

validating data, 20-12

XML attributes, using variables with, 15-2

XML, in JDBC configuration file, 8-2

XMMITR, B-38

XSL, distribution.xsl, 15-36