A script-enabled browser is required for this page to function properly.

rwservlet

rwservlet (Reports Servlet) translates and delivers information between either a Web server or a J2EE Container (for example, OC4J) and the Reports Server, allowing you to run a report dynamically from your Web browser. Optionally, it can use the in-process server, which reduces the maintenance and administration of the Reports Server by providing a means for starting the server automatically, whenever it receives the first request from the client.

Usage notes

The keywords that can be used with rwservlet are:

ACCESSIBLE
ARRAYSIZE
AUTHID
AUTOCOMMIT
BACKGROUND
BCC
BLANKPAGES
BUFFERS
CACHELOB
CC
CELLWRAPPER
CMDKEY
COLLATE
CONTAINSHTMLTAGS
CONTAINSOLE
CONTENTAREA*
COPIES
CUSTOMIZE
DATEFORMATMASK
DELAUTH
DELIMITED_HDR
DELIMITER
DESFORMAT
DESNAME
DESTINATION
DESTYPE
DISTRIBUTE
ENGINERESPONSETIMEOUT
ENVID
EXPIRATION
EXPIREDAYS
EXPRESS_SERVER
FROM
GETJOBID
GETSERVERINFO
HELP
ITEMTITLE
JOBNAME
JOBTYPE
KILLENGINE
KILLJOBID
LONGCHUNK
MIMETYPE
MODE
MODULE|REPORT
NONBLOCKSQL
NOTIFYFAILURE
NOTIFYSUCCESS
NUMBERFORMATMASK
OLAP_CON
ONFAILURE
ONSUCCESS
ORIENTATION
OUTPUTFOLDER*
OUTPUTIMAGEFORMAT
OUTPUTPAGE
PAGEGROUP
PAGESIZE
PAGESTREAM
PARAMFORM
PARSEQUERY
PDFCOMP
PDFEMBED
READONLY
RECURSIVE_LOAD
REPLYTO
REPORT|MODULE
ROLE
RUNDEBUG
SCHEDULE
SERVER
SHOWAUTH
SHOWENV
SHOWJOBID
SHOWJOBS
SHOWMAP
SHOWMYJOBS
SITENAME*
SQLTRACE
SSOCONN
STATUSFOLDER*
STATUSFORMAT
STATUSPAGE
SUBJECT
SUPPRESSLAYOUT
TOLERANCE
TRACEOPTS
URLPARAMETER
USERID
USERSTYLES

* maintained for backward compatibility with Oracle9iAS Portal Release 1 and Oracle WebDB Release 2.2.

Examples

In the following examples, myias.mycomp.com is your Oracle Application Server instance, and 7779 is the port where rwservlet is running.

Example 1: Running a paper report to a browser (cache)

http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=pdf+destype=cache

Example 2: Sending report output to a file

http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=pdf+destype=file+desname=c:\mydir\test.

Example 3: Sending report output to a printer

http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=pdf+destype=printer+desname=myprinter

Example 4: Sending report output to e-mail

http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=pdf+destype=mail+desname=emp1@comp.com,emp2@comp.com+cc=emp3@comp.com+bcc=mgr@comp.com+replyto=me@comp.com+from=me@comp.com”

Example 5: Sending report output to WebDAV (any WebDAV server or OracleAS Portal WebDAV)

http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=htmlcss+destype=webdav+desname=”http://myusername:mypassword@mywebdavserv.com/mydir/test.html”

Example 6: Sending report output to OracleAS Portal

http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+destype=oracleportal+desformat=PDF+pagegroup=mypagegrp+outputpage=reports_output+itemtitle=pushtoportal+statuspage=result

Example 7: Sending XML PDS report output to a file

http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=myxmlpdstest.rdf+destype=file+desformat=PDF+desname=c:\mydir\my.pdf

Example 8: Sending JDBC PDS report output to a file

http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=myjdbcpdstest.rdf+destype=file+desformat=PDF+desname=c:\mydir\myxml.pdf+p_jdbcpds=sybuser/sybpwd@server1.mydomain.com:1300

