> Task 8: | Create data set parameters and bind them to the report parameters

> In this procedure, you define two data set parameters that correspond to the ? markers in the query. You then bind each data set parameter to the appropriate report parameter. At run time, the data set parameters get the values from the report parameters, and pass the values to the query.

> 1 | In Edit Data Set, choose Parameters. The Parameters page displays two placeholder data set parameters, which BIRT Report Designer created when you modified the query.

> 2 | Define the first data set parameter.

> 1 | Select the first parameter, then choose Edit.

> 2 | On Edit Parameter, specify these values:

> o | In Name, type the following text:

> DSP_quantityinstock

> o | In Data Type, select Integer.

> o | In Direction, select Input.

> o | In Linked to Report Parameter, select RP_quantityinstock. This option binds the data set parameter to the RP_quantityinstock report parameter.

> Figure 12‑20 shows the complete data set parameter definition.

> Figure 12-20 | Definition of the first data set parameter

> 3 | Choose OK to save the data set parameter. The Parameters page displays the edited data set parameter.

> 3 | Define the second data set parameter.

> 1 | Select the second parameter, then choose Edit.

> 2 | On Edit Parameter, specify these values:

> o | In Name, type the following text:

> DSP_productvendor

> o | In Data Type, select String.

> o | In Direction, select Input.

> o | In Linked to Report Parameter, select RP_productvendor.

> Figure 12‑21 shows the complete data set parameter definition.

> Figure 12-21 | Definition of the second data set parameter

> 3 | Choose OK to save the data set parameter.

> The Parameters page, shown in Figure 12‑22, displays the edited data set parameter.

> Figure 12-22 | Parameters page displaying the two data set parameters

> 4 | Choose OK to save your changes to the Products data set.

(c) Copyright Actuate Corporation 2008