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

rwrun

rwrun (Reports Runtime) runs a report using the OracleAS Reports Services in-process server. When you run a .rep file, the PL/SQL is already compiled and will not be recompiled. If you are running an .rdf file, the PL/SQL is automatically recompiled, if necessary (if the report wasn't compiled and saved from Reports Builder or the platform or version on which you were running the report is incompatible with the platform on which it was last compiled and saved).

Note: It is recommended that you use rwrun for testing purposes, and rwclient in a production environment. Using rwrun in a production environment may generate intermittent errors.

The keywords that can be used with rwrun are:

ACCESSIBLE
ARRAYSIZE
AUTHID
AUTOCOMMIT
BCC
BLANKPAGES
BUFFERS
CACHELOB
CC
CELLWRAPPER
CMDFILE
COLLATE
CONTAINSHTMLTAGS
CONTAINSOLE
CONTENTAREA*
COPIES
CUSTOMIZE
DATEFORMATMASK
DELIMITED_HDR
DELIMITER
DESFORMAT
DESNAME
DESTINATION
DESTYPE
DISTRIBUTE
EXPRESS_SERVER
FROM
ITEMTITLE
JVMOPTIONS
LONGCHUNK
MODE
MODULE|REPORT
NONBLOCKSQL
NOTIFYFAILURE
NOTIFYSUCCESS
NUMBERFORMATMASK
OLAP_CON
ONFAILURE
ONSUCCESS
ORIENTATION
OUTPUTFOLDER*
OUTPUTIMAGEFORMAT
OUTPUTPAGE
PAGEGROUP
PAGESIZE
PAGESTREAM
PDFCOMP
PDFEMBED
READONLY
RECURSIVE_LOAD
REPLYTO
REPORT|MODULE
ROLE
RUNDEBUG
SAVE_RDF
SITENAME*
SQLTRACE
SQLTRACE
STATUSFOLDER*
STATUSPAGE
SUBJECT
SUPPRESSLAYOUT
TRACEFILE
TRACEMODE
TRACEOPTS
USERID
USERSTYLES

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

Examples

Example 1: Customizing a report

rwrun userid=scott/tiger@mydb report=emp.rdf  customize=empcustomize.xml destype=file desformat=pdf desname=emp.pdf 

Example 2: Sending report output to a file

rwrun report=test.rdf userid=scott/tiger@mydb desformat=pdf destype=file desname=c:\mydir\test.pdf

Example 3: Sending report output to a printer

rwrun report=test.rdf userid=scott/tiger@mydb desformat=pdf destype=printer desname=myprinter

Example 4: Sending report output to e-mail

rwrun 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)

rwrun report=test.rdf userid=scott/tiger@mydb desformat=htmlcss destype=webdav desname="http://myusername:mypassword@mywebdavserv.com/mydir/test.html"

Example 6: Sending XML PDS report output to a file

rwrun report=myxmlpdstest.rdf destype=file desformat=PDF desname=c:\mydir\my.pdf 

Example 7: Sending JDBC PDS report output to a file

rwrun report=myjdbcpdstest.rdf destype=file desformat=PDF desname=c:\mydir\myxml.pdf p_jdbcpds=sybuser/sybpwd@server1.mydomain.com:1300 

Example 8: Distributing report output to multiple destinations

rwrun report=test.rdf userid=scott/tiger@mydb distribute=yes destination=c:\mydistribute.xml 

Example 9: Using a secured Reports Server

rwrun report=test.rdf userid=scott/tiger@mydb desformat=pdf destype=file desname=test.pdf authid=myadmin/myadmin

Example 10: Running a report with e-mail notification

rwrun report=test.rdf userid=scott/tiger@mydb destype=file desformat=pdf desname=test.pdf notifysuccess="emp@comp.com" notifyfailure="admin@comp.com"

Example 11: Running a report with trace enabled

rwrun report=test.rdf userid=scott/tiger@mydb destype=file desformat=pdf desname=test.pdf traceopts=trace_prf tracemode=trace_replace

See also

rwbuilder

rwclient

rwcgi

rwserver

rwservlet

rwconverter

rwbridge

Command line keywords

Using the command line

Running a report from the command line