Example 9: Distributing report output to multiple destinations

http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+distribute=yes+destination=c:\mydistribute.xml

Example 10: Running scheduled reports

http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserver+report=test.rdf+schedule=every first fri of month from 15:53 Oct 23, 1999 retry 3 after 1 hour”+destype=file+desformat=pdf+desname=test.pdf

Example 11: Using a secured Reports Server

http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=pdf+destype=file+desname=test.pdf+authid=myadmin/myadmin

Example 12: Using a key file

http://myias.mycomp.com:7779/reports/rwservlet?key1

where key1 is a key defined in the cgicmd.dat file (the keyname should be the first parameter)

or

http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+userparam=12+cmdkey=keyname

Example 13: Running a report with a Parameter Form

http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserver+report=test.rdf+userid=scott/tiger@mydb+destype=cache+desformat=htmlcss+paramform=html

Example 14: Running a report with e-mail notification

http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserver+report=test.rdf+userid=scott/tiger@mydb+destype=file+desformat=pdf+desname=test.pdf+notifysuccess=emp@comp.com+notifyfailure=admin@comp"

Example 15: Running a report that specifies a URL to be fetched with the URL engine

http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserver+report=test.rdf+userid=scott/tiger@mydb+destype=file+desformat=pdf+desname=test.pdf+jobType=rwurl+urlParameter="http://www.oracle.com"

Example 16: Running a report with tracing enabled

http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserver+report=test.rdf+userid=scott/tiger@mydb+destype=file+desformat=pdf+desname=test.pdf+traceopts=trace_prf

Example 17: Showing the environment information for server myrepserver

http://myias.mycomp.com:7779/reports/rwservlet/showenv?server=myrepserver+authid=myrepuser/myreppassword

Example 18: Viewing the past jobs information for server myrepserver

http://myias.mycomp.com:7779/reports/rwservlet/showjobs?server=myrepserver+authid=myrepuser/myreppassword+queuetype=past

Example 19: Viewing the cgicmd.dat key mappings

http://myias.mycomp.com:7779/reports/rwservlet/showmap?authid=myrepuser/myreppassword

Example 20: Viewing current jobs information for user myrepuser

http://myias.mycomp.com:7779/reports/rwservlet/showmyjobs?server=myrepserver+authid=myrepuser/myreppassword+queuetype=current

Example 21: Getting the status of a job with job ID 30

http://myias.mycomp.com:7779/reports/rwservlet/showjobid30?server=myrepserver+authid=myrepuser/myreppassword

Example 22: Cancelling a currently running job with job ID 122

http://myias.mycomp.com:7779/reports/rwservlet/killjobid122?server=myrepserver+authid=myrepuser/myreppassword

Example 23: Viewing the parsed query of a command

http://myias.mycomp.com:7779/reports/rwservlet/parsequery?server=myrepserver+authid=myrepuser/myreppassword+report=test.rdf+userid=scott/tiger@db+destype=cache+desformat=htmlcss

Example 24: Showing DB authentication page

http://myias.mycomp.com:7779/reports/rwservlet/showauth?server=myrepserver+authid=myrepuser/myreppassword+authtype=D

Example 25: Deleting cookies set by rwservlet

http://myias.mycomp.com:7779/reports/rwservlet/delauth?server=myrepserver+authid=myrepuser/myreppassword

Example 26: Getting the output of job with job ID 87 from server myrepserver

http://myias.mycomp.com:7779/reports/rwservlet/getjobid87?server=myrepserver+authid=myrepuser/myreppassword

Example 27: Displaying server information for server myrepserver

http://myias.mycomp.com:7779/reports/rwservlet/getserverinfo?server=myrepserver+authid=myrepuser/myreppassword

Example 28: Killing engine rwEng-1 in server myrepserver

http://myias.mycomp.com:7779/reports/rwservlet/killengine1?type=rwEng+server=myrepserver+authid=myrepuser/myreppassword

See also

rwbuilder

rwrun

rwclient

rwcgi

rwserver

rwconverter

rwbridge

Command line keywords

Using the command line

Running a report from the command line