You can design a Parameter Form for both Web and paper reports. However, at runtime, the Runtime Parameter Form displays only when running the paper report layout. For JSP-based Web reports, the Runtime Parameter Form displays when you run your report within Reports Builder for debugging purposes, but will not display at runtime.
Because you now have the flexibility to display your reports on any Web page,
the report may be just one object on a Web page containing many other portlets
and objects, and parameters for the report may be retrieved from sources other
than the Parameter Form. For example, parameters might be provided by the Web
page to all portlets on the page. Therefore, it does not make sense to display
a Runtime Parameter Form for JSP-based Web reports before the report is formatted.
In the absence of the Runtime Parameter Form, you will need to use an alternate method to provide required parameters to a JSP-based Web report designed with a Parameter Form. For example:
When you design the report, set all parameters to a default value.
If you run your report using a URL, provide the parameter values through the URL.
Create an HTML form that your report calls to provide parameter values, either as static values, or as a list of values using the Oracle Reports custom JSP tags.
If the report displays as a portlet in a Web page, you can pass the page level parameters to the report.
Use the JSP tag
<rw:reports id="myReport" parameters="yourParameterList">
,
where yourParameterList
can be a Java variable. For
example:
<% String myParameterList = "userid=scott/tiger&p_deptno+10"; %>
<rw:report id="myReport" parameters="<%= myParameterList %>">
For a detailed example of creating a Parameter Form for a JSP-based Web report,
see the chapter titled "Building a Simple Parameter Form for a JSP-Based
Web Report" in the Oracle Reports Building Reports manual, available
on the Oracle Technology Network Oracle
Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html
).
Note: If you display your paper-based report on the Web, you can create an HTML Parameter Form by adding HTML header and footer tags using either:
the Property Inspector: set the Before Form Value property and After Form Value property for the report
PL/SQL: set format triggers using the SRW.SET_BEFORE_FORM_HTML
and SRW.SET_AFTER_FORM_HTML
procedures
About the Paper Parameter Form view
About the Runtime Parameter Form
About Web links for HTML output
About Parameter Form HTML extensions
Creating an HTML Parameter Form header using PL/SQL
Creating an HTML Parameter Form footer using PL/SQL
Creating an HTML Parameter Form header using the Property Inspector
Creating an HTML Parameter Form footer using the Property Inspector
Creating HTML Parameter Form input or select events
Copyright © 1984, 2005, Oracle. All rights reserved.