9.3 Walkthrough: Adding a Parameter Sheet
You will now add a parameter sheet to the report designed in the previous section, Walkthrough: Designing a Parameterized Report. Follow the steps below:
1. Open the new “Parameter Sheet Report,” and click the Ad Hoc button to enter Ad Hoc mode.

2. Click the 'Parameter' button, located on the Ad Hoc toolbar. This opens the 'Parameter' dialog box.

3. Follow the steps below to add the parameter choice menu, a label, and a Submit button:
a. Drag the 'Parameter' element from the left panel to the parameter layout region. This will be parameter choice menu.
b. Drag the 'Text' element from the left panel to the parameter layout region. This will be the menu label.
c. Drag the 'Button' element from the left panel to the parameter layout region. This will be the Submit button.
4. Position the elements as shown. Make the 'Parameter' element taller by selecting it and then dragging its bottom border downward.

5. Select the text element, right-click, and select 'Properties' from the context menu.

6. Modify the text contents to read “Products.” Click 'OK'.

7. To configure the Parameter element to control the “product” parameter, and to display the appropriate list of products in the parameter sheet menu, follow these steps:
a. Select the Parameter element, right-click, and choose 'Properties' from the context menu.
b. In the 'Name' field, select the parameter that you defined in the filter condition. (In this case, it is “product”.) This will allow the 'Parameter' interface element (menu) to set the filter parameter
c. For the 'Parameter' element label, enter “Product”.
d. For the 'Tooltip' field, enter some text to display when the user hovers the mouse over the input control. For example, type “Select product name.”
e. In the 'Selection List' panel, select 'Query' and click the 'Select' button. This opens the 'Query List' dialog box.

f. Select 'Order Model' from the 'Orders' data source. Select 'Product.Name' for both the 'Label' and the 'Value' field, and click 'OK'.

(Note that you can also specify an expression by clicking the 'fx' button. This expression will then appear as an option in both the 'Value' and 'Label' fields. In addition, you can set conditions to further filter the data from the query before displaying the selection list. See Creating an Expression Column and Filtering for more information on these topics.)
g. Select 'List' as the display type. Click 'OK' exit the 'Parameter Properties' dialog box.
8. Click 'OK' to exit the 'Parameter' dialog box, and return to the report.
9. Click the 'Save' button to save the new parameter sheet along with report.
10. Verify that the parameter sheet is now functional:
a. Click the report in the Repository tree. You should now be prompted for the 'Product' parameter using the parameter sheet you just created.
b. Select the first three products and click 'Submit'.

The report is now filtered based on your input.


You can further modify the parameter sheet by clicking the 'Parameter' button in the Ad Hoc toolbar.
| << 9.2 Walkthrough: Designing a Parameterized Report | © 1996-2013 InetSoft Technology Corporation (v11.5) | Report Scripting >> |