42 Building a Simple Parameter Form for a JSP-based Web Report

In this chapter, you will learn about JSP-based Web reports that include a simple Parameter Form. To build a Parameter Form for a paper report, refer to the Oracle Reports online Help. By following the steps in this chapter, you can generate the report output shown in Figure 42-1 and Figure 42-2.

Figure 42-1 JSP Parameter Form

Description of Figure 42-1 follows
Description of "Figure 42-1 JSP Parameter Form"


The JSP Parameter Form in this image enables the user to choose from a list of departments, connect to a database, then run a report based on the selected parameters.

Figure 42-2 JSP-based Web report based on a user parameter

Description of Figure 42-2 follows
Description of "Figure 42-2 JSP-based Web report based on a user parameter"


The JSP-based Web report in this image displays a graph and a tabular report based on the department selected in the JSP Parameter Form. To see how this report was built, refer to the Oracle Reports Tutorial.


Example Scenario

In this example, you have an existing JSP-based Web report that shows a bar graph of employee salaries per department, as well as a tabular report that shows the employee details. Your customers want to see the employee information for a specific department at runtime, so that they do not have to read the data for all departments. The steps in this example show you how to add a JSP Parameter Form to this JSP-based Web report.

This example uses the resulting report from the Oracle Reports Tutorial. If you want to learn how to build the Web report that we use in this example, follow the steps in the tutorial.

As you build this example report, you will:

To see a sample JSP-based Web report that includes a simple Parameter Form, open the examples folder named simplejsppf, then open results\emprev_param.jsp. For details on how to open it, see "Accessing the Example Reports" in the Preface. The example files used in this chapter are listed and described in Table 42-1.

Table 42-1 Example report files

File Description


An example HTML Parameter Form, which contains an example List of Values, a field, and a button.


This JSP-based Web report contains the modifications to the Parameter Form you will make in Reports Builder.


The source Web report that will become the target report for the Parameter Form.


The final JSP-based Web report with a JSP Parameter Form.


If you completed the exercises in the Oracle Reports Tutorial, you can also use the emprevb_your_initials.jsp file you created at the end of Chapter 6.