DESTYPE
command line keywordDESTYPE
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 |
DESTYPE={CACHE|LOCALFILE|FILE|PRINTER|SYSOUT|MAIL|ORACLEPORTAL|FTP|WEBDAV|name_of_pluggable_destination}
Values |
Description |
|
Valid only for rwclient ,
rwservlet , and (for backward
compatibility) rwcgi . Sends the
output directly to the Web browser (cache). |
|
Valid only for When used with When used with |
|
Sends the output to the file on the server named in DESNAME .
|
|
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. |
|
Valid only for rwcgi .
Sends the output to the client machine's default output device and forces
a synchronous call.
|
|
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 |
|
Valid only for 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 |
With Oracle Reports 10g, DESTYPE
values of SCREEN
and PREVIEW
are no longer valid because the Reports Runtime
(rwrun
) user interface is obsolete. In Reports Builder, you
can still set the DESTYPE
system parameter to SCREEN
to format a report to display
screen fonts in the Previewer in the Reports Builder user interface.
DESTYPE=PRINTER
: On Windows, the hardware-based left margin
is ignored, by default. The printing origin starts from the top left corner
(0,0) of the physical paper and not the printable area. This is to facilitate
the design of printer hardware-based margin-independent reports. You must
ensure that your report's layout contains enough margin spacing such that
your data falls within the printable area. Margin fields in the Page Setup
dialog box have been disabled to ensure consistency with OracleAS Reports
Services. To revert to the old behavior of including the hardware margin,
set the REPORTS_ADD_HWMARGIN
environment variable to YES
.
DESTYPE=ORACLEPORTAL
:
The ORACLEPORTAL
destination cannot be used with distribution.
Instead, you can use DESTYPE=WEBDAV
for advanced XML based
distribution to OracleAS Portal.
Note: Ensure that the OracleAS Portal instance is WebDAV-enabled. Refer to the OracleAS Portal online Help for more information on how to enable WebDAV.
For more information on how to use WebDAV for distribution to OracleAS Portal, refer to Note 241821.1 on Oracle MetaLink at http://metalink.oracle.com: How to Send and Distribute Reports 9i Output to Oracle Portal?
The DESTYPE=ORACLEPORTAL
command line keyword cannot be
used with the rwrun
executable. Use this destination only
with rwservlet
, rwclient
, or rwcgi
.
Before you push Oracle Reports output to OracleAS Portal, ensure that you have created the following:
A valid OUTPUTPAGE
containing at least one item
region.
A valid PAGEGROUP
containing at least one item
region.
Before you push Oracle Reports output to OracleAS Portal, you need to edit the Reports Server configuration file as follows:
Uncomment the destype="oraclePortal"
element:
<destination destype="oraclePortal" class="oracle.reports.server.DesOraclePortal">
<!--property name="portalUserid"
value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%"
confidential="yes" encrypted="no"/-->
</destination>
Notes:
In Oracle9i Reports Release 2 (9.0.2), by default, the
portalUserid
property is uncommented and the connection
string in the property points to the infrastructure database.
To be able to push your report output to OracleAS Portal, the
portalUserid
property must remain uncommented.
In Oracle Reports 10g, by default, the portalUserid
property is commented. Reports Server will determine the connection
string and push the report output to OracleAS Portal. You need
to uncomment this only if you are using a different OracleAS
Portal instance.
Substitute the values in the portalUserid
property
with your OracleAS Portal connection information if you do not want
to push Oracle Reports output to the default OracleAS Portal instance.
Note: If you do not substitute the values or uncomment
the destype
entry, you will get the following error:
REP-56092: No class defined for destination type oracleportal
Running the request is very similar to any other out-of-the-box destinations. For example:
http://your_server:port/reports/rwservlet?report=test.rdf&userid=scott/tiger@repportal&authid=pushportal/trial&destype=oracleportal&desformat=PDF&pagegroup=PORTAL_REPORTS&outputpage=reports_output&itemtitle=pushtoportal&statuspage=result
DESTYPE=FTP
:
Running the request is very similar to any other out-of-the-box pluggable destinations. You need to specify the complete FTP URL location along with the file name. If the FTP server needs an authentication, that also needs to be part of the URL as shown in the following example:
http://your_server:port/reports/rwservlet?report=rep.jsp&destype=FTP&desname=ftp://user:pwd@ftpServer/dir/myreport.pdf&desformat=pdf
In this example, the DESTYPE
is FTP
and the
DESNAME
value is a complete FTP URL location, along with
the report name myreport.pdf
.
To use a proxy server, edit the destination
element (configured
for FTP out-of-the-box) in the server configuration file:
<destination destype="ftp"
class="oracle.reports.plugin.destination.ftp.DesFTP">
<!--property name="proxy" value="proxyinfo.xml"/-->
</destination>
To specify the proxy information, edit the proxyinfo.xml
file, available in the default location (ORACLE_HOME/reports/conf
).
Then, uncomment the proxy
property in the server configuration
file and specify the complete path to the proxyinfo.xml
file as the value.
For example, if your ORACLE_HOME
is located in
D:\oracle
, then the default location for proxyinfo.xml
can be specified as:
<destination destype="ftp" class="oracle.reports.plugin.destination.ftp.DesFTP">
<property name="proxy"value="D:\\oracle\/reports/\conf\\proxyinfo.xml"/>
</destination>
Note: The proxy server specified for the FTP destination must support the SOCKS protocol. This check is performed during initialization. If the proxy server does not support the SOCKS protocol, then the server raises the following error:
REP-62352: FTP Proxy Server specified is not responding
DESTYPE=WEBDAV
:
Running the request is very similar to any other out-of-the-box pluggable destinations. You need to specify the complete WebDAV URL location along with the file name. If the WebDAV server needs an authentication, that also needs to be part of the URL as shown in the following example:
http://your_server:port/reports/rwservlet?report=rep.jsp&destype=webdav&desname=http://user:pwd@webdavServer/myreport.pdf&desformat=pdf
In this example, the DESTYPE
is WEBDAV
and
the DESNAME
value is a complete WebDAV URL location along
with the report name myreport.pdf
.
To use a proxy server, edit the destination
element (configured
for WebDAV out-of-the-box) in the server configuration file:
<destination destype="webdav" class="oracle.reports.plugin.destination.webdav.DesWebDAV">
<!--property name="proxy" value="proxyinfo.xml"/-->
</destination>
To specify the proxy information, edit the proxyinfo.xml
file, available in the default location (ORACLE_HOME/reports/conf
).
Then, uncomment the proxy
property in the server configuration
file and specify the complete path to the proxyinfo.xml
file as the value.
For example, if your ORACLE_HOME
is located in
D:\oracle
, then the default location for proxyinfo.xml
can be specified as:
<destination destype="webdav" class="oracle.reports.plugin.destination.webdav.DesWebDAV">
<property name="proxy" value="D:\\oracle\/reports/\conf\\proxyinfo.xml"/>
</destination>
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
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
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
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
Copyright © 1984, 2005, Oracle. All rights reserved.