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.
When you use rwservlet
to run a JSP, you can use all keywords
applicable to rwservlet
. For more information on running a
JSP with rwservlet
, see the chapter "Running Report Requests"
in OracleAS Reports Services Publishing Reports to the Web, available
on the Oracle Technology
Network Oracle Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html
).
The following keywords are commands rather than keyword=value pairs; that
is, these keywords are entered by themselves without a corresponding value:
SHOWENV
, SHOWJOBS
, SHOWMAP
, SHOWMYJOBS
,
KILLJOBID
, KILLENGINE
, PARSEQUERY
,
DELAUTH
, GETJOBID
, and GETSERVERINFO
.
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.
In the following examples, myias.mycomp.com
is your Oracle Application
Server instance, and 7779
is the port where rwservlet
is running.
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=pdf+destype=cache
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=pdf+destype=file+desname=c:\mydir\test.
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=pdf+destype=printer+desname=myprinter
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”
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”
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
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=myxmlpdstest.rdf+destype=file+desformat=PDF+desname=c:\mydir\my.pdf
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
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+distribute=yes+destination=c:\mydistribute.xml
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
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
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
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserver+report=test.rdf+userid=scott/tiger@mydb+destype=cache+desformat=htmlcss+paramform=html
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"
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"
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
myrepserver
http://myias.mycomp.com:7779/reports/rwservlet/showenv?server=myrepserver+authid=myrepuser/myreppassword
http://myias.mycomp.com:7779/reports/rwservlet/showjobs?server=myrepserver+authid=myrepuser/myreppassword+queuetype=past
http://myias.mycomp.com:7779/reports/rwservlet/showmap?authid=myrepuser/myreppassword
http://myias.mycomp.com:7779/reports/rwservlet/showmyjobs?server=myrepserver+authid=myrepuser/myreppassword+queuetype=current
http://myias.mycomp.com:7779/reports/rwservlet/showjobid30?server=myrepserver+authid=myrepuser/myreppassword
http://myias.mycomp.com:7779/reports/rwservlet/killjobid122?server=myrepserver+authid=myrepuser/myreppassword
http://myias.mycomp.com:7779/reports/rwservlet/parsequery?server=myrepserver+authid=myrepuser/myreppassword+report=test.rdf+userid=scott/tiger@db+destype=cache+desformat=htmlcss
http://myias.mycomp.com:7779/reports/rwservlet/showauth?server=myrepserver+authid=myrepuser/myreppassword+authtype=D
http://myias.mycomp.com:7779/reports/rwservlet/delauth?server=myrepserver+authid=myrepuser/myreppassword
http://myias.mycomp.com:7779/reports/rwservlet/getjobid87?server=myrepserver+authid=myrepuser/myreppassword
http://myias.mycomp.com:7779/reports/rwservlet/getserverinfo?server=myrepserver+authid=myrepuser/myreppassword
http://myias.mycomp.com:7779/reports/rwservlet/killengine1?type=rwEng+server=myrepserver+authid=myrepuser/myreppassword
Running a report from the command line
Copyright © 1984, 2005, Oracle. All rights reserved.