Oracle® Fusion Middleware Publishing Reports to the Web with Oracle Reports Services 11g Release 1 (11.1.1) Part Number B32121-02 |
|
|
View PDF |
This section provides a brief description of the Oracle Reports components and the keywords that each component can use.
rwclient
(Reports Client) parses and transfers a command line to the specified Reports Server.
All file names and paths specified in the client command line refer to files and directories on the server machine, except for any file specified for the following command line keywords:
CMDFILE=
filename
. In this case, the CMDFILE specified is read and appended to the original command line (of which CMDFILE
is a part) before being sent to the Reports Server. The runtime engine does not reread the command file
DESNAME=
filename
DESTYPE=LOCALFILE
. In this case, DESNAME
refers to files on the client machine.
Refer to Table A-1 for the keywords that can be used with rwclient
.
Examples
Example 1: Running a paper report to cache
rwclient server=myrepserv report=test.rdf userid=scott/tiger@mydb
desformat=pdf
DESTYPE=cache
Example 2: Sending report output to a file
rwclient 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
rwclient server=myrepserv report=test.rdf userid=scott/tiger@mydb
DESTYPE=printer
DESNAME=myprinter
Example 4: Sending report output through e-mail
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 Oracle Portal WebDAV)
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 Oracle Portal
rwclient 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
rwclient server=myrepserv report=myxmlpdstest.rdf
DESTYPE=file desformat=PDF desname=c:\mydir\my.pdf
Example 8: Sending JDBC PDS report output to a file
rwclient 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 a report output to multiple destinations:
rwclient server=myrepserv report=test.rdf userid=scott/tiger@mydb
DISTRIBUTE=yes
DESTINATION=c:\mydistribute.xml
Example 10: Running scheduled reports
rwclient server=myrepserver report=test.rdf
SCHEDULE="every first fri of month from 15:53 Mar 25, 2009 retry 3 after 1 hour"
destype=file desformat=pdf desname=test.pdf
Example 11: Using a secured Reports Server
rwclient server=myrepserv report=test.rdf userid=scott/tiger@mydb desformat=pdf destype=file desname=test.pdf
AUTHID=myadmin/myadmin
Example 12: Running a report with e-mail notification
rwclient server=myrepserver report=test.rdf userid=scott/tiger@mydb destype=file desformat=pdf desname=test.pdf
NOTIFYSUCCESS="emp@comp.com"
NOTIFYFAILURE="admin@comp.com"
Example 13: Running a report that specifies a URL to be fetched with the URL engine
rwclient server=myrepserver report=test.rdf userid=scott/tiger@mydb destype=file desformat=pdf desname=test.pdf
JOBTYPE=rwurl
URLPARAMETER="http://www.oracle.com"
rwrun
(Reports Runtime) runs a report by starting its own in-process server (not to be confused with the default in-process Reports Server), which runs in the same JVM as the rwrun
process.
The configuration file for this in-process server is rwbuilder.conf
and trace files are saved in the rep_
machinename
-rwbuilder
directory.
Note:
It is recommended that you userwrun
for testing purposes only. Use rwservlet
and rwclient
in your production environment to take full advantage of the power of Oracle Reports Services.Refer to Table A-1 for the keywords that can be used with rwrun
.
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
DESTYPE=printer
DESNAME=myprinter
Example 4: Sending report output through 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 Oracle 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 report output to Oracle Portal
rwrun 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
rwrun report=myxmlpdstest.rdf destype=file desformat=PDF desname=c:\mydir\my.pdf
Example 8: 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 9: Distributing report output to multiple destinations
rwrun report=test.rdf userid=scott/tiger@mydb
DISTRIBUTE=yes
DESTINATION=c:\mydistribute.xml
Example 10: Using a secured Reports Server
rwrun report=test.rdf userid=scott/tiger@mydb desformat=pdf destype=file desname=test.pdf
AUTHID=myadmin/myadmin
Example 11: 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"
rwbuilder
invokes Oracle Reports Builder. When you include a REPORT|MODULE
keyword on the command line with rwbuilder
, Oracle Reports Builder opens with the specified report highlighted in the Object Navigator. When no report is specified, Oracle Reports Builder opens with a Welcome dialog offering you the choice of opening an existing report or creating a new one.
Refer to Table A-1 for the keywords that can be used with rwbuilder
.
Example
rwbuilder report=myrep.rdf userid=scott/tiger@mydb
rwconverter
(Reports Converter) enables you to convert one or more report definitions or PL/SQL libraries from one storage format to another. For example, you can use rwconverter
to:
Combine a report file with an XML file to create a new report
Convert a report stored in an .rdf
file to a .rep,
.rex,
.jsp,
or .tdf
(template) file.
Note:
When a report is converted to a template, only objects in the report's header and trailer sections and margin area are used in the template. Objects in the main section are ignored.Convert a report stored in a .rex
file to an .rdf
or a template (.tdf
file)
Convert a library stored in the database to a .pld
or .pll
file
Convert a library stored in a .pld
file into a database library or a .pll
file
Convert a library stored in a .pll
file into a database library of a .pld
file
Note:
When you convert a report that has an attached library, convert the .pll
files attached to the report before converting the .rdf/.rex
file.Create a PL/SQL script that batch registers reports in Oracle Portal
In some cases, rwconverter
automatically compiles the report's PL/SQL as part of the conversion process. Provided your conversion destination is not a .rex file, rwconverter
automatically compiles PL/SQL under the following conditions:
Converting to a .rep
file. If there are compile errors, rwconverter
displays an error message and the .rep file is not created.
Using a .rex
file as the source. If there are compile errors, rwconverter
displays a warning, but the conversion continues.
Using a report created on another platform than the source. If there are compile errors, rwconverter
displays a warning, but the conversion continues.
In all other situations, you must compile the report's PL/SQL yourself (for example, using Program > Compile > All in Oracle Reports Builder).
Note:
Fonts are mapped when a report is opened by Oracle Reports Builder or Reports Runtime, not during the conversion.Refer to Table A-1 for the keywords that can be used with rwconverter
.
Example:
rwconverter scott/tiger@mydb stype=rdffile source=inven1.rdf dtype=xmlfile dest=inven1_new.xml
rwservlet
(Oracle Reports Servlet) translates and delivers information between either a Web server or a Java EE Container (for example, Oracle WebLogic Server) and the Reports Server, allowing you to run a report dynamically from your Web browser. Optionally, it can use the in-process Reports 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.
The keywords used with rwservlet
are also known as Web commands. Oracle Reports 11g Release 1 (11.1.1) introduces security access levels for rwservlet
Web commands, based on two categories:
End user Web commands are: GETJOBID, KILLJOBID, SHOWAUTH, SHOWJOBID.
Administrator-only Web commands are: DELAUTH, GETSERVERINFO, KILLENGINE, PARSEQUERY, SHOWENV, SHOWJOBS, SHOWMAP, SHOWMYJOBS.
Administrators are allowed to run both end user and administrator-only Web commands. For a non-secured server, the user ID and password for administrators can be set in the identifier element of the Reports Server configuration file.
The security access levels are specified using Oracle Enterprise Manager, as described in Section 7.8.4, "Defining Security Policies for Web Commands":
Note:
When you userwservlet
to run a JSP, you can use all keywords applicable to rwservlet
. For more information on running a JSP with rwservlet
, see Section 18, "Running Report Requests".Note:
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.Refer to Table A-1 for the keywords that can be used with rwservlet
.
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+
DESTYPE=printer+
DESNAME=myprinter
Example 4: Sending report output to e-mail
http://myias.mycomp.com:7779/reports/rwservlet? server=myrepserv+report=test.rd
f+userid=scott/tiger@mydb+desformat=pdf+
DESTYPE=mail+
DESNAME="emp1@co
mp.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 Oracle Portal WebDAV)
http://myias.mycomp.com:7779/reports/rwservlet? server=myrepserv+report=test.rd
f+userid=scott/tiger@mydb+desformat=htmlcss+
DESTYPE=webdav+
DESNAME="h
ttp://myusername:mypassword@mywebdavserv.com/mydir/test.html"
Example 6: Sending report output to Oracle Portal
http://myias.mycomp.com:7779/reports/rwservlet? server=myrepserv+report=test.rd
f+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=myjdb
cpdstest.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, 2007 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 map file (for more information, see Section 18.13, "Using a Key Map 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+user
id=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+user
id=scott/tiger@mydb+destype=file+desformat=pdf+desname=test.pdf+
JOBTYPE=rw
url+URLPARAMETER="http://www.oracle.com"
Example 16: Showing the environment information for server myrepserver
http://myias.mycomp.com:7779/reports/rwservlet/
SHOWENV? server=myrepserver+authid=myrepuser/myreppassword
Example 17: Viewing the past jobs information for server myrepserver
http://myias.mycomp.com:7779/reports/rwservlet/
SHOWJOBS?server=myrepserver+authid=myrepuser/myreppassword
+queuetype=past
Example 18: Viewing the cgicmd.dat
key mappings (for more information, see Section 18.13, "Using a Key Map File")
http://myias.mycomp.com:7779/reports/rwservlet/
SHOWMAP?authid=myrepuser/myreppassword
Example 19: Viewing current jobs information for user myrepuser
http://myias.mycomp.com:7779/reports/rwservlet/
SHOWMYJOBS? server=myrepserver+authid=myrepuser/myreppassword
+queuetype=current
Example 20: Getting the status of a job with job ID 30
http://myias.mycomp.com:7779/reports/rwservlet/
SHOWJOBID30? server=myrepserver+authid=myrepuser/myreppassword
Example 21: Cancelling a currently running job with job ID 122
http://myias.mycomp.com:7779/reports/rwservlet/
KILLJOBID122? server=myrepserver+authid=myrepuser/myreppassword
Example 22: 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 23: Showing DB authentication page
http://myias.mycomp.com:7779/reports/rwservlet/
SHOWAUTH? server=myrepserver+authid=myrepuser/myreppassword
+authtype=D
Example 24: Deleting cookies set by rwservlet
http://myias.mycomp.com:7779/reports/rwservlet/
DELAUTH? server=myrepserver+authid=myrepuser/myreppassword
Example 25: 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 26: Displaying server information for server myrepserver
http://myias.mycomp.com:7779/reports/rwservlet/
GETSERVERINFO? server=myrepserver+authid=myrepuser/myreppassword
Example 27: Killing engine rwEng-1
in server myrepserver
http://myias.mycomp.com:7779/reports/rwservlet/
KILLENGINE1? type=rwEng+server=myrepserver+authid=myrepuser/myreppassword
rwserver
(Reports Server) processes client requests, which includes ushering them through its various services, such as authentication and authorization checking, scheduling, caching, and distribution (including distribution to pluggable output destinations). Reports Server also spawns runtime engines for generating requested reports, fetches completed reports from the reports cache, and notifies the client that the job is ready.
Refer to Table A-1 for the keywords that can be used with rwserver
.
To manage Reports Server using Oracle Enterprise Manager, refer to Chapter 7, "Administering Oracle Reports Services Using Oracle Enterprise Manager".
For manual configuration, see Section 8.2, "Reports Server Configuration File".
rwbridge
(Oracle Reports Bridge) is used when Reports Server and Oracle Reports Client are in different Farms. Oracle Reports Client uses the default broadcast mechanism for server discovery, which sends packets that can travel only within a Farm. The Oracle Reports Bridge can bridge two Farms in a network. It intercepts the packets broadcast by Reports Server and Oracle Reports Client and transfers them to the remote bridges configured in the Oracle Reports Bridge configuration file.
There are no command line keywords for rwbridge
.
To configure the Oracle Reports Bridge, refer to Section 7.5, "Configuring Oracle Reports Components".
To start and stop the Oracle Reports Bridge, see Chapter 6, "Starting and Stopping Oracle Reports Services".