Sometimes, users want to modify a report's output over a set of conditions. This set of conditions, known as input parameters, can be used to filter a report's output dataset or to modify the report's appearance. This recipe will show how to use an input parameter to obtain different report outputs.
In the previous recipe's report, we colored the store_sales field's background depending on a minimum and maximum threshold value; we use a red background in the case that the cell's value is less than $200 or a green background if the cell's value is greater than $700. The following steps detail how to use input parameters to let the user change the threshold values:
From the Pentaho Report Designer menu, select the Open option under the File menu. The Open file dialog box opens. Go to the
<cookbook_samples>/ch07/resources
directory and selectreport_designer_sample_7.prpt
. Click...