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

DESTYPE command line keyword

DESTYPE specifies the type of device that will receive the report output for paper-based reports. If you have created your own pluggable destination with the Reports Destination API, this is how the destination you created gets called.

The executables that can use this keyword are:

rwbuilder no
rwrun yes
rwclient yes
rwcgi yes
rwserver no
rwservlet yes
rwconverter no

Syntax

DESTYPE={CACHE|LOCALFILE|FILE|PRINTER|SYSOUT|MAIL|ORACLEPORTAL|FTP|WEBDAV|name_of_pluggable_destination}

Values

Description

CACHE

Valid only for rwclient, rwservlet, and (for backward compatibility) rwcgi. Sends the output directly to the Web browser (cache).

LOCALFILE

Valid only for rwclient, rwservlet, and (for backward compatibility) rwcgi. Sends the output to a file on the client machine and forces a synchronous call.

When used with rwclient, DESTYPE=LOCALFILE saves the output to the client machine using the file name specified by DESNAME.

When used with rwservlet or rwcgi, DESTYPE=LOCALFILE sets the mimetype to application/octet-stream to force the browser to display the Save dialog box. If for some reason this does not work, you can instead specify DESTYPE=CACHE and add MIMETYPE=REPORTS/LOCAL (or any non-registered mimetype) to force the browser to display the Save dialog box.

FILE

Sends the output to the file on the server named in DESNAME.

PRINTER

Sends the output to the printer on the server named in DESNAME. You must have a printer that the OracleAS Reports Server can recognize installed and running. See Usage notes, below.

SYSOUT

Valid only for rwcgi. Sends the output to the client machine's default output device and forces a synchronous call.

MAIL

Sends the output to the mail users specified in DESNAME. You can send mail to any mail system that works with SMTP.

Note: The configuration file server_name.conf must include the outgoing mail server name. This applies in both the Windows NT and UNIX environment.

ORACLEPORTAL

Valid only for rwclient, rwservlet, and (for backward compatibility) rwcgi. Sends the output to Oracle Portal. Relevant keywords include CONTENTAREA*, EXPIREDAYS, ITEMTITLE, OUTPUTFOLDER*, OUTPUTPAGE, PAGEGROUP, SCHEDULE, SITENAME*, STATUSFOLDER*, STATUSPAGE.

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

See Usage notes, below.

FTP

Sends the output to the specified FTP server.

See Usage notes, below.

WEBDAV

Sends the output to the specified WebDAV server so that the report can be published directly.

See Usage notes, below.

name_of_pluggable_destination If you have created your own pluggable destination with the Reports Destination API, this is how the destination you created gets called.
(Default)

Taken from the Initial Value property of the DESTYPE system parameter (defined in Reports Builder at design time).

Usage notes

Examples

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

rwrun 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=cache
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+
userid=scott/tiger@mydb+desformat=pdf+destype=cache

rwclient server=myrepserv report=test.rdf userid=scott/tiger@mydb desformat=pdf destype=cache

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
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+
userid=scott/tiger@mydb+desformat=pdf+destype=file+desname=c:\mydir\test.pdf
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+
userid=scott/tiger@mydb+desformat=pdf+destype=file+desname=c:\mydir\test.pdf
rwclient server=myrepserv 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
http://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+
userid=scott/tiger@mydb+desformat=pdf+destype=printer+desname=myprinter
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+
userid=scott/tiger@mydb+desformat=pdf+destype=printer+desname=myprinter
rwclient server=myrepserv 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"
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://mywebserver.com:7779/cgi-bin/rwcgi.exe?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"
rwclient 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)

Note: Currently there is no support for FTP and WebDAV destinations from the Reports Builder environment. However, they are supported from the Reports Runtime and the Reports Server environments.

rwrun 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+desformat=htmlcss+destype=webdav+
desname="http://myusername:mypassword@mywebdavserv.com/mydir/test.html"
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+
userid=scott/tiger@mydb+desformat=htmlcss+destype=webdav+
desname="http://myusername:mypassword@mywebdavserv.com/mydir/test.html"
rwclient 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

rwrun 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=test.rdf+
userid=scott/tiger@mydb+destype=oracleportal+desformat=PDF+pagegroup=mypagegrp+
outputpage=reports_output+itemtitle=pushtoportal+statuspage=result
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+
userid=scott/tiger@mydb+destype=oracleportal+desformat=PDF+pagegroup=mypagegrp+
outputpage=reports_output+itemtitle=pushtoportal+statuspage=result
rwclient server=myrepserv report=test.rdf userid=scott/tiger@mydb destype=oracleportal 
desformat=PDF pagegroup=mypagegrp outputpage=reports_output itemtitle=pushtoportal 
statuspage=result

See also

About pluggable destinations

Command line keywords

Using the command line

Running a report from the command line