To run a report with Express data on the Web, perform the following steps:
When a report that contains Express data is deployed to the Web, no Express Server login box is displayed. Thus, you must create a Parameter Form to allow the end user to enter a host name, user ID, and password.
To create a Parameter Form for a report that contains Express data:Open Reports Builder and the report that you want to deploy to the Web.
OESHOST
, OESUSER
, and OESPASSWORD
.
For the steps to do this, refer to the topic "Creating a user parameter"
under How To > Work with Parameters and the Parameter Form
on the Contents tab of this online help.Choose Tools>Parameter Form Builder, then in the Parameter Form Builder, click the three parameters that you created, and modify the parameter labels as desired.
Click OK to display the Paper Parameter Form view with your default Parameter Form.
Map the values entered by the end user to your user-defined parameters. To do so, complete the following steps.
In the Object Navigator, expand the Paper Parameter Form node, then the Fields node.
For each new parameter, double-click the properties icon to display the Property Inspector.
To deploy a report that contains Express data for use with the Reports Server
(for example, for running over the Web), you must include the EXPRESS_SERVER
command line keyword. For example:
EXPRESS_SERVER="SERVER=ncacn_ip_tcp:my_express_server/sl=1/st=1/ct=0/sv=1/"
where
my_express_server
is the host name of the machine
that is running Express Server.
To set the value of EXPRESS_SERVER
command line keyword during
report execution, after the end user has entered the host name, user ID, and
password on the Runtime Parameter Form, perform the following steps:
In the Object Navigator, expand the Report Triggers node, then double-click the PL/SQL for AFTER PARAMETER FORM.
Add the following code in the Program Unit editor to define a value for
the EXPRESS_SERVER
command line keyword:
function AfterPForm return boolean is
begin
null;
:express_server:='server=ncacn_ip_tcp:'||
:OESHOST||
'/sl=-1/st=1/ct=0/sv=1/'||
'user='||
:OESUSER||
'/password='|
:OESPASSWORD|
'/';
return (TRUE); end;}
Compile the code, fix any errors, then save all the changes to the report.
Add a line such as the following to the CGICMD.DAT
file to
run the report over the Web. Replace the sample information with your Oracle
database and Reports Server connection information. The %P
argument displays the Parameter Form that you defined in the previous steps.
expresstest: report=myreport.rdf server=repserver desformat=htmlcss
destype=cache %P
About configuring the Express data source
Copyright © 1984, 2005, Oracle. All rights reserved